Sorting
 

I am soritng a spreadsheet (A-Z by last name). So, for example, data for
person 1 is on row A1-G1 (takes 1 row) but then column H will have data for
that person in rows 1-3 so when I sort at this point the data in H2-3 will
get pushed down to the end of the sheet. What I am doing now is typing the
persons last & first name 3+ times so that it sorts all the persons
information along with it. Is there a different way of doing this? I
know...Hard to explain...I hope someone out there knows what i'm talking
about!

Sorting
 

Hi,

What you need to do is fill in the missing repeat names. This could be in
one or more columns, but let me assume it is in A1:G100. Highlight this
range and
1. Press F5, Special, Blanks, OK
2. Type =, Up, Ctrl+Enter. (Type the equal sign then press the Up arrow key
once and finally press Ctrl+Enter.
3. Select the range A1:G100 again and press Ctrl+C (copy)
4. Choose Edit, Paste Special, Values.
5. Now you can sort, keeping everything together.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Athletica" wrote:

I am soritng a spreadsheet (A-Z by last name). So, for example, data for
person 1 is on row A1-G1 (takes 1 row) but then column H will have data for
that person in rows 1-3 so when I sort at this point the data in H2-3 will
get pushed down to the end of the sheet. What I am doing now is typing the
persons last & first name 3+ times so that it sorts all the persons
information along with it. Is there a different way of doing this? I
know...Hard to explain...I hope someone out there knows what i'm talking
about!