• 0

[EXCEL] Sort a list created from two merged lists


Question

Sorry in advance about the wording of this question.

I have an Excel workbook with 3 worksheets in it. In Sheet1 I have List1 and in Sheet2 I have List2 (Both lists are just numbers). In Sheet3 I have merged the contents of both List1 and List2, however when it is displayed I have got List1 displayed then List2 directly below in one long column which is great. However I am trying to get the merged list to display sorted descending.

Any ideas?

If it helps, the code I have used to merge the two colums is as follows;

=IF(ISERROR(INDEX(List1, ROWS($C$1:C1))), IF(ISERROR(INDEX(List2, ROWS($C$1:C1)-ROWS(List1))), "", INDEX(List2, ROWS($C$1:C1)-ROWS(List1))), INDEX(List1, ROWS($C$1:C1)))
=IF(ISERROR(INDEX(List1, ROWS($C$1:C2))), IF(ISERROR(INDEX(List2, ROWS($C$1:C2)-ROWS(List1))), "", INDEX(List2, ROWS($C$1:C2)-ROWS(List1))), INDEX(List1, ROWS($C$1:C2)))
=IF(ISERROR(INDEX(List1, ROWS($C$1:C3))), IF(ISERROR(INDEX(List2, ROWS($C$1:C3)-ROWS(List1))), "", INDEX(List2, ROWS($C$1:C3)-ROWS(List1))), INDEX(List1, ROWS($C$1:C3)))

and so on...

Link to comment
Share on other sites

0 answers to this question

Recommended Posts

There have been no answers to this question yet

This topic is now closed to further replies.
  • Recently Browsing   0 members

    • No registered users viewing this page.