Hi all
have another question in regard to my previous post, when the database is empty all cells in question are blank which is correct, but one column has FALSE in it, needs to be blank also with an empty database.
In cell D3 I have the formula which works fine when data is entered
Formula is =IF(COUNTIF($A$3:$A$8,G3),8,IF(COUNTIF($B$3:$B$8,G3),9,IF(COUNTIF($C$3:$C$8,G3),10)))
I look forward to your help
Thanks in advance
M-Tommo
I have attached the database
Bookmarks