Search results

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 Luke Thanks for your assistance but obviously as you agree the Array table would be enormous. Still we all have these scatter brained ideas from time to time it was only when I really thought about it that I realised it was a no-goer, still it would have been cool to actually do it.Anyway...

Hi Sajan I am trying to find how many times a (Trio) plays against other (Trios) Example 1,2,3, plays 4,5,6,and then 1,2,3, plays 4,5,7. 1,2,3, plays 4,5,8.and so on. But on reflection I think I had better scrap this idea because the Array table would be absolutely enormous.Thanks for your...

Hi Luke & Sajan. My apologies for not getting back sooner but unfortunately we had a power cut here they blamed the constant rain for it typical anyway they have fixed it now. so to revert back to the problem i will lay out how I want it to work. A, B, C, D, E, F, 15 22 14 35 55 16 04 18 03...

Hi Luke & stthomas I have put in the Formula from Luke and all it returns is (0)in every cell but the formula is bracketed by {} so excel does not see an error. And the formula from stthomas returns (value) in every cell so what do you think guys what have I done wrong? Thanks Mike

Hi Luke. Well a triple set of numbers is say 1,2,3 or 14,26,45 the earlier ones I gave were just examples.So the database looks like this. A, B, C, D, E, F, 1 12 22 31 38 45 15 2 19 24 44 50 1 2 3 17 35 39 So I would want know how many times say (12,31,45)(1,2,3)(2,19,44) appear in the...

Hi Luke. No what I mean't to say three(3) numbers for example 1,2,3 how many times they appear in the database.These numbers refer to club members it is easier than putting their names in.e.g 1=Joe Stanton 2=Brian Hatton 3=Gordon Dean and so on the numbers go upto 329 so as you can imaging the...

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

Hi Hui Believe or not I have cured it don't ask me how I just deleted it all and reinstalled it onto the worksheet and low and behold it works perfectly I don't know why but something must have been amiss anyway problem solved thanks for your assistance in this matter have a great day and a...

Hi Hui Yes I am using Microsoft Excel 2010. I have tried leaving one cell highlighted but that does not work it seems no matter what I try it always opens at 112. I have even deleted the entries in those cell on 112 but even that does nothing bit of a Puzzler really. Mike

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 SirJB7 Once again you come to the rescue that worked fine all 250rows sorted in seconds saved me a lot of time. Once again many thanks for sharing your knowledge with me Have a great day and a brilliant life. Mike

Hi Montrey Thanks for a quick response. Unfortunately this does not appear to work all I get is (Name) and I dont really understand what you mean by lock the range does that mean highlight all the rows. Because I am assuming the format is entered into a different cell the cells with the numbers...

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

Hi SirJB7 Thank you for that i have worked it out even though Excel said I had an error in my formula would I like excel to correct it which I said yes and guess what it did and gave me a return of (0) in every cell wonderful anyhow I plodded on and came up with this formula...

Hi SirJB7 Thanks anyway. Just one little queery is there a formula for the same thing. I would like to be more specific by asking it to find all numbers lower than four (4) but not greater than ten (10) so it would be something like =COUNTIF(G$2:K$40,"<4"?????> is this possible Mike

HI SirJB7 Sorry i Made a mistake in my last post the formula should read =SUMIF(G$1:K$40,"<4") Not =SUMIF(G$1:K$40,"310<4") Mike

Hi SirJB7 many thanks for that info. But unfortunately the formula did not work as I had hoped I entered it and it returned a number of (395) for numbers below four (4) and I was amazed so I counted through them and there was only fourty one (41) so I don't know what happened there all I can...

Hello Cyril Many thanks for that. I thought it was something like that but not being very good at Excel I thought one of you experts would sort it again many thanks.Have a great day and a brilliant life. Mike

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

Hi Narayan What a man you are that is perfect it did it all in about 10 secs. It just puzzles me why Microsoft cannot include a formula like this in the Excel formulas it makes things so much faster and easier than this trying to do 850 rows one at a time. Once again thanks a million Narayan...

Hi Narayan I have done that and it came back Run-time error "1004": Method "Range" of Object"_Global'Failed And when I went back into it it had highlighted this Set Sort_Range = Range("Data Range") So what that means I have not got a clue. Because I know nothing about Macros. Mike

Hi Narayan I presume you mean this which is what you sent me. Sub thun() Public Sub Sort_Entire_Range() Set Sort_Range = Range("Data_Range") For Each row_num In Sort_Range.Rows row_num.Sort Key1:=row_num, Orientation:=xlSortRows Next End Sub End Sub And then it comes back Compile...

Hi there SirJB7 I have completed the reversal process of the Data with a formula provided by Narayank991 it did the trick. I thanked him and also yourself for your time and trouble with my next post.Anyway once again I thank you for time and hope to hear from you again.Have a good day and a...

Hi Narayan Good Morning. Well I have entered the macro and it comes back with (Compile Error Expected End Sub) whatever that means because I have not got a clue.I entered it into the sheet which is (Sheet3) which has the data on it so what have I done wrong? Mike