Provide a list of all accounts with this criteria

[Senor Martinez]

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

 

[Glenn]

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.

 

[JCS]

Hi,

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

HTH,
JCS

 

[Gary''s Student]

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.