toony
New member
I have the below formula and adding one more count ($C$1000:$C$10000,$C1808), which is basically to count the times that a duplicated value appears per day (so as not to repeat it if same value on a different day), but it only works on the first line. Once I drag it down if gives me #######. Could it be because of the dollar signs o because it is an arrow formula?
=IF($E1808="","",IF(AND($AQ1808>=1,$AJ1808=""),"1",IF(COUNTIF($AJ$1000:$AJ1808,$AJ1808)=1,COUNTIFS($AJ1808:$AJ$10000,$AJ1808,$AQ1808:$AQ$10000,">"&0),"")))
So, the whole formula ends up like below, and the red part is what I have added. The added counting is basically the date column (several rows each day):
=IF($E1808="","",IF(AND($AQ1808>=1,$AJ1808=""),"1",IF(COUNTIF($AJ$1000:$AJ1808,$AJ1808)=1,COUNTIFS($A$1808:$A$10000,$A1808,$AJ1808:$AJ$10000,$AJ1808,$AQ1808:$AQ$10000,">"&0),"")))
=IF($E1808="","",IF(AND($AQ1808>=1,$AJ1808=""),"1",IF(COUNTIF($AJ$1000:$AJ1808,$AJ1808)=1,COUNTIFS($AJ1808:$AJ$10000,$AJ1808,$AQ1808:$AQ$10000,">"&0),"")))
So, the whole formula ends up like below, and the red part is what I have added. The added counting is basically the date column (several rows each day):
=IF($E1808="","",IF(AND($AQ1808>=1,$AJ1808=""),"1",IF(COUNTIF($AJ$1000:$AJ1808,$AJ1808)=1,COUNTIFS($A$1808:$A$10000,$A1808,$AJ1808:$AJ$10000,$AJ1808,$AQ1808:$AQ$10000,">"&0),"")))