Sort

M

mykaltx

I want to be able to sort a whole row of cells as one group. How do I do
that? Let me know if I need to explain myself better.
 
P

Peo Sjoblom

You would need to concatenate the cells into a help column like

=A3&B3&C3&D3&E3&F3&etc

then select the whole table including the help column and sort by the help
column


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com
 
B

Bill Ridgeway

Peo suggested concatenating the cells with -

=A3&B3&C3&D3&E3&F3&etc

This wont work for cells containing numbers as these will be treated as a
string of numbers not a value. You would need to have something like

=A3&value(B3)&D3 where b3 contains a number

Regards.

Bill Ridgeway
Computer Solutions
 
M

mykaltx

Ok,
Say that I am using row 1 through Column E.
I am putting in steel information. Something like this. In steel L
stands for Angle. L 1/4 x 4 x 4. That will be the detail information.
That will fit into cell A1. Then the length will fit into Cell B1. All
other information will put into the remaining cells. I want those cells
to count as a block. The same thing will continue will row 2. This will
count as a block as well. So on and so on. Except say that, I enter
information into row 2 as a channel instead of an angle. That would be
C8 x 15. Well, I am not putting the information in any certain order as
I am doing data entry. When I am done with the data entry. I want to go
back and sort it so the angle and channel all end up together in there
own groups.
 
P

Peo Sjoblom

No difference, once you concatenate they will all be text regardless if you
treat one cell as a number
if all cells are numbers (most unlikely) one could use

=--(A3&B3&C3&D3&E3&F3)

however if there is a single text character in the above it will return a
value error so your formula won't do any difference at all


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com
 
Top