Forum Discussion
Excel outline question
I have an Excel spreadsheet covering many columns and rows, mostly of text rather than numbers. Is there a way I can outline my entries so that what begins as Sport Team Division Netball ...
Another 365 formula; this time comparing every cell against the one above and returning changes as a 2D array.
The biggest hassle is switching columns!
= LET(
priorData, DROP(VSTACK(header, myData),-1),
changes, IF(myData<>priorData, myData, ""),
CHOOSECOLS(changes, 2, 1, 3)
)