Find in XML and Copy

[S1L1Y1]

Re: Find in XML and Copy

I am very not knowledgeable so I would appreciate if you can explain.
Sol
"Jeff Richards" <JRichards@msn.com.au> wrote in message
news:O3EsHG3vIHA.3384@TK2MSFTNGP03.phx.gbl...
> Yes - if you create a column of incrementing values BEFORE doing the sort
> then use that column to sort on AFTER doing the delete, like I said..
> --
> Jeff Richards
> MS MVP (Windows - Shell/User)
> "S1L1Y1" <s1l1y1@yahoo.com> wrote in message
> news:%23jfDti2vIHA.2064@TK2MSFTNGP05.phx.gbl...
> > Can I undo sort after I delete or cut /
> > Sol
>
>

 

[Jeff Richards]

Re: Find in XML and Copy

Why are you using EXCEL for this job? It's not a good tool for this sort of
task, and now you say that you are not very knowledgeable about it. You
seem determined to make this job as difficult as possible.

You create a column of incrementing numbers by putting a 1 in the first cell
and then a formula in the cell below it that adds one to the value from the
cell above. Then copy down from the second cell to the bottom of the range.

You convert the column from formulas to values by copying the column then
using paste special and selecting values and pasting it back to where it
came from.

You sort by selecting the whole spreadsheet, choosing sort, and nominating
the column containing the text data.

Then delete the lines you aren't interested in - they will be in blocks
before and after the lines you need.

Sort back into the original sequence by selecting the whole sheet, selecting
sort, and nominating the column with the numbers in it.

These are elementary EXCEL questions that are best asked in an EXCEL
newsgroup.
--
Jeff Richards
MS MVP (Windows - Shell/User)
"S1L1Y1" <s1l1y1@yahoo.com> wrote in message
news:e66LI%233vIHA.4736@TK2MSFTNGP04.phx.gbl...
>I am very not knowledgeable so I would appreciate if you can explain.
> Sol
> "Jeff Richards" <JRichards@msn.com.au> wrote in message
> news:O3EsHG3vIHA.3384@TK2MSFTNGP03.phx.gbl...
>> Yes - if you create a column of incrementing values BEFORE doing the sort
>> then use that column to sort on AFTER doing the delete, like I said..
>> --
>> Jeff Richards
>> MS MVP (Windows - Shell/User)
>> "S1L1Y1" <s1l1y1@yahoo.com> wrote in message
>> news:%23jfDti2vIHA.2064@TK2MSFTNGP05.phx.gbl...
>> > Can I undo sort after I delete or cut /
>> > Sol
>>
>>
>
>