Sort numbers

Closed
babu - Sep 12, 2009 at 08:45 AM
venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Sep 12, 2009 at 09:16 PM
Hello,
give the equation to Get the numbers which are in colomnA and not in colomnB,by compairing colomn A&B

1 reply

venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 810
Sep 12, 2009 at 09:16 PM
suppose the data is like this in A1 to B7

57 35
6 82
90 88
21 6
7 30
48 90
61 57

in C1 copy paste this formula

=IF(COUNTIF($B$1:$B$7,A1)>=1,A1,"")
hit enter key
copy C1 down.

see the numbers in column c
0