G
Guest
Column 'Q' contains a list of submission dates
Column 'I' contains 3 geographic areas:- new-extension, both and re-config
I need to post in columns 'R' & 'S' the dates from column 'Q' when the following conditions prevail:
When column 'I' contains 'new-extension' or 'both' then column 'R' should show the date from Column 'Q
When column 'I' contains 're-config' or 'both' then column 'S' should show the date from Column 'Q
When no date is shown, then nothing should be indicated in the cell
Is there a formula/function to match things
Any help would be appreciated
Thank
Ando
Column 'I' contains 3 geographic areas:- new-extension, both and re-config
I need to post in columns 'R' & 'S' the dates from column 'Q' when the following conditions prevail:
When column 'I' contains 'new-extension' or 'both' then column 'R' should show the date from Column 'Q
When column 'I' contains 're-config' or 'both' then column 'S' should show the date from Column 'Q
When no date is shown, then nothing should be indicated in the cell
Is there a formula/function to match things
Any help would be appreciated
Thank
Ando