Re: locking or grouping rows

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

This doesn't work for me. Probably I don't understand what you mean by
"drag down"
thanks for trying -

"Dave Peterson" <ec35720@xxxxxxxxxxxxxxxxx> wrote in message
news:42A0C35B.19A55507@xxxxxxxxxxxxxxxxxxxx
> You can do it, but keeping your data in this format makes things like this
> much
> tougher than using one row per record.
>
> Try this against a saved copy of your workbook--if it doesn't work, close
> without saving!
>
> Insert a new column A.
> Insert a new row 1 for headers.
>
> Put this in A2 and drag down.
> =IF(MOD(ROW(),4)=2,B2,A1)&"--"&ROW()
>
> (It'll look funny, but it should sort ok.)
>
> Now select column A and do Edit|copy, Edit|paste special|Values
>
> Now sort your data using column A as the key. Delete column A when you're
> done.
>
>
>
>
>
>
> Jimquist wrote:
>>
>> I have made an address book and find that I am unable to sort it.
>> I "think" I need to group several rows.
>> 1st row: name > street number > children names > Home Phone
>> 2nd row: > city, state, zip > more names > Cell Phone
>> 3rd row: > > more names >
>> e-mail
>> 4th row: blank - separator
>>
>> Is it possible to group those 4 rows to be able to sort on name in column
>> 1?
>> I'd like to keep this format rather than spread the information across
>> 8 -
>> 10 columns.
>> tia, Jim
>
> --
>
> Dave Peterson


.

Relevant Pages

  • Re: Sorting/Function Help
    ... Format it as General ... and drag down the column ... I tried using sort but that don't help. ... Dave Peterson ...
    (microsoft.public.excel)
  • Re: a p.s.
    ... I don't do well with Excel, you cannot drag and drop, but you can cut and paste... ... > Mary Sauer MSFT MVP ... it's not an issue with a basic sort. ...
    (microsoft.public.publisher)
  • Re: locking or grouping rows
    ... but keeping your data in this format makes things like this much ... tougher than using one row per record. ... (It'll look funny, ... Now sort your data using column A as the key. ...
    (microsoft.public.excel)
  • Re: Sample
    ... insert a helper column ... put =rand() in the top row ... Sort your data by that column and copy the first 250 in the sorted list. ... And drag down that column. ...
    (microsoft.public.excel.misc)
  • Re: Creating pics on the web
    ... Yes I will problably need to have some sort of template icons to drag, ... You could probably do it in just PHP and HTML with image maps and using ...
    (comp.lang.php)