Generating continuous lists using lookups

D

DavidObeid

This problem may have already been answered, but if I have a list of
outcomes in column A (complete, in progress, abandoned) with a list of
job names in column B, can I generate a formula that will list all of
the complete jobs in column C with no gaps in between rows?

Eg:

A B C
1 complete reports
2 in progress timetable
3 complete registration
4 abandoned resource file

What formula can go in column C to list reports and registration in
rows 1 and 2?

Regards,

Dave
 
B

Bob Umlas, Excel MVP

Assuming your data starts in A1, enter this in D2 (Col D isn't important, but row 2 is)
=MATCH("complete",OFFSET($A$1,D1,0,100,1),0)+D
Fill this down as far as you'd like. In E2, enter
=IF(ISNA(D2),"",INDEX(B:B,D2)) and also fill down
Hide column D, and you're all set


----- DavidObeid wrote: ----


This problem may have already been answered, but if I have a list o
outcomes in column A (complete, in progress, abandoned) with a list o
job names in column B, can I generate a formula that will list all o
the complete jobs in column C with no gaps in between rows

Eg

A B C
1 complete report
2 in progress timetabl
3 complete registratio
4 abandoned resource fil

What formula can go in column C to list reports and registration i
rows 1 and 2

Regards

Dav
 
Top