Thanks for your quick response.
Column D is formatted dd.mm.yy
I changed to dd.mmm.yy and inputted your array formula in cell F2. Unfortunately received #Value!
Sorry but I am not familiar with "array formulas"
Could you have another look?
Thanks for your quick response.
Column D is formatted dd.mm.yy
I changed to dd.mmm.yy and inputted your array formula in cell F2. Unfortunately received #Value!
Sorry but I am not familiar with "array formulas"
Could you have another look?
Put on F2 and copie down:
=IF(G2>1," ",(IF(AND(E2=0,G2=0)," ",COUNTIF($E$2:$E$5,"<"&E2))))
That's done it.
Thanks for your help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks