Provide a list of all accounts with this criteria

  • Thread starter Thread starter Senor Martinez
  • Start date Start date
S

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
 
Senor said:
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
Click to expand...


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.
 
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.
 
Back
Top