I need to count the number of times the first column's values deviate from those of the other column(s), for instance:

```| 103942 | 820 |
| 103942 | 819 |
| 103953 | 819 |
| 103953 | 819 |
| 103953 | 819 |
| 103953 | 819 |
| 103953 | 820 |
| 103956 | 819 |
| 103956 | 819 |
| 103956 | 819 |
| 103956 | 819 |
| 103956 | 819 |
| 103956 | 820 |
| 103956 | 820 |
| 103956 | 819 |
| 103956 | 819 |
| 103956 | 818 |
| 103956 | 818 |
| 103956 | 819 |
| 103956 | 818 |
| 103956 | 819 |
| 103956 | 820 |
| 104157 | 818 |
| 104157 | 819 |
| 104157 | 820 |
| 104978 | 819 |
```

Is possible with only one formula?

Feb 23, 2023 in Others 412 views

Try this :

• Formula used in cell D3

```=LET(x,UNIQUE(A1:A26),
VSTACK({"","Uniques"},HSTACK(x,BYROW(x,LAMBDA(m,SUM((m=A1:A26)/COUNTIFS(A1:A26,A1:A26,B1:B26,B1:B26)))))))```
• 38,010 points

Count Function for identifying the Unique values in Excel

If the 9th row is empty: =COUNTA(UNIQUE(TOCOL(F8:R10)))-1 If not ...READ MORE

Removing duplicates from Excel rows by adding values of some columns

Copy the first three columns to another ...READ MORE

Excel Formula - if values in columns all contain X then return

You can use the AND function: = IF(AND(A3="OK";B3="OK";C3="OK");"everything ...READ MORE

Calculate Birthdate from an age using y,m,d in Excel

Hi To Calculate the date, we can ...READ MORE

Convert Rows to Columns with values in Excel using custom format

1 I having a Excel sheet with 1 ...READ MORE

IF - ELSE IF - ELSE Structure in Excel

In this case, you can use nested ...READ MORE