Provide a list of all accounts with this criteria
 

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

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

Provide a list of all accounts with this criteria
 

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

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



No more information here than your previous post, so I'll give my same response:


Try either AutoFilters or PivotTables.

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

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



If you need more help, provide more information.

Provide a list of all accounts with this criteria
 

You can use AutoFilter as follows:

In an unused column enter:

=AND(OR(A2={23,83,849,759}),AL2="RESEARCH") and copy down

The cells will show TRUE if the criteria have been met. If you switch on
AutoFilter on this column and select TRUE in the pull-down, only the good
rows will be visible.
--
Gary''s Student - gsnu201001


"Senor Martinez" wrote:

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

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

Provide a list of all accounts with this criteria
 

Hi,

In Help look at Advanced Filters. This may be what you are looking for.

HTH,
JCS

"Senor Martinez" wrote:

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

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