Threads Replies Last Post 125 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  >>   Rename Columns Hi I need to know how to rename a column from the default A,B,C etc to specific names... 7 06.09.2006 22:31:43 Need a macro Ihave data in col A & B Theamount of data can be only 10 lines or could be 100 lines lets assume I have 99 entries in col A & B I would like the macro to copy lines 33 to 66 to start at d1 & d1 then copy the remiander (ie line 67 to 69) to start at f1 & g1 Thanks for the help... 8 06.09.2006 21:12:57 HTML controls in spreadsheet have a spreadsheet that has data in in HTML controls. For example in D4 there is an embed function that contains the control HTMLText15. It shows 87.3 If I use the function value(D4) I get 0. If I write a macro with VBA code I can reference HTMLText15.value and put in cell D4 in another worksheet. How do I know where the HTMLText controls are. Has anyone worked with these. You can rep... 1 06.09.2006 19:15:30 I do not have the List-create a list option on my data toolbar ?? I am trying to arrange my data in a list and I do not have this opition on my data toolbar... 3 06.09.2006 13:10:07 Excel VBA/Macro programming for beginners Hi all, I know a bit VB 6.0 programming. Will it help me to write excel vba/macro(same thing?).can anybody help me by providing some free websites where i can have informations/codes for VBA/macro. Please tell me how could i make a *command Button * in a cell in the excel sheet? -- sdebu_2000 ------------------------------------------------------------------------ sdebu_2000's Profile: http:... 10 06.09.2006 05:29:02 Open an excel Book. How can I speed it up? It takes me 3-4 min. to open an Excel Book. I have cable (Road Runner) and am using USB from modem to tower.Have XP On my old slow puter using ME it always brought the book up in secs. HELP! Am also a beginner - know how to turn on and off and thats about it. ... 6 05.09.2006 22:36:03 How do I change to name of my column Hi I am looking to change the name of my column on the worksheet from A, B, C, To specific names can I do this... 2 05.09.2006 19:48:30 calculate percentile for indexed numbers. Thanks Hi, I have a large series of numbers saved in one column [34,5,21,98,34,3,432,55,27,90,1125,......]. These data are indexed, e.g. by [1,1,1,1,1,1,2,2,2,2,2,2,2,2,2,......N] which are in another column. Basically I am calculating the 25% percentiles for numbers indexed "1", "2", "3",...., "N" respectivelly. There are a lot of numbers with a big uplimit of index "N" so that selecting numb... 2 05.09.2006 18:19:03 libro? por favor que alguien me ayude necesito desactivar la proteccion de un libro por que necesito modificar unos datos pero todas las opciones estan desabilitadas... 2 05.09.2006 18:13:02 Use formatted text instead of number value... Hi, I have a column with formatted leading zero integer values like this: 12345678910 00123456789 and I need to insert a space in this string like this: 123456 78910 001234 56789 I tried to use this function, =MID(F1;1;6)&" "&MID(F1;7;5) however it interprets cells as integer values and not the cells' formatted text values. How can I in my formula use the cells' actual ... 4 05.09.2006 13:51:23 Reading Numbers in Words I need a formulae that can read figures in a specific cell e.g 123 and change them into words (One Hundred Twenty Three) -- tarig ... 2 05.09.2006 13:50:58 calculate percentile for indexed numbers. Thanks Hi, I have a large series of numbers saved in one column [34,5,21,98,34,3,432,55,27,90,1125,......]. These data are indexed, e.g. by [1,1,1,1,1,1,2,2,2,2,2,2,2,2,2,......] which are in another column. I need to calculate percentiles (25%,50% and 75%) of these numbers for different indexes. In another word, I need to calculate percentiles for those numbers with index of 1, 2, ... respect... 6 05.09.2006 13:42:01 How can I undo someting that I saved I accidently saved a spread sheet as something else and I need to get back the previous item?... 5 05.09.2006 09:34:43 repeated formulas in excel I want to use the same formula a load of times in one column, the only thing differing being the cell number it's working on. Kinda like adding up 2 cells on the left, and putting it in a new cell on the right, and doing that 100 times... 7 05.09.2006 09:03:54 Enter Hours duration over 24 I thought if I formatted a cell as [h]:mm:ss, I would be able to enter = 57:00 into a cell but it changes it 02/01/1900 09:00:00 (whihc is I know 2 days and 9 hou= rs = from base date) It displays as 57:00:00 In fact I get exactly the same if I entere 57:00 into a general cell Obviusly 23:00 works fine, but there must be a way of storing a time = duration over 24 hours ... 2 05.09.2006 07:40:06 Index ( ) Please refer to the INDEX () in Help. (1) Please scroll down and take a look at the third example of Reference form. =SUM(INDEX(A1:C11,0,3,1)) I don't agree with the following description (result) beside the above formula. "The sum of the third column in the first area of the range A1:C11, which is the sum of C1:C6. (216)" Please note that the sum of C1:C6 is NOT 216. So, eithe... 5 05.09.2006 05:52:01 Posting a message here with an attachement I have a question which can get quite detail with the explantion unless I am able to post the actual spreadsheets to go with the questions?... 8 05.09.2006 01:23:16 Problems downloading from Max's website Max, can you tell me how to download files from your web site? If I rightclick, it downloads a file, but then when I go to open it, I get an error message. Clicking on your download button, opens another web page, with nothing on it. Janev... 3 05.09.2006 01:19:02 Array formulas and braces { } I have no problem entering the following array formula, but I still have some questions. {=INDEX({1,2;3,4},0,2)} I understand that the { } for array formulas are included by pressing Ctrl+Shift+Enter. That was what I did with the OUTER braces (the ones enclosing the entire formula); no problem. For the INNER braces (the ones around 1,2;3,4), I thought I had to use Ctrl+Shift+Enter. ... 5 04.09.2006 22:57:20 gridlines some gridlines have disappeared on an excel worksheet. How do I get them back?... 2 04.09.2006 20:25:34 how do I change the format of a template in excel ?? i need to change some of the pre-set options in a cash flow template. I can't seem to unlock the description or the formula to cells...... 2 04.09.2006 18:47:00 counting cells that contain a specific value I have a spreadsheet containing hundreds of business contact names, addresses, etc., with the city and state in adjacent columns. I'm trying to find a good way to easily and quickly count the number of contacts in a particular city. One obvious way might be to sort by city name and count the rows, being careful not to count those contacts in a city with the same name, but a different... 3 04.09.2006 13:09:28 does a worksheet really end in row 2252? in page break view, i couldn't extend my sheet further down row 2252. is there a setting i can override so i won't have to continue on another sheet?... 3 04.09.2006 10:00:27 how can I clear an apostrophy in front of number in excel I know how to change formats - however I have a formatted cell for a 100 + rows that appear to have an apostrophy as a lead. While I don't see it, I am concluding that because changing formats to general or text is not removing the green box in corner and is not allowing me to do a vlookup using this column of info.... 5 04.09.2006 09:39:02 How do I print just the section a through f only? Version 2003 Thank you for any help. Sincerely, Colors... 4 04.09.2006 08:08:03 125 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  >>