D
donh
Hi
I have 12 tables each consisting of 2 rows and 31 columns max. Each
table details the date in the top row and number of staff at work in
the bottom row. So all 12 cover number of staff at work for year.
I need to identify the dates where staff numbers fall below 4 and
compile this into a list of dates where this occured. 12 seperate
lists would be fine.
I've looked through my formulas that this group has helped me with and
modified one that identifies the column number where workers fall
below 4 but cant get a formula to work that would lookup the
corresponding row and transpose it into a listed table.
=IF(ISNUMBER(MATCH(E19,{0;1;2;3},0)),COLUMN(),"")
As always any help would be appreciated
DonH
I have 12 tables each consisting of 2 rows and 31 columns max. Each
table details the date in the top row and number of staff at work in
the bottom row. So all 12 cover number of staff at work for year.
I need to identify the dates where staff numbers fall below 4 and
compile this into a list of dates where this occured. 12 seperate
lists would be fine.
I've looked through my formulas that this group has helped me with and
modified one that identifies the column number where workers fall
below 4 but cant get a formula to work that would lookup the
corresponding row and transpose it into a listed table.
=IF(ISNUMBER(MATCH(E19,{0;1;2;3},0)),COLUMN(),"")
As always any help would be appreciated
DonH