Automatic Google Spreadsheet Display

0
votes

I have a huge spreadsheet of data on google docs with one of the columns being called "status" which ranges from one star (*) to five stars (*****) for the input. and I want to create a separate sheet that will automatically update showing all data that has been classed as five star "*****".

Any ideas? Sorry I am new to formulas in excel etc.

1
excelgoogle-sheets
@pnuts because It is set to grow larger and will frequently change hence I do not want to have to sort the table, copy and past every day. I would like an automatic update of the statistics I can check quickly and easily :) - MikeHolford
I think i understand the filter now. I could just filter on five stars. I just need to have it live updating from one spreadsheet to another - MikeHolford

1 Answers

0
votes

Have you tried the Filter function? It'd definitely slow down for huge files but does dynamically update as the source data set changes.