Ecel Spreadsheet

[andy-hughes]

I have an Excel Spreadsheet with various columns.

In the first column, some of the rows are identified by having the word 'Cert' next to them in that column.

I want to isolate all the rows with the 'Cert' demarcation as a single separate sheet - can someone advise how i can do that please?

[Atheist]

Andy - google 'Excel sort' or 'excel pivot' or some such. You might get quicker results than on here. If you do, please let us know. If not, then some one better informed than me will probably give advice here.

[Deriter]

Insert another column and place "x" in cell alongside those with cert. Then sort on that column. Long winded but works.

[ToraToraTora]

use sort/filter to select the cells you want then click copy and select "visible cells only" then past into a new sheet or workbook.

[ToraToraTora]

andy, see here:
https://support.microsoft.com/en-us/office/copy-visible-cells-only-6e3a1f01-2884-4332-b262-8b814412847e

[Peter Pedant]

if you have to do a lot of excel
( which I did for accounts which I ended up failing)
then this guy


excel is fun - has an incredible number of basic courses
and magic tricks - - I think I did 1-1000 ( magic tricks) or 1-2000
and got a good working knowledge of excel ( a lot on pivot tables which I dont need / didnt need)

Bill gates whom I have no love for - realised that no one was using micrsoft database so they incorporated them all into excel

[Peter Pedant]

I found excel is fun MUCH better than microsoft support which was sortta grudging