Waterguy,
Did you ever solve your ADDRESS function problem? I am running into the exact same problem. Am trying to nest the ADDRESS function within COUNTA as my ranges vary. I am trying to analyze a data dump. I need to calculate the row number and column number and once these are known...