You can make a difference in the Apple Support Community!
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
I am trying to find the change in scores from the beginning of a range to the end. I have an example of it in Google Sheets, but I don't know how to show the change in Apple Numbers (since I want to switch to Apple Numbers).
Apple Numbers - no scores in some years, but I want to find growth from the first score to the last score.
Google Sheets example:
Thanks!
MacBook Air, macOS 15.1
Hi dchandler95,
First, let's use another table to find the column numbers containing scores (non-blank columns). You can hide the extra table (cut and paste to another Sheet) when all is working.
Formula in "Non blank column numbers" B2 is IF(ISBLANK(Table 1::B2),"",COLUMN())
Fill down and fill right.
In Table 1, formulas are
L2 is ROW()
M2 is MIN(Non blank column numbers::2:2)
N2 is MAX(Non blank column numbers::2:2)
O2 is INDIRECT(ADDRESS(L2,M2,4)
P2 is INDIRECT(ADDRESS(L2,N2,4)
Q2 is P2−O2
The red error triangles are due to no scores in those rows.
Hide columns L to P
Regards,
Ian .
Assuming your data starts in column B (which would be 2014), the formula in cell N2 could be
=XLOOKUP(REGEX("."),B2:M2,B2:M2,0,2,−1)−XLOOKUP(REGEX("."),B2:M2,B2:M2,0,2,1)
How can I find the amount of change in a range of numbers?
