Hello everyone
I have in range("A2:A16") values with duplicates ...In range("B2:B16") I need a formula that search for only last occurrence for the value and count this value
The attachment will illustrate my request better
I appreciate any help
Hello everyone
I have in range("A2:A16") values with duplicates ...In range("B2:B16") I need a formula that search for only last occurrence for the value and count this value
The attachment will illustrate my request better
I appreciate any help
< ----- Please click the little star * next to add reputation if my post helps you
Visit Forum : From Here
Hi
Try these
Formula:Please Login or Register to view this content.
Note: I do not like so many "COUNTIF" but the formula works.
That's amazing Mr. José
Thank you very much for this wonderful help
Regards
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks