Hi all,
i have attached the sheet, whereas i need a formula to count unique between the dates with a criteria.
i tries using sum if frequency also but i unable to get the answer.
Hi all,
i have attached the sheet, whereas i need a formula to count unique between the dates with a criteria.
i tries using sum if frequency also but i unable to get the answer.
In E2,
=IFERROR(INDEX($A$2:$A$14,MATCH(0,COUNTIF($E$1:E1,$A$2:$A$14),0)),"")
drag down
For Reference, find sheet
To attach worksheet Go advanced -> Manage attachments -> Choose file -> Upload
Don't forget to Mention your desired result in the sheet..
There should be sample data only, a lot of data creates confusion.
Thanks & Regards
Shivya
http://excelvbatipsforbeginners.blogspot.in/
What are the criteria? Do you want to count all dates, or a range of dates? you rexplanation is incomplete.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Thanks a lot,
But i need a count instead of displaying the date and that too for August month i dont want to count repetitive.
Id NO Amt ID No Amt
319 -4000 319 -4000
425 2000 425
319 2000 753 -6000
753 -6000 754
754
425
753
754
I want to add only negative numbers for respective id no, i have shown the example for that above in right side
Is this the same problem????
Please attach a sample sheet showing YOUR EXPECTED ANSWER. Otherwise we are left guessing, as I do not see what Post 5 has got to do with Post 1...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks