ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Provide a list of all cells that meets this criteria (https://www.excelbanter.com/excel-worksheet-functions/256835-provide-list-all-cells-meets-criteria.html)

Senor Martinez[_2_]

Provide a list of all cells that meets this criteria
 
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

Pete_UK

Provide a list of all cells that meets this criteria
 
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



Glenn

Provide a list of all cells that meets this criteria
 
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

Senor Martinez[_2_]

Provide a list of all cells that meets this criteria
 
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


All times are GMT +1. The time now is 12:34 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com