MacMusic  |  PcMusic  |  440 Software  |  440 Forums  |  440TV  |  Zicos
numbers
Search

How Do I Return the Contents Of the Last Non-Empty Cell In a Row or Column?

Wednesday January 20, 2021. 04:27 PM , from MacMost
I have a spreadsheet that I regularly update, which populates blank cells in columns. I want to be able to retrieve to the contents of the last cell in a row for a formula (which updates as cells become populated). I have found ways to do that in both Excel and GoogleDocs but the formulae don’t work in Numbers. The Excel formula includes a FILTER function that doesn’t exist in Numbers. The Google one makes use of the INDEX and COUNTA formulae but I just get an exclamation mark in a red triangle. Is there a way in Numbers?
I want to create a line in a chart that represents the average achievement at any given moment and extrapolates it over the remainder of the period. For example, if the figures suggest that I am achieving sales of $100/day today, a cumulative total would show a straight rising line on a graph. But if my sales start running at $150/day (the last figure in the row), I now want to show a cumulative total that will give a more sharply inclined line on the graph. I already have a straight line showing the target achievement and I want to be able to project how close to target achievement is looking as time passes.
Device: Mac Running Big Sur
App: Numbers
—–
Simon Evans
https://macmost.com/forum-how-do-i-return-the-contents-of-the-last-non-empty-cell-in-a-row-or-column...
News copyright owned by their original publishers | Copyright © 2004 - 2024 Zicos / 440Network
Current Date
Mar, Thu 28 - 21:17 CET