Thread
:
Range? M1:Z1
View Single Post
#
4
Posted to microsoft.public.excel.misc
Don Guillett
Posts: n/a
Range? M1:Z1
if dd in f4 and dd anywhere in col d, deal
=IF(COUNTIF(D:D,F4)0,"deal","no deal")
--
Don Guillett
SalesAid Software
"nastech" wrote in message
...
Hi, can not remember how to see if 1 cell, is equal to same quantity in
range
of other cells. Tried / to find: (thanks)
=F1=M1:Z1 getting ref error
Reply With Quote