Hello everyone,
Excel 365 Apps for enterprise
I am using a formula to filter column O when a value is used when selecting it in a data validation column B.
Formula : =FILTER(Tel,COUNTIF(B7:B21,Tel)=0) is in cell P8.
I would like to modify this formula when in column H a certain value is show ("Return") that the value used in column B becomes visible back in column P (unfilter column P).
Thanks in advance for the big help.
Kind regards
Krypt
Excel 365 Apps for enterprise
I am using a formula to filter column O when a value is used when selecting it in a data validation column B.
Formula : =FILTER(Tel,COUNTIF(B7:B21,Tel)=0) is in cell P8.
I would like to modify this formula when in column H a certain value is show ("Return") that the value used in column B becomes visible back in column P (unfilter column P).
Thanks in advance for the big help.
Kind regards
Krypt