Thread: An old chestnut: finding the last cell in a range
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
maninashed[_2_] maninashed[_2_] is offline
external usenet poster
  
Posts: 3
Default An old chestnut: finding the last cell in a range
Hi Bob

The formula I'm using is:

=IF(COUNT(D21,F21,H21)0,"Y","")

Thanks for your time.

Mark
Reply With QuoteReply With Quote