I need to make a list order by numbers from a table.
You can see detail and explanation in attached file.
Thanks in advance for any reply and help. Looking for a formula solution, no a macro.
Regards,
turist
I need to make a list order by numbers from a table.
You can see detail and explanation in attached file.
Thanks in advance for any reply and help. Looking for a formula solution, no a macro.
Regards,
turist
Last edited by JBeaucaire; 03-17-2014 at 04:53 AM.
With helper column (say E)
in E1:
=MIN(Sheet1!A:A)
in E2:
=IF(B1="",A2,E1)
in B2:
=IFERROR(SMALL(OFFSET(Sheet1!$B$1:$AZ$1,MATCH(E2,Sheet1!$A$2:$A$26,0),0),COUNTIF(E$2:E2,E2)),"")
and in A2:
=IF(AND(B1<>"",A1<>A$1),"",IFERROR(SMALL(Sheet1!A:A,COUNT(A$1:A1)+1),""))
select row 2 (A2:E2) and copy down
Best Regards,
Kaper
Thanks and rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks