Timeline for How to average the last 5 nonblank, nonzero value in a row in Google Sheets?
Current License: CC BY-SA 4.0
8 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Mar 14, 2023 at 14:06 | vote | accept | jrhwhite | ||
| Mar 14, 2023 at 5:31 | comment | added | Blindspots♦ |
answer updated. FYI the advantage of the BYROW versions is that you define the range once and the single formula will generate the average for all your rows.
|
|
| Mar 14, 2023 at 5:29 | history | edited | Blindspots♦ | CC BY-SA 4.0 |
added single row reverse order and BYROW reverse order
|
| Mar 14, 2023 at 5:14 | history | edited | Blindspots♦ | CC BY-SA 4.0 |
added single row reverse order
|
| Mar 14, 2023 at 5:00 | history | edited | Blindspots♦ | CC BY-SA 4.0 |
added single row reverse order
|
| Mar 14, 2023 at 4:52 | comment | added | jrhwhite | Thank you! That first formula (Single Row) is really close to what I am looking for, however I need it to average the last 5 values in the row. Is there a way to modify it to accomplish that? | |
| Mar 14, 2023 at 3:58 | history | edited | Blindspots♦ | CC BY-SA 4.0 |
added a multi-row formula and links to google function support
|
| Mar 14, 2023 at 3:45 | history | answered | Blindspots♦ | CC BY-SA 4.0 |