View Single Post
  #6   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,

Correction:
Criterion is multiple asteriks
4. To search for criterion "~**" (Tilde ** in quotation marks)


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


Cheers,
Sam

Sam wrote:
Hi Domenic,


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


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200607/1