Looking for a formula to do a count of column D. My best attempt so far is column E. I need a count that does not repeat as shown in column G.
Jim O
Looking for a formula to do a count of column D. My best attempt so far is column E. I need a count that does not repeat as shown in column G.
Jim O
Last edited by JO505; 09-25-2015 at 03:49 PM.
Looks like you want a progressive total?
Try this...
=IF($D3="",0,COUNTIF(D$3:D3,D3)+MAX($E$2:E2))
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Ford,
Thanks very much. That is what I was looking for.
Jim O
PS
daffodil11,
I did not see your post before I posted. I like that solution better.
Thanks to both of you.
Jim O
Last edited by JO505; 09-25-2015 at 03:54 PM. Reason: did not see second post in time.
So close.
=IF($D3<>"",COUNTIF(E$2:E2,">"&0)+1,0)
Make Mom proud: Add to my reputation if I helped out!
Make the Moderators happy: Mark the Thread as Solved if your question was answered!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks