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 in Others 69 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)))))))```
• 35,300 points

## 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

## Determine if calculation between 2 date time values is < 72 Hours in excel

Actually, Excel is quite accommodating in this ...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