I have the formulae =COUNTIF($F$2:F2,F2),"") to count the first, second, third and so on in a column based on one condition. How can I add another condition and still get the first, second occurance of the column? I have tried countifs but get the #value error.
Thanks,
Lee