Hi!
First time here.... I have a huge list of article numbers, first column. I need a formula to deliver the highest number for each art no, when there are several rows for the art, I am doing this manually now.... i.e. the third column, anyone knows how to do this?
Sorry for not managing getting the columns in a structured way but I hope you understand what I mean.
Thanks in advance...
br Lotta
Art No Number Highest number for each article no.
40309304 6 6
40309808 2 15
40309808 2 15
40310208 15 15
40310468 48 48
40310473 11 11
40313443 30 34
40313443 34 34
40315178 43 44
40315178 44 44
40315178 24 44
40315178 40 44
40315178 40 44
40315178 27 44
40315178 27 44
40315178 27 44
40315178 23 44
Bookmarks