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 352 views

## 1 answer to this question.

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