Posted to microsoft.public.excel.worksheet.functions
|
|
Macros in a cell function
Hi Rob,
A COUNTIF function would probably have been the simplest to implement. For
example:
=COUNTIF($A$2:$A$7,B2)0
Cheers
"broro183" wrote in
message ...
hi all,
RedDragon, does that clarify the function for you?
Macropod, Thanks for the concise explanation. Just out of curiosity,
would you have used Match, or another function (eg vlookup, countif
etc)?
Rob Brockett
NZ
Always learning & the best way to learn is to experience...
--
broro183
------------------------------------------------------------------------
broro183's Profile:
http://www.excelforum.com/member.php...o&userid=30068
View this thread: http://www.excelforum.com/showthread...hreadid=537442
|