MEANING WIN OR LOSS

HOW DO I COUNT 2 WINS OR 2 LOSSES? TO PUT ANSWER IN SINGLE CELL!

As we all know, to compare if two cells are equal, we can use the formula A1=B1. But, if you want to check if multiple cells have the same value, this formula will not work. Today, I will talk about some formulas to compare if multiple cells are equal in Excel.

**Compare if multiple cells are equal with formulas**

Supposing I have the following data range, now I need to know if the values in A1:D1 are equal, to solve this task, the following formulas will help you.

**1**. In a blank cell besides your data, please enter this formula: **=AND(EXACT(A1:D1,A1))**, (**A1:D1** indicates the cells that you want to compare, and **A1** is the first value in your data range)see screenshot:

**2**. Then press **Ctrl + Shift + Enter** keys together to get the result, if the cell values are equal, it will display **TRUE**, otherwise, it will display **FALSE**, see screenshot:

**3**. And select the cell then drag the fill handle to the range that you want to apply this formula, you will get the result as follows:

**Notes:**

1. The above formula is case sensitive.

2. If you need to compare the values without case sensitive, you can apply this formula: **=COUNTIF(A1:D1,A1)=4**, (**A1:D1** indicates the cells that you want to compare, **A1** is the first value in your data range, and the number **4** refers to the number of cells that you want to check if), then press **Enter** key, and you will get the following result:

**Compare two ranges and find if the cells are equal or not**

With** Kutools for Excel**’s **Compare Cells** utility, you can quickly find the same or different values between two cells.** Click to download Kutools for Excel!**

**Kutools for Excel**: with more than 300 handy Excel add-ins, free to try with no limitation in 30 days.** Download and free trial Now! **

**Related article:**

How to check if the number is integer in Excel?

**Reuse**: Quickly insert**complex formulas, charts**and anything that you have used before; Encrypt Cells with password; Create Mailing List and send emails...- Super Formula Bar (easily edit multiple lines of text and formula); Reading Layout (easily read and edit large numbers of cells); Paste to Filtered Range...
- Merge Cells/Rows/Columns without losing Data; Split Cells Content; Combine Duplicate Rows/Columns... Prevent Duplicate Cells; Compare Ranges...
- Select Duplicate or Unique Rows; Select Blank Rows (all cells are empty); Super Find and Fuzzy Find in Many Workbooks; Random Select...
- Exact Copy Multiple Cells without changing formula reference; Auto Create References to Multiple Sheets; Insert Bullets, Check Boxes and more...
- Extract Text, Add Text, Remove by Position, Remove Space; Create and Print Paging Subtotals; Convert Between Cells Content and Comments...
- Super Filter (save and apply filter schemes to other sheets); Advanced Sort by month/week/day, frequency and more; Special Filter by bold, italic...
- Combine Workbooks and WorkSheets; Merge Tables based on key columns; Split Data into Multiple Sheets; Batch Convert xls, xlsx and PDF...
- More than 300 powerful features. Supports Office/Excel 2007-2019 and 365. Supports all languages. Easy deploying in your enterprise or organization. Full features 30-day free trial. 60-day money back guarantee.

**Enable tabbed editing and reading in Word, Excel, PowerPoint**, Publisher, Access, Visio and Project.- Open and create multiple documents in new tabs of the same window, rather than in new windows.
- Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!

Loading comment...
The comment will be refreshed after 00:00.