Search results

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...

Well Chilhiro I have sussed it out works great many thanks for your time and trouble have a great day and a brilliant life mike

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

Well it appears that it has uploaded somehow don't ask me how

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...

Hi Luke I have just checked the number format and that works fine. What I am trying to achieve is to get it to put the date on another sheet from the one I am working on and the formula I have used is =INDEX(Freq!$A$1:$A$55,1)*(Freq!$B$1:$B$55) I do not know if that has anything to do with it...

Hi All I have a strange problem which I have never come across before concerning dates. When I enter a date for example 13/01/2016 It comes out as Wed, Jan, 13, 3290 I wondered if anyone could enlighten me as to why this happens it happens on all dates wether it is 2016,2015,2014. Your...

Hi Asheesh Thanks for your reply the good news is I have sorted it out myself quite simple really I wondered why I did not figure it out earlier anyway thanks for your time and trouble and have a great day Many Thanks Mike

Hi All Just more out of curiosity. Why can't I add up a column or row of numbers that have a formula in the cells because all I get is 0 is there a way round this or not? Mike

Hi Narayan You are right it has started doing what I wanted so that is great it must have been me not set it up right anyway it is working now thanks to you. So again I am indebted to you thanks for your time and trouble.Have agreat day and a brilliant life. Mike

Hi Narayank Thanks for that but that is the same as the one I have got I dont want to have to press start blinking or stop blinking I want it to start automatically when the figure 350 appears in that cell and when another figure appears it will stop automatically Mike

Hi Narayank The cell has a formula in it when that figure appears I want it to flash it means this player has reached 350 points. Mike

Hi Narayank Thanks for that info I have tried a couple but they do not do what I want I wanted it to flash when the number appears in the cell but not to worry. Thanks anyway Have a great day Mike

Hi All I would like to know how you make a cell blink or flash when a certain value appears in it. Am I right in thinking this cannot be achieved with a formula but has to be a VBA macro ? unfortunately I am not the greatest at macros and would be very obliged if you can give me some assistance...

Hi There Nebu Many thanks for that it is just the ticket again much appreciated have a great day Mike