| Thread | Last Post | Replies |
|
| Selection.Value = ARRAY Limit? | 22 Aug 2006 00:13 GMT | 1 |
I'm at a loss and I'm hoping someone could help. Dim IA_Array(659, 229) As Variant 'In the code - I load this array with values ActiveSheet.Range("E11:IQ660").Select
|
| Sort Data Base By Column | 21 Aug 2006 23:22 GMT | 4 |
I'd like to sort a data base by column C and have all the associate date in the rest of the columns sort as well. How is that done? Thanks for any help Travelerswa
|
| separating data into multiple columns | 21 Aug 2006 23:07 GMT | 1 |
I have a spreadsheet that lists people in the format LastName FirstName. I want to create a formula that will put the last name i one column and the first in a different column. Can someone pleas point me in the right direction? Any help would be greatl
|
| WHAT ARE PARENTHESIS IN FORMULAS? | 21 Aug 2006 22:43 GMT | 2 |
I have a formula: =(h24*j24)+(h25*j25)/sum(h24:25) But I have no idea how many parentheses I am suppose to place around the formula or what additional ones I need other than the one that surround the indivudual formula.
|
| Home Key - Excel 2003 | 21 Aug 2006 22:28 GMT | 2 |
In Excel 2003 is it possible to go to the beginning of a spreadsheet b pressing just the Home key instead of Ctrl + Home. I'm sure that I use to be able to do this in an earlier version. Thank
|
| Sequential Numbering | 21 Aug 2006 22:20 GMT | 4 |
I would like to know the formula for making a cell be able to do sequential numbering such as for purchase orders.
|
| How to convert Excel file to CSV Question | 21 Aug 2006 21:02 GMT | 1 |
I need to create a csv file from an Excel file. I attempted to create one by using teh "save as" command. But when I do the resulting document looks the same. I expected it to look like a text file with commas separating the cells.
|
| Validation Default Value | 21 Aug 2006 20:26 GMT | 2 |
I'm using a validation list to populate cell B7 on my worksheet. The choices on this list are dynamic and change based on the value in cell H6. Cell B6 then shows a VLOOKUP value based on the contents of cell B7.
|
| Convert to time | 21 Aug 2006 20:00 GMT | 12 |
How would I go about converting 8.00 to 8:00:00 AM in excel. Can this be done?
|
| Excel General | 21 Aug 2006 19:20 GMT | 1 |
If I have two columns of numbers in an excel spreadsheet is it possible to put in some formulae or some other function thatlist out the common numbers in both the columns. Basically I need to eliminate the #'s in column A that figure in Column B too.
|
| Random 8 digit number? | 21 Aug 2006 18:29 GMT | 6 |
I need to know the formula to create a column of random 8 character ID numbers, preferably with a set prefix of 3 numbers. I'd be REALLY happy if I could create it with random text and numerals, but it doesn't have to be. (where 123 is the constant)
|
| convert number to text | 21 Aug 2006 18:28 GMT | 1 |
how to :- 100 convert to One Hundred only and 100.30 convert to One Hundred and 30 Cent onl
|
| custom number format | 21 Aug 2006 18:23 GMT | 1 |
is there a way to format a number so that: if there are decimal places, you see: 1234.56 (which includes the "." character), but,
|
| Help! Error Message = No program is registered to open this File | 21 Aug 2006 18:20 GMT | 4 |
Fellow forum members: I'm totally confused why all my Excel hyperlinks don't work and displa the messages below everytime I select one: "Some files can contain viruses and otherwise be harmful to you
|
| Summing up data from various worksheets | 21 Aug 2006 18:17 GMT | 12 |
I have daily data all on different worksheets (31 in total) and I would like to add up all of the data in these worksheets in a monthly compilation I have so far been using the =sum('jan. 1'!B6, 'jan. 2'!B6 ... etc.)
|