Forum Discussion
Solved
Using named ranges
Hi, I have attached a sample file. I have 2 named ranges: start and end. If I use the names in a formula, data is selected from the same column. I would like to reference a different column, fo...
Hi chris15 ,
Let me know if this works for you:
You need to reference the cells in a different way, unfreezing the column. I mean, instead of $E$3 type E$3 and the formula will change every time you drag it.
If this solution fits your request, please mark as a best response to help others.
Regards!
Karchavez
Hi chris15 ,
Let me know if this works for you:
You need to reference the cells in a different way, unfreezing the column. I mean, instead of $E$3 type E$3 and the formula will change every time you drag it.
If this solution fits your request, please mark as a best response to help others.
Regards!
Karchavez
