Sorry for the late reply, i just didn't notice this message. If you could email me a sample workbook, i will have a look. HEREMANSS@TELENET.BE
Hi - I have been following your advice re the 'Apples' ... I have a similar issue that I can't quiet make work utilizing the apples remedy. I am trying to write a darts league rankings, to complete this I need to search for (say 'highest in') from the entire years results, I want it to return that 'highest in on another page. So for example amongst many other players Fred has played say 30 games, for each game he has an 'in' I need to return only the highest in recorded for FRED ... so I need to search all the FRED entries and LOOKUP the 'highest in for each of FRED's entries, I then need to establish and record only FREDS highest - sorry it's a bit convaluted but do you think you could give me a 'leg up' with this