Sort numbers

Closed
babu - Sep 16, 2009 at 01:29 PM
Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 - Sep 16, 2009 at 11:06 PM
Hello,
Thank u for ur reply .

But ,my question was like this

Give the eqn to get the numbers which are in column A but not in coloumn B by comparing coloumns A & B.


The answer that u had given me was the eqn for geting same numbers in column A and coloumn B




Kindly give me a correct reply

1 response

Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 307
Sep 16, 2009 at 11:06 PM
Hello

try this

=IF(COUNTIF($A$1:$A$9,"="&B1)>0,"",B1)
0