Search results

Hi Narayan Thanks for that I will try to work out how to use it because I have never used Macros before I assume you just enter it into a module in VBA is that right or does it go straight onto the worksheet? Anyway I have to go now got to play nine holes before it gets dark.See you tomorrow...

Hi Narayan Yes that will be fine there is no urgency however long it takes no problem many thanks for that it will save me a lot of time. Mike

Hi Narayan Yes that would be great but I have no idea how to write a macro. Mike

Hi Narayan Many thanks for your info and knowledge. I was not aware Excel sort worked like that.I would suggest Microsoft revamp this sort programme because it is not much use like that only one (1) row at a time blooming crazy I will be here forever doing 850 rows.But anyway if that is how it...

Hi Narayan The data is across (6) columns A,B,C,D,E,F and the layout is like this A-B-C-D-E-F 4-6-2-5-8-3 7-1-3-6-2-2 9-6-8-4-7-1 and they should be like this A-B-C-D-E-F 2-3-4-5-6-8 1-2-2-3-6-7 1-4-6-7-8-9 So when I highlight all the data and ask it to sort from left to right it just...

Hi there Narayan Its me again can you help me out with this sorting of rows of numbers. I have approx 850 rows of numbers that have been created with the formulae we did previously but they have not come out in the right order so i want to sort them from small to large. I have done the sort...

Hi Narayan Your'e the man. That has done it everything is just how I want it now. Many thanks for your time and trouble.And also my thanks to SirJB7.Have a great day and a brilliant life. Mike

Hi Narayan I have tried that using column (H) it enters 1 in H1 2 in H2 and so on when I ask it to sort from Largest to smallest nothing happens. I am wondering if I entered the formula wrong should it be =ROW() or =ROW(H) because the data is in column (A)? Mike

Hi Narayan I trust you are well.Thanks for the info but I dont want to sort the data I want to flip it so the data in A1250 appears in A1. A-B-C-D-E- ------------A-B-C-D-E 1-2-3-4-5 ------------11-12-13-14-15 6-7-8-9-10 -------------6-7-8-9-10 11-12-13-14-15----------1-2-3-4-5. So as you...

Hi SirJB7 I have entered the formula =INDEX(A:A,1250-ROW()+1,1) in column H and all I get is a (0) so I guess I am doing something wrong I have tried it with this formula=INDICE(A:A;1250-FILA()+1;1) but it just says invalid Regards Mike

I have a large spreadsheet database and I would like to reverse it i.e. flip it from top to bottom so the data in A1250 B1250 C1250 D1250 E1250 appears in A1,B1,C1,D1,E1. And A1,B1 etc appear in A1250 B1250 etc. Is this possible to do?. Mike

Hi there Narayan Just to let you know I have managed to sort out the date problem and now everything is working fine. Thanks a million for all your help and assistance greatly appreciated. Have a Good Day and A Brilliant Life. Mike

Hi Well I have done that and we have moved up on dates it now displays Mon,Sep,25,1944 so if I keep fiddling with it I might get into the 21st century. Anyway lets not worry about it Narayan I will just enter the date manually it seems the easier solution don't you think Mike

Hi Narayan Well I have done that with this formula =SUMPRODUCT(($A$2:$E$1250=$I3)*($G$2:$G$1250=J$2)*($H$2:$H$1250)) and all I get is Sat,Jan 00,1900 except the 6th one were it displays Wed,Feb 00 1900 I am puzzled why it displays a date which is miles out. And yet the {} enclose the formula...

Hi Narayan I have put that formula in and it works but the date it gives is 00/01/1900 it must be right because Excel encloses the formula with {formula} anyway i will try to work it out somehow. Mike

Hi Narayan I have discovered the problem it is with my original formula it does not include the date.I don't know how I missed it but I did. This is my original formula that works fine for all the Trophies Members etc =SUMPRODUCT(($A$2:$E$1250=$I3)*($G$2:$G$1250=J$2)) But as you can see there...

Hi Narayan Sorry I have took a long time replying been out on business.I have tried this formula and it just returns #N/A and I followed your instructions exactly as you said but to no avail. All I really want is just the date which is in column (H) on both my spreadsheet and my master copy...

Hi NARAYAN I have tried that formula and it gives me #N/A.Do you think it would be better if I just asked it to match just the DATE and not the rest of the info. The date is in (H) on sheet A and also on sheet (B). So could I say something like Match sheet A H2:H120 and then it would put all...

Hi Narayan There is no problem with the data at all. It is just the date column it is not entering the date. What I need is the formula to enter into the date column on the master copy which is in another Workbook so in reality this column will acept the date I have printed on my spreadsheet...

Hi Narayan The master copy is the original one where all the data is members,trophies,winners etc etc the spreadsheet is where I quickly put in the winners etc to save me scrolling through the massive list everything goes in except the date. I want to be able to put the date in with a...

Hi Narayan Members----------Trophies-------Date A,B,C,D,E----------F------------25/2/12 this the spreadsheet I enter onto and then that changes the master workbook. But unfortunately the date does not alter so I assume that I have done something wrong there but what I need is a formula to...

Hi there NARAYANK991 Its me again just to let you know everything is working fine on my sorting trophies and members that you sorted for me. Except one thing the date when i put the info in the spreadsheet it does not pass the date into the master copy and I don't want to have to filter...

Hi NARAYANKA and LUKE M Great news guys I have sorted it. It was the cell numbers instead of being Absolute they were increasing so I had to put Double $ signs in and hey presto it worked. So everything is sorted and that is down to you two guys THANKS a MILLION for all your time and effort...

Hi NARAYANKA I cannot upload the files because the Forums rules do not allow it apparently and more to the point I would not know how to upload it because I have never uploaded anything in my life so I would not have a clue where to begin Mike

HI Luke changed that to the sumproduct formula it works on the first row Member 1 and through the whole row of trophies upto 15. But all the rest of the members cells are filled with #N/A.But when i was dragging them across and down I did notice it filled with all the relevant numbers but...