Forum Discussion
Excel with variable cell selection
Hello, I have a list of numbers, and I want to make a formula to choose how much of that list is needed. For example, I want to choose A1 to A5, but the number 5 is from an other calculation. So...
Hey Mertijn-
try using a formula like this (See attached .xlsx example file for reference):
=SUM(INDIRECT("D2:D"&B3))
Matt Mickle thanks guys that helped me complete this very useful formula:
=UNIQUE(INDIRECT("A2:A"&COUNTA(A:A)))