Hi all,
I have a column of values on one sheet, and another column of values on another sheet.
I would like to hide, in the first column, all the values that also appear in the other column.
All my trials have failed so far.
Thank you in advance
Cris
Hi, if you are able to add a column to sheet1, have a look at the attached, I have matched sheet1 column(A)to sheet2 column(A), where the match fails forced zero in the result. Then created a style with a white font effect and used conditional formatting on the range.
Sheet is LOQ_20191211. A screen shot of the style and conditional formatting are in LOQ_20191211A.
Let us know if it helps.
LOQ_20191211.ods(/upfiles/15760661902641555.ods)LOQ_20191211a.odt