need help writing formula PLEASE

M

mattinCO

Version: 2008
Operating System: Mac OS X 10.4 (Tiger)
Processor: Intel

I need to sort through a column of
13981 items, filtering everything out
that has GB GP or GR in it. Can any one tell
me how to set up a formula to do this task?
thanks-matt
 
B

Bob Greenblatt

Version: 2008
Operating System: Mac OS X 10.4 (Tiger)
Processor: Intel

I need to sort through a column of
13981 items, filtering everything out
that has GB GP or GR in it. Can any one tell
me how to set up a formula to do this task?
thanks-matt
Click to expand...
What do you mean by "Sort through" and "filter"? Why do you think you need a
formula? Did you try to SORT the data on that column? You could then scroll
to the data that contains the values you want? Did you try an advanced
filter? If so, what does it not do that you want to do?
 
M

mattinCO

HI,
kinda new to the ol excel, found what i needed right after i posted. Auto Filter the column! thanks
 
B

Bob Greenblatt

Did you not try my suggestions? I still do not understand what you want to
do.
 
Top