Questions

Use cell locations generated from ADDRESS function in EXCEL

Tags:
+
0 Votes
Locked

Use cell locations generated from ADDRESS function in EXCEL

vfiduccia
I have been able to generate a range using the ADDRESS function in EXCEL, but cannot find a way to use this range to be used in a COUNTIF formula.

How can I plug in the range received by the ADDRESS function into an array statement?

Thanks