Forum Discussion

Wardah Mustahsan's avatar
Wardah Mustahsan
Copper Contributor
Oct 03, 2018

Excel Sorting help

Hi

 

I need a little help with sorting. In the sheet I attached below I have sorted A-K based on 96 plate level, KS###, and Y number. But my issue is that the 384 position has to be the same in each row. In my sheet after the first sorting the position in column B changes to A05, A01, A09 etc... but the same positions ( along with the correct data) do not show up for Columns N-S and U-Z. So my check equation is "FALSE'' .

 

Can someone please tell me what additional sorting I need to do to fix this ?

 

Many Thanks!

excel
Formulas and Functions

1 Reply

Sort By
  • Detlef_Lewin's avatar
    Detlef_Lewin
    Silver Contributor
    Oct 03, 2018

    Hello

     

    You have four separate tables which are separated by empty columns.

    Solutions:

    - Remove the empty columns and make sure every other column has a header text.

    - Select the area over the four tables and klick on "Filter" or press CTRL-SHIFT-L.

    - Add a header text in every empty cell in row 1.

     

Resources