Many Thanks to you Chihiro I have done as you said and I am getting just what I want simple really is it not but that is why you are the expert and I am not
once again many thanks for your time and patience have a good day and a brilliant life
Mike
I am unable to upload a file it because it contains Personnel information but all it is is an array with loads of different numbers referring to Golf handicaps and strokes played on each hole and it is the end of year figures for Ladies and Men I am sure you understand Thank you
Hi there I have a query regarding the Excel find function when I ask it to find Number one(1) it finds it alright but in the process of finding it it also stops on 11,12,13,14 etc and it also does it on 2,3,4 so why does it do this it is probably the first time I have used it so is there...
I have tried the backup and it is exactly the same I think I will just do it manually because I am getting nowhere many thanks for your time and trouble
Mike
vietm good morning There is nothing to upload because it is Office Conditional Formating to change colours thats all. It used to work ok but as I have said it has suddenly gone haywire?
vletm thanks for your reply I have already done as you suggested to no avail you see these cells already have a formula written in them to change the handicap automatically and it use to do it but for some unkown reason it has decided to stop How it works is say a player is on a handicap of say...
Hi there I have a problem with my conditional formatting when I go to change certain colours in cells the whole sheet changes to that colour it selects every cell I am trying to put different cell colours for each golf handicap e.g 4 green,10 yellow,20 blue but it just won't have it ant ideas...
As you can see I have tried copying a football appearance list but I don't know how it works how will i get it to increase the numbers every time a player is selected
I have the format layout if that is any help So only four will be chosen for any one tournament and of course there will be changes for the next tournament if required.I am trying to upload this file but somehow when I press upload file it does not appear to be there baffled ?
Hi There
Long time no see been away for a few months But I was wondering if you could help me out with a formula to obtain player appearances through out the season so every time a player is selected to play in a tournament it chalks up against his name so by the end of the tournament...
Hi Luke
You are not going to believe this I moved the formulas into different columns and low and behold it works why would that be it don't make sense to me but hey it works and that is all I wanted Many thanks for your time and trouble have a great day and a brilliant life.
Mike
Hi Luke
Sorry I am late responding I had to shoot of to London last night only got back at 3.30pm anyway I have tried to upload the file as you requested but it won't seem to do it why I don't know. But if it is any help it is just 55 of the file I sent you
42323 0 Thu, Jul, 06, 3290 42384...