Forum Discussion
INDEX MATCH function, avoid duplicate returns + with criteria
please help me, I am stuck with this formula. I am using index to lookup many Sales Name to a table. but sometimes have someone work-off (column H - Data sheet) so how make the Name Sales work-off...
You can hide values in H10:H45 using Conditional Formatting formula:
=AND(ISNUMBER(H10),J10<>"",H10>DATE(RIGHT(J10,4),MID(J10,4,2),LEFT(J10,2)))
If this formula returns TRUE, apply a Custom Number Format ;;;
=AND(ISNUMBER(H10),J10<>"",H10>DATE(RIGHT(J10,4),MID(J10,4,2),LEFT(J10,2)))
If this formula returns TRUE, apply a Custom Number Format ;;;
