Tagged Questions

0
votes
1answer
19 views

Google Spreadsheets Filtering data in another page and changing data in the original

I have a lot of data that I need to filter. I did it in another page and that's good... but now I need to put some values in that page... and transfer that data to the original. This is the formula ...
0
votes
0answers
37 views

copy google document table of contents links into google spreadsheet cells

I have a large google document where each table of contents item links to the header of a food recipe further down in the document. How do I copy each TOC link+title into cells in a google ...
4
votes
1answer
602 views

Google Spreadsheets Filter() - referencing source array in criteria

The filter() function looks through a source array, and filters it according to condition =FILTER(A:A,ISNUMBER(A:A)) My source array is a rather long formula, so i end up repeating the same formula ...
1
vote
0answers
136 views

Need count of items in one column with specific month/date in another column in Google Docs

I have been trying to use COUNTA with FILTER, but not getting correct results. The column I am counting from has text values input from a drop-down menu, which caused problems just counting until I ...