Sheet 6 :-
In A2 i can select a Vessel name from the drop down list (A2) this in turn in cell A6 and below returns All the species relevante to that vessel aswell as the presentation.
At the moment it returns the species name a number of times based on how many grades of the species are lsited. (I.E if there are 6 grades of a species it returns the specie name 6 times etc)
Is there an adjustment that can be made to just get the specie name to return once ? and only return multiple results if presentation GH and WF is relevante (I.E Cod GH, Cod WF)
The source of all the data comes from sheet named "DATA"
Bookmarks