Here is the outline - In Excel I have 6 columns, Column 1 has Numerical
Ranks from 1 -- 100 or whatever the figure. Column 2 has Ratings from say 25
down to whatever say 0 (there can be multiple values ie 7 of Rating 3).
Column 3 has text/string in my case names. Column 4 is identical to Column 1,
ie same Ranks. Column 5 has the same but not always the same number of
ratings. Column 6 has names and can be longer or shorter than Column 3. It is
NOT!! in the same order as Column 3 with some matching names having different
row numbers and can be new entries. NOTE: The names and ratings columns 2 & 3
and also 5 & 6 are always together but their values can change ie from
Columns 2 & 3 -- 5 & 6.

Question - I want to find matching!! names in Columns 3 & 6 then find the
relevant ranks from Columns 1 & 4, then subtract the value of Column 4 from
Column 1. Then find the MAX and MIN values. I would like to divide these
results according to the ratings column say greater than 10 and less or equal
to 10. The result should show 4 answers the highest and lowest difference in
ranks for ratings greater and less than or equal to 10 for each name/string.
Then I want to concentate the string name and new rank and ratings. I realise
new entries will show errors. Anyone have any advice, on how to approach
this?