I dont even know where to begin with this one...

If Row A has the digits 23, 83, 849, 759 and Row AL has the value of
RESEARCH then provide me a list of all the accounts in row B that meets those
standards... any ideas??!! Thanks in advance

I think you are getting your rows and columns mixed up - columns have
letter(s) to identify them and rows are numbered.

That being said, I don't understand what you want to do, so perhaps
you can try to describe your problem again ...

Pete

On Feb 19, 4:12*pm, Senor Martinez
wrote:
I dont even know where to begin with this one...

If Row A has the digits 23, 83, 849, 759 and Row AL has the value of
RESEARCH then provide me a list of all the accounts in row B that meets those
standards... *any ideas??!! *Thanks in advance

Senor Martinez wrote:
I dont even know where to begin with this one...

If Row A has the digits 23, 83, 849, 759 and Row AL has the value of
RESEARCH then provide me a list of all the accounts in row B that meets those
standards... any ideas??!! Thanks in advance

Try either AutoFilters or PivotTables.

http://www.contextures.com/xlautofilter01.html

http://peltiertech.com/Excel/Pivots/pivotstart.htm

Pete you are correct my mistake!!

If Column A has the digits 23, 83, 849, 759 and Column AL has the value of
RESEARCH then provide me a list of all the accounts in Column B that meets
those
standards... any ideas??!! Thanks in advance