Reference Formula and cell reference

ImAhNoBoDy · #7 10-30-2024, 08:41 PM

So the way I was thinking about things was incorrect. I think I was trying for something like this:

Code:

=SUM(D5+INDIRECT(ARRAYTOTEXT(FILTER(MID(FORMULATEXT(D5),SEARCH(TEXTSPLIT(TEXTJOIN(",",TRUE,ADDRESS(ROW(E2:I2),COLUMN(E2:I2))),","),FORMULATEXT(D5)),4),NOT(ISERROR(MID(FORMULATEXT(D5),SEARCH(TEXTSPLIT(TEXTJOIN(",",TRUE,ADDRESS(ROW(E2:I2),COLUMN(E2:I2))),","),FORMULATEXT(D5)),4)))))))

But the next column wouldn't be able to determine what the previous value was gonna be. I really didn't think this through logically. It would need to be script something in vba to get the results I really want.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Determining if an in-text table reference was created with Word's native cross reference feature	scienceguy	Excel Programming	2	10-25-2021 04:44 AM
Entering a column value in a cell, to be used as part of a reference in a formula in another cell	paulkaye	Excel	4	02-26-2017 04:18 AM
Formula for reference last non empty cell in row	npn321	Excel	10	02-22-2017 11:42 PM
Issue with a dynamic cell linking/reference formula	raravind82	Excel	2	10-26-2016 04:16 AM
Reference number and cross reference for equation numbers to match the thesis format	wmac	Word	1	05-14-2013 08:54 PM