Need a "Find Next" Formula
hi, Matt !
other option is an [CSE] array-entered formula in monday sheet [B1] and copy-down:
=index(day!a:a,small(if(day!$b$1:$b$4=a1,row(day!$ b$1:$b$4)),countif($a$1:a1,a1)))
hth,
hector.
I am creating a schedule spreadsheet with sheets for everyday of the week and the shifts.
On the sheet listed "Day" I have Names in column A, Sections in column B (ex would be W, E, HLS).
On the sheet "Monday" in column A is a list of sections (ex is W,W and E,E).
I need to have the various names listed by the assigned areas.
Before After Forumla
Sheet Day Sheet Monday Sheet Monday
Col A Col B Col A Col B Col A Col B
Jon W W W Jon
Pam E W W Tom
Tom W E E Pam
Nick E E E Nick
I could use the following formula in Monday B1 but it would return the same name in B2.
=IF(ISNA(MATCH(A1,Day!$B$1:$B$4,FALSE)),"",INDEX(D ay!$A$1:$A$4,MATCH(A1,Day!$B$1:$B$4,0)))
Can I nest a Row formula +1?
|