Hello. In this formula =IF(ISERROR(MATCH(C5,C6:C5000)),IF(COUNTIFS(C:C,C5,E:E,">"&4)=0,"No","Yes"),"") why does the > sign need to go in "" and why do I have to add the & before the 4? Thanks.
Hello. In this formula =IF(ISERROR(MATCH(C5,C6:C5000)),IF(COUNTIFS(C:C,C5,E:E,">"&4)=0,"No","Yes"),"") why does the > sign need to go in "" and why do I have to add the & before the 4? Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks