Greetings...
I have a table with five row Products and three values for each product; each product is a Named Range.
One product is Turf.
I have a cell to find the Min(Turf). This works.
I also have a validation list to dropdown each or the Products - another Named Range.
I cannot pass the reference to the Named Range from the Dropdown which lists all the Names into the Min function. i.e. -MIN(B2) - the reference to the dropdown containing all the Named Range Products.
The Min function needs the actual Named Range - not a reference.
Any help would be greatly appreciated...
Thanks in advance. - Tom
Bookmarks