Sort

[HP_81]

Hello

Have a few rows that are in 132. wanted it sorted 123.

Had 132 in the helper column and tried to sort based on column B
Excel is sorting all the 1's together , then all the 2s, then 3s — instead of sorting within each qroup of 3
need the values in ColumnA sorted 123,123 123 based on column B

Have attached a sample
Any ideas please

 

[vletm]

One idea ...

 

[ArmstrongArcade]

Another idea...

 

[HP_81]

Excellent ..Thanks vletm and ArmstrongArcade.
Appreciate your help.

 

[HP_81]

@vletm is there a work around when we have a header line.
Looks like it groups the header line in the box of 3 and and the 3rd line is out of series?

 

[vletm]

Your original sample's data starts from row 1.
There have to take care ROW() in formula.
If there is one row above (eg a header) then modify ROW() to (ROW()-1).

 

[HP_81]

Brilliant...Thank you so much