Good morning
I would like some help to sort names and bring them back from column C
Sheet2 to column C sheet1 also with duplicates.
Then, also report their code from colona B
sheet2 to column B Sheet1
Thanks
Good morning
I would like some help to sort names and bring them back from column C
Sheet2 to column C sheet1 also with duplicates.
Then, also report their code from colona B
sheet2 to column B Sheet1
Thanks
based on your sample, and assuming XL2007 compatibility required, one option:
Formula:Foglio!B5:
=INDEX(Foglio2!C:C;MOD(SMALL(INDEX(10^7*COUNTIF(Foglio2!$D$5:$D$29;"<"&Foglio2!$D$5:$D$29)+ROW(Foglio2!$D$5:$D$29);0);ROWS(B$5:B5));10^7))
applied to matrix B5:C29
Thank you but, I'm finding some trouble adapting it
The file was just a small example.
Reporting the formula to another file does not sort correctly and leaves some lines empty
I can also use 2010
Last edited by Berna11; 11-28-2020 at 12:05 PM.
A 2010-friendly version. In B5:
=IFERROR(INDEX(Foglio2!C:C,AGGREGATE(15,6,ROW(Foglio2!$D$5:$D$29)/(Foglio2!$D$5:$D$29=C5),COUNTIF($C$5:C5,C5))),"")
and in C5:
=LOOKUP(1,0/FREQUENCY(ROWS(C$4:C4),COUNTIF(Foglio2!$D$5:$D$29,"<="&Foglio2!$D$5:$D$29)),Foglio2!$D$5:$D$29)&""
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
Ok perfect thanks it works
You're welcome and thanks for the rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks