Forum Discussion
DanWebtronx
Sep 06, 2022Copper Contributor
CELL Function with a MIN formula as a reference
Is there a way to find the cell that a MIN formula is referencing? Tried using the CELL function's "address" info type, but it results in an error. The MIN formula I'm using is huge, and I'm trying t...
DanWebtronx
Copper Contributor
A record list?
Detlef_Lewin
Sep 06, 2022Silver Contributor
Paste your 30 vendor lists in continuous columns and add an extra column for the vendor name.
Now it will be easy to determine the min value and the corresponding vendor.