Hi there
I am trying to change my formula so that rather than a False message the cell is Blank
how can I go about doing this? the original formula is
=IF(AND(B3<>B2,D3<>D2),COUNTIF($G$3:$G$518201,G3))
I have changed the formula to
=IFERROR(IF(AND(B3<>B2,D3<>D2),COUNTIF($G$3:$G$518201,G3)),"")
but this is still not working.
Any help would be appreciated
Many thanks
Ian
Bookmarks