Dear Sirs,
I'm trying to Count the number of effective dates of selling, however, each day has more than 1 insertion and the other insertions with the same date shall not be counted.
Herein attached is the file for your perusal and the worksheet name is: Vendas Cozinha Column A.
Kind regards
Fausto
Last edited by Faustocruz; 05-09-2019 at 06:51 AM. Reason: Cannot insert the attachement
Fausto Cruz
No file attached ( use Go advanced manage attachments)
Lots of articles about this problem, like https://support.office.com/en-us/art...0-a929fbc1e273
Please try the following:
Formula:
Please Login or Register to view this content.
This gives a result of 26 distinct dates on which a sale was made, which I think is what you were looking for.
Let me know if this works for you.
Dear Sir,
it worked 100%.
Many thanks for your help on this one.
Kind regards
Fausto
No problem, glad to help. Thanks for the feedback and rep
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks