User Profile
anne_sofie
Copper Contributor
Joined 2 years ago
User Widgets
Recent Discussions
List duplicates and move entire row
Hi, Is there a formula in Excel that causes an entire row to move based on a command/formula for a particular cell in a row? I have a sheet where column A contains a number/code in each cell which is connected to a number in each cell in column B. I cannot lose this combination. Column D contains the same number as in column B, but is not in the correct order (it is duplicate, but not listed next to each other). Column D through AN contains rows that cannot lose the combination of each other, but I want the number in column D to lie/list next to the duplicate in column B, but for the entire row from D-AN to follow. To list the duplicate next to each other I have used the following formula, but then I lose the combination from column D to AN: My question is: Is it possible to add something to this formula to make the entire row follow the value in mentioned cell (in this case E1 or column E). Regards Anne-Sofie
