using which formula?

  • Thread starter Thread starter dianan
  • Start date Start date
D

dianan

hi, I am very new here, and I am not a expert in excel either.
Would you please help me this problem:

Employee Name shift

Steve Cothern am
Joseph Livingston pm
Michael Balzer am
Eric Harrison pm

I would like to display all employees that in "am" shift, and "pm
shift. Which formula should I use?

Thanks a lot
 
dianan > said:
hi, I am very new here, and I am not a expert in excel either.
Would you please help me this problem:

Employee Name shift

Steve Cothern am
Joseph Livingston pm
Michael Balzer am
Eric Harrison pm

I would like to display all employees that in "am" shift, and "pm"
shift. Which formula should I use?
Click to expand...

Do you need to use a formula? Would it be ok to just sort the list by
"shift" then have all AM come before all PM?

Another thing you can do, is select your data (including name and shift)
then go to Filter>autofilter, and then select AM or PM. you can then copy
those, or whatever.
 
No formula really needed. Click the "Data" menu, select "Filter", "Auto
Filter". Dropdown arrows will appear. Click the category you want to
filter and select the criteria (am, or pm). Those will now be the only ones
to show. You can add additional filters (notice the dropdown arrow turns
"blue" when being filtered.

Bill Foley
www.pttinc.com
 
I think I must use formula. The page has more information, but I just
list out the part that I can't solve. I have "data entry" sheet. On
other sheet, I use vlookup and other simple formula.

Thanks,
 
dianan > said:
I think I must use formula. The page has more information, but I just
list out the part that I can't solve. I have "data entry" sheet. On
other sheet, I use vlookup and other simple formula.
Click to expand...


Maybe one of the experts will jump in. I think I remember seeing a formula
that would look through a list like this, and you could copy the formula
down until you see #NA, and that will be a list from the bigger list.

It's not an 'easy' formula as I remember.

The explanation of your problem hasn't gotten any clearer.. consider adding
more information, and what you're trying to get as a result.
 
Dave,

Give this a try.
With Sample Data in A1:B8

In C1:
=INDEX(A1:A$8,MATCH("am",B1:B$8,0))
In C2:
=INDEX(INDIRECT("A"&MATCH(C1,A$1:A$8,0)+1&":A$8"),
MATCH("am",INDIRECT("B"&MATCH(C1,A$1:A$8,0)+1&":B$8"),0))

Drag Down the formula in C2

Change the ranges to suit your data

Dan E
 
Can't you just use autofilter?
Highlight the top row with Employee Name, shift for both
columns>Data>filter>autofilter>
 
Back
Top