I use array formula all the time to do conditional counting, but I'm having trouble specifying the counting of max values.
Per row, I need to count the max number of dates present per ID number
colA = ID number
colB = Date
colC = my formula
As an example I'm using this on row 6, but it is not working as I had hoped:
{=SUM(IF(A:A=A6,IF(MAX(B:B)=B6,1,0)))}
It correctly returns 0 when column B isn't a max value. However when it is the max date it counts all the rows where column A values are equal.
I've been stuck on this for a while. Please can someone help me?
Kind regards,
Rob
Bookmarks