Prev: checking input in a cell and return by copying info from a other c
Next: Merging cells
From: Senor Martinez on 19 Feb 2010 11:12
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
From: Pete_UK on 19 Feb 2010 11:37
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
<SenorMarti...(a)discussions.microsoft.com> 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

From: Glenn on 19 Feb 2010 12:04
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
From: Senor Martinez on 19 Feb 2010 13:31
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
 | 
Pages: 1
Prev: checking input in a cell and return by copying info from a other c
Next: Merging cells