LinkBack URL
About LinkBacks
hi ,
I want to count all the PO# in a particular date in the attached sheet.
hi ,
I want to count all the PO# in a particular date in the attached sheet.
Hi, try add a helper column D to fill up all the empty date D5=IF(ISBLANK(A5),D4,A5) copy down the formula to D596
Next select E5:E596, press F2, key in =FREQUENCY(INT(D5:D597),INT(D5:D597)) and press Ctrl+Shift+Enter
excel-forum.JPG
In D5
=IF(A5="","",MATCH(TRUE,INDEX(A6:$A$600<>"",0),0))
Copy down
Life's a spreadsheet, Excel!
Say thanks, Click *
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks