Formula to compare 2 columns and count missing values
Closed
Mikey150
Posts
1
Registration date
Wednesday April 20, 2022
Status
Member
Last seen
April 20, 2022
-
Updated on May 10, 2022 at 11:29 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - May 5, 2022 at 08:07 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - May 5, 2022 at 08:07 PM
Related:
- Formula please
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Excel grade formula - Guide
- Date formula in excel dd/mm/yyyy - Guide
- Number to words in excel formula - Guide
- Credit summation formula - Guide
2 responses
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Apr 22, 2022 at 04:36 PM
Apr 22, 2022 at 04:36 PM
Mikey150, good afternoon.
Suppose:
1st Column: A1:A100
2nd Column: D1:D100
Try to use:
B1 -->
Copy down as necessary.
Please, tell us if it works as you want.
I hope it helps.
Suppose:
1st Column: A1:A100
2nd Column: D1:D100
Try to use:
B1 -->
=IF(COUNTIF($D$1:$D$100;A1)=0; "...Missing..."; "")
Copy down as necessary.
Please, tell us if it works as you want.
I hope it helps.
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
May 5, 2022 at 08:07 PM
May 5, 2022 at 08:07 PM
I think MATCH would be better
in column C2 you can add some thing like this (assuming row 1 is header of sheet)
=IFERROR(MATCH(A2, B$2:B$1000,0),"Not Found")
in column C2 you can add some thing like this (assuming row 1 is header of sheet)
=IFERROR(MATCH(A2, B$2:B$1000,0),"Not Found")