Search results

I am having a problem with this formula for a simple task. I wish to display a formula that can be used to determine prize money for golf tournaments.I.E 6 gold medal wins =£500 5 gold medal wins and 1 silver =£400 and 5 gold medals =£300 4 gold medals and 1 silver =£200. but i cannot get it to...

Hi Deepak &Debraj Thanks for your reply the problem I am having is that in the setting file the areas for information about players form i.e Pts Rank which is working correctly but the SD Rank(shot difference) F Rank (form rank) and Year Position nothing is happening in those cells and I do not...

Somendra Yes I know as i said in previous post it keeps coming back Unspecified error but i have tried again Mike

Hi Somendra Well I am back and I have done as you said and made a mini sort of file to give you an idea of how it works I just hope that it is satisfactory and you can make head or tail of it. Well it seems it will not open I don't know why it just keeps coming up Unspecified Error so i have not...

Hi Somendra Well I am back and I have done as you said and made a mini sort of file to give you an idea of how it works I just hope that it is satisfactory and you can make head or tail of it. Well it seems it will not open I don't know why it just keeps coming up Unspecified Error so i have not...

Hi Somendra Well I am back and I have done as you said and made a mini sort of file to give you an idea of how it works I just hope that it is satisfactory and you can make head of tail of it. Regards Mike

Somendra OK will do that but it will take me a bit of time I am nowhere near as good as you with Excel but i will give it a go Many Thanks Mike

Hi Somendra I have looked at this formula and believe it is massive. It incorporates a league table like a football one and also a form table for all the players so it would be to big to upload so I think I will forget about the form part of it and leave it at that Kind Regards Mike

Hi Somendra Sorry I am late in replying but got held up in one of those boring meetings. However I have looked at the formulas in the other columns and column Shot difference has this formula in it (=IF(D4<1,-100,T4+AB4) and the column with the Points Has this in it (=U4+AC4-ABS(Deduction!D3)...

Hi Somendra The reason I say it is not working because nothing happens when I put results in on the other sheet it should register in the column but I am afraid it does not it just leaves everything blank SP Rank 0 0 0 0 0 0 So as you can see nothing registers so something is wrong somewhere...

Hi Everyone Just a question really I have a formula created in Excel 2003. Why does it not work in Excel 2010 it is a Ranking formula for shots taken and points gained =SUMPRODUCT((M$4:M$23=M4)*(L$4:L$23>L4)) I was wandering wether it is written differently in 2010 Thank you in advance for your...

Luke Top Man Thats done the trick problem solved many thanks for your time and trouble have a great day and a brilliant life Once again Many Thanks Mike

Hi Luke thanks for that I tried it out and it just comes back #Value what I really want is for me to enter a(1) in column K and £500 to come up in column L So am I right thinking I need a formula Like "1" = £500 "2" = £250 etc or something like that Many thanks Mike

Hi there everyone Hope you are all well. I wondered if you could help me out with formula to obtain the prize money for the end of season awards. It consists of two columns Column (K) which will have a number in each cell denoting finish position Column(L) Will have a monetary value i.e. £500...

Hi Guys Thanks for your quick response all three do the trick thanks very much May you all have a good day and a brilliant life once again many thanks Kind regards Mike

Hi There . I was wondering if anyone could help me ou here. I had a formula for converting single letters to numbers i.e.W=3 D=1 L=0 it is a form table of players Won, Drawn,Lost Somehow I have lost the formula it has just disappeared. I think the formula was something like...

Hi There Everyone who gave me advise on my problem with duplication I have solved it. It seems it was a circular reference was the problem i sorted that and everything works fine Thank you all for your time and trouble have a good day and a brilliant life. Mike

Hi there Somendra Thanks for that I checked both rows and when I Used Auto Sum Row A amounted to 27684 but row B amounted to 3E+05 whatever that is because I have not got a clue he yony idea? Regards Mike

Hi There Debraj I have used the special facility and it worked fine all the numbers in row A and row B are duplicated as they should be but when I click Auto Sum row A amounts to 27684 and row B amounts to 27741 how can that be? Mike

Hi Narayan How do I correct a Formula in CF that is already in Excel from what I can see there is no formula there other than letters aAbBcCdD etc etc Mike

Hi there Debraj Thank you for your reply but one question were is this Special situated I have no idea I cannot see it anywhere on any of the Tabs could you enlighten me. Mike

Hi There Narayan Many thanks for your quick response I have done exactly as you said for column A I placed =A+0 in column B and for C I placed in column D the results were exactly the same so I altered one of the the two duplicate numbers and noticed that it was not...

Hi there I was wondering if anyone can help me out here. I have two columns of numbers e.g Column A Column B 135 135 86 86 171 171 etc etc And when I run my conditional formatting for Duplicate...

Hi bobhc and Narayan I have solved my problem with the dates thing I found an old formula and that has worked fine many thanks for your time and trouble Have a good day Mike