View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sam via OfficeKB.com Sam via OfficeKB.com is offline
external usenet poster
 
Posts: 247
Default Search Multiple columns for criterion asterisk (*) and Return Numeric Label

Hi Domenic,

Domenic wrote:
It looks like some cells contain one asterisk and other cells contain
two asterisks. Is this correct?


Yes

If so, does this mean that while your criterion is one asterisk that you'd like to return the numeric labels
for any row whose cells contain one or two asterisks?


Yes

Sorry, I did not make that clear.

I thought using this:
4. To search for criterion "~**" (Tilde ** in quotation marks)
as my criterion would capture multiple asteriks in a cell.

Cheers,
Sam



Hi All,

[quoted text clipped - 33 lines]
Thanks
Sam


--
Message posted via http://www.officekb.com