•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Difference between ADDRESS(1,1,1) and ADDRESS(1,1,4)?
ADDRESS(1,1,1) returns the text $A$1, and ADDRESS(1,1,4) returns the text A1. Other than the difference of the text strings, what other practical difference is there? In what situation would you need to use one over the other?
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#rows.com
#Excel compatibility
#Excel alternatives for data analysis
#Excel alternatives
#ADDRESS
#Excel
#A1
#$A$1
#text strings
#practical difference
#difference
#situation
#function
#argument
#cell reference
#spreadsheet
#coordinate
#formulas
#data
#output