Offset Indirect Function Issue
I'm looking for assistance on an Offset/Indirect formula I am using
MIN Formula is =OFFSET(INDIRECT(B8),0,1,1,1)
MAX Formula is=OFFSET(INDIRECT(B8),0,2,1,1)
Good news is that those formulas pull from the correct Named Cell Areas
Bad news is that the Offset hard wires the Min Max Cells as the first row.
In my attached example when I change the Job Title to "Shipper" the values do not change.
Any assistance in Solving this would be AMAZING!
Last edited by Bryan.Pagenkopf; 04-10-2019 at 03:23 PM.
Try this:
MIN:Formula:
Please Login or Register to view this content.
MAX:Formula:Please Login or Register to view this content.
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Change formulas in J12 and J13 to:
MinMaxHTML Code:HTML Code:
1. Click on the * Add Reputation if you think this helped you
2. Mark your thread as SOLVED when question is resolved
Modytrane
Administrative Note:
Welcome to the forum.
We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.
Read this to understand why we (and other sites like us) consider this to be important.
(Note: this requirement is not optional. No help to be offered until the link is provided.)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks