Thanks Mynda, It had crossed my mind that the format was the limiting factor but was looking for an "easy" way to avoid having to go through and re...
Hi Mynda, Many thanks as always for the help, that solution certainly works for duplicate rows. My initial posting was not very clear and I realiz...
Hi Velouria, Thanks for the formula, that works well. With all this help I think I am almost there as far as the duplicate entry check is concerne...
Hi Mynda, Thanks for the insight as always. Maybe I am not thinking this through properly but my issue, or my desire for non-contiguous ranges is ...
Thanks Mynda, As usual your solution works! One quick follow up - can I change the "range" section (currently shown as B22:B65), to non-continuous...
Hi everyone, I have been trying to implement at least some of your advice on this subject. If you take a look at the attached you'll see my effort...
Sunny/Frans, just a quick note for now to say thank you. I am going to look at both your suggestions in the next couple of days and see what I can ge...
Hi Frans, An elegant solution indeed! It works well many thanks - I do have a one supplementary question though: Ideally I wanted to have the l...
Hi guys, Many thanks for all the replies, I went with Sunny's formula suggestions and that works. Appreciate all the help! Alan
Hi Frans, Thanks for the reply, the formula you suggested does work but on the sheet instead of displaying the #value error its displaying the word...
Hi Anders, Many thanks, I will give it a shot. Alan