Good morning in the attached file you find a table with names in column B and values in column C.
Choosing a name in F1 with the formula aggregate I find all the values of that name in F1 correctly.
I would like to have the result of column G but in row order it is now 3.1.9 should be 1.3.9.
Thank you
Try
F2Formula:
Please Login or Register to view this content.
G2Formula:Please Login or Register to view this content.
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Was going to post the above answer, for information Berna, your formula goes wrong because it chooses the smallest value 12 first, not the smallest row 1. The above fixes that
Ok, thank you very much
the one that interested is the 2 in G2
Thanks again for the next one
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks