Just had some help from you guys (Pete's the man!) who came up with the following Formula which works perfectly.
=IF(COUNTIF(C1:L18,A1),A1,"")
How can i add an AND function to this?
I want to Cell to Run the COUNTIF function above and Only display the TRUE result (A1) when A1 is withing the range C1:L18 AND D10>0 (the value in D10 is greater than 0)
Really aprreciate your help!
Bookmarks