Criteria in Advanced Filter

  • Thread starter Thread starter keyur
  • Start date Start date
K

keyur

Hi!

I have list of numbers where some of them are in 10digit
in the format 10*00. Apparently i can only filter the list
by either 10* or *00. how can i include both at once.

thanks
 
Use a formula


=A2="10*00"

assume you put that in H2 (leave H1 blank)

where A2 is the first cell with a value (A1 I assume is the header)

use H1:H2 as criteria range
 
Sorry i didnt quite get it. in my table i have 11 columns
and the numbers are in 5th column. so i am using my
criteria range as A2:K3, and my list range is A5:K2362
(Where 2nd and 5th row have same column headings). so
where exactly should i put this formual.

thanks again
 
Back
Top