Sort numbers [Closed]

Report
-
Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
-
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 reply

Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
307
Hello

try this

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