Donate SIGN UP

Ecel Spreadsheet

Avatar Image
andy-hughes | 19:29 Tue 19th Oct 2021 | Technology
6 Answers
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?
Gravatar

Answers

1 to 6 of 6rss feed

Best Answer

No best answer has yet been selected by andy-hughes. Once a best answer has been selected, it will be shown here.

For more on marking an answer as the "Best Answer", please visit our FAQ.
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.
Insert another column and place "x" in cell alongside those with cert. Then sort on that column. Long winded but works.
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.
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
I found excel is fun MUCH better than microsoft support which was sortta grudging

1 to 6 of 6rss feed

Do you know the answer?

Ecel Spreadsheet

Answer Question >>

Related Questions

Sorry, we can't find any related questions. Try using the search bar at the top of the page to search for some keywords, or choose a topic and submit your own question.