A computer application that simulates a paper accounting worksheet.

learn more… | top users | synonyms

0
votes
2answers
82 views

Spreadsheet: function to watch row for changes

Is there a spreadsheet function (Google, Excel, Numbers, or otherwise) that can watch a row and update a cell with the current date when any cell in that row changes? If not for the entire row then ...
2
votes
0answers
27 views

Go to changes in Google Spreadsheet (or Docs)

When I see that somebody has changed a document I am working on in Google Drive, I normally want to see where exactly the change happened. Using File > See Revision History... is not really helpful ...
-1
votes
0answers
8 views

How to get value from cell above cell that matches criteria

So, basically, I've got this table: A2:A =MIN(ARRAYFORMULA(IF(ISBLANK($D2:$G2);$D$1:$G$1;Temp!$C$89))) B2:B =MAX(ARRAYFORMULA(IF(ISBLANK($D2:$G2);$D$1:$G$1;Temp!$C$89))) C2:C =SUM(D2:2) and ...