Mudsplash
New member
- Joined
- Dec 30, 2018
- Messages
- 3
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- latest version
The issue I am having is i am not sure how to accomplish what i want.
I have two different tables with purchase price / sell price organized by locations and commodities.
What I want to be able to do is select a location for purchase price and select a location for sell price and have excel return the difference between the two locations for ALL commodities. (Point A to Point B)
An advance version I would like would be selection multiple locations and for each leg and returning the (MAX) difference for each (leg/way point A,B,C etc) with the condition that A must be sell able at B and B must be sell able at C) But A at C must NOT ever return a value because of redundancy.
As a bonus in the future I am looking to have the data update for fluctuation of prices but this is not a priority.
I have attached the sheets in a single file.
I have two different tables with purchase price / sell price organized by locations and commodities.
What I want to be able to do is select a location for purchase price and select a location for sell price and have excel return the difference between the two locations for ALL commodities. (Point A to Point B)
An advance version I would like would be selection multiple locations and for each leg and returning the (MAX) difference for each (leg/way point A,B,C etc) with the condition that A must be sell able at B and B must be sell able at C) But A at C must NOT ever return a value because of redundancy.
As a bonus in the future I am looking to have the data update for fluctuation of prices but this is not a priority.
I have attached the sheets in a single file.