Forum Discussion
Hi! - asking for a solution to an equation that has me stumped, if I may...
I am a bit further along than beginner, but by no means advanced, so please forgive me if my query seems obvious to someone. But I have tried to build an equation to solve the following problem, an...
Keeping the SUMPRODUCT solution, you could create two dynamic ranges to put in the formula:
"DynamicID"
=OFFSET(Sheet1!$A$2,0,0,COUNTA(Sheet1!$A$2:$A$1000000),1)
"DynamicTF"
=OFFSET(Sheet1!$B$2,0,0,COUNTA(Sheet1!$A$2:$A$1000000),1)
Please see attached:
Ohmygoodness. You did it AGAIN!!!!!!!!!!!!!!!
I cannot thank you enough!! I can see now that I was apparently on the right track, but I definitely did it incorrectly. Thank you for teaching me!!! You're the best!!!! : )
Tamara <3!!!