Search results

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

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

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

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

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 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 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 Everyone I had a formula provided to me very kindly by Narayank911 about a year ago and I am afraid it has disappeared from the computer. It was one that allowed me to print the date on my master copy and it would print it at the same time opposite the Members number i.e Master Copy...

Good day Everyone. I would like to be able to change cell colours so that when certain letters are entered the cell changes to the appropriate colour. They will be connected with the weekly sales so the letters entered will be P=profit,L=loss,E=even.so the formula will look something like this...

Hi I was wondering if anyone could give me some help with my Excel 2010. I realise this is not the usual request on this board but I am a bit stuck. Excel takes ages and ages to open up approx 5 mins I have tried a lot of things but to no avail I was wondering if anyone else has come across this...

Hi Narayan Its me again. My friend who runs a Lottery Syndicate asked me it I could give him a formula or a macro to give him all the possible combinations of the numbers from 1-49 which as you are aware runs into millions (13983816 to be precise) what he is going to do with it I have no idea...

Hi Guys Remember you helped me out with the Macro for selecting numbers for our golf club pairings, well it works brilliantely, but while I am in the office at the computer the Secretary is in the bar watching the draw and was supposed to take down the numbers,But he didn't he said he was...

Hi All I would like to create a sheet were you can get the cells to light up and stop on a number after say 3secs or 5secs so the light flashes across all the cells and then stops and then you restart it to get the another number. These numbers are members so there are 250 members so there will...

Hi There Luke M Just to inform you I will not be able to post the Macro I have used Because it does not work. When I went into it a day later all the dates had updated to that day's date (22/9/12) and today it has updated again to (23/9/12) So it does not fit the purpose and anyway I do not...

Hi There It is me again. I would like a bit of help on including a date in my formula.I work out the pairings for our golf club. I have sorted out the formula for doing that with all the help from all you kind people in the past.=COUNTIF($F$2:$F$550,12) but what i want to do is include the...

I wonder if some one can help me out here I have done an array table in Excel and clicked on Save but it has come back you do not have permission to save. Contact your administrator. I am the Administrator I own the PC whats all this about I have never had this before. Mind you it is Windows 7

Hi I was just wondering if there is a formula for shuffling numbers in a column so I can do the August medal event to stop the moaners. Example A 1 2 3 4 5 6 7 8 Shuffle them so you have somehing like. Example A 7 2 6 4 1 5 8 3 I don't know if it can be done but it would...

Hi I have a problem.I would like to obtain the amount of times triple sets of numbers appear in a database.I formulated one for pairs of numbers which works fine with this formula. =IF(ISNA(VLOOKUP(Pairs!$A2 & "." &Pairs!C$1,PairStats!$A:$D,4,FALSE)),"",VLOOKUP(Pairs!$A2 & "."...

I have a bit of a puzzle Why does'nt my database open up at the last place i inserted data it just opens up on row (112) every time and i am on row (2145). I realise it is not a big deal but it is so annoying that I have to scroll down every time.And the baffling thing is my other two(2)...

Hi There I wonder if someone could help me out here I want to sort 5 columns of numbers from smallest to largest and there are 250 rows and I want to do them all at once instead of the labourous task of doing them one at a time. I have tried to do it one at a time but when I try the next row...

I have a large amount of data in five columns G,H,I,J,K, they are all numbers. What I want is a formula that will count all the Numbers below Four (4) and all the numbers above seven(7). I was thinking is it something like =SUMIF(G$1:K$310)<4 and =SUMIF(G$1:K$310)>7. As you have probably...