I am trying to find the average value for a cell range extending sideways (in columns, not rows). However, I am having trouble identifying the last used column.
This is the line of code I am using,
The CELL formula returns the last column used but enclosed in quotes, "$Z$3", and the formula would not work.Please Login or Register to view this content.
I need the formula to appear since I've been asked to leave all formulas in the spreadsheet.
Thank you all for your help.
Bookmarks