I would show you my offsets and indirect formulas but they are a mess.
See attached files. I need the "Recap" file to have the data pulled from specific rows on the "Region 1 Customers". (I will have a recap total, small size, medium, large, etc. I will have more regions with a lot more customers.
I tried my best to explain what data I want to pull within the Recap file - See Row 3 on the SMALL tab.
Thank you in advance!
Bookmarks