Return only if colum B's data begin with specific letter or simple?

  • Thread starter Thread starter coldasice
  • Start date Start date
C

coldasice

Hi, I hope you understand what I'm trying to explain, my English is not
that good, Sorry.

I have multiple sheets in one workbook, all my data in sheet1.. now,
what I'm trying to do is on sheet2 I want to return all rows if colum
B's data/name begin with specific simple like "*" for instand, or a
letter.. and on sheet3 I want to return all rows without specific
simples or letters opposition of what I'm doing in sheet2..

Your help is very appreciate! Thanks
 
Coldasce,

If I understand you correctly, check out Advanced filter. You will have to
start the filter from the sheet that you want the filtered data on and if
you want to use * as a criteria then you will have to enter it as ~* to stop
Excel from returning all entries in that column.

HTH

Sandy
 
Figured it out..

Here is how I did it incase some one has the same question.

=IF(LEFT(sheet1!B3,1)="letter",sheet1!A3,"")

where my data begin at B3, "letter" is begin letter I want to look up

then I go to edit>> Fill>> Right to fill all the cells needed data fro
sheet1. I don't know if this is a best way but It works for me
 
Back
Top