| Thread | Last Post | Replies |
|
| Customer name-do you use 1 column (name all together) or 3(frst,m. | 20 Aug 2007 20:16 GMT | 2 |
I'm a bit new to this discussion group, so please forgive me for any errors. I have an unusual question for everyone in the community. I am working on designing a customer list spreadsheet and one of the things that crossed my mind was the way in which we enter a customer's ...
|
| Nested IF fn Alternative | 20 Aug 2007 20:16 GMT | 6 |
I am trying to string together IF functions to fulfill my requirements. However if i need more than 7 conditions (from my understanding the nested IF functions only go up to 7 cases) is there an alternative to this that would give me the same results? Thanks
|
| Merged my cells... now how do I get bulletpoints? | 20 Aug 2007 20:16 GMT | 1 |
Trying to make an order sheet for my company. I merged my cells to make 3 large columns for information. But how do I bullet that information???
|
| Copy range in macro using paste special values | 20 Aug 2007 20:12 GMT | 2 |
I have always copied a range by using the select cell. But then I learned a really easy way to do this with Set Set Rng1 = Sheets("... Set Rng2 = Sheets("...
|
| where are the recently viewed items in office 2007? | 20 Aug 2007 20:11 GMT | 1 |
One of the features I used in office products was the recently used history that was often under the file menu dropdown. Where did that go?? I am so frustrated that I haven't my menu bar anymore and have to add stuff - then I don't get my history so the most recently opened ...
|
| macro to copy from excel range to word doc | 20 Aug 2007 19:54 GMT | 1 |
Thanks to macropod and others, i cobbled together the following code to copy a specific range from a set of excel files to a specific word document. The problem i have, is how to insert a paragraph break in word in between each of the excel ranges after they are pasted into word ...
|
| Text Alignment | 20 Aug 2007 19:48 GMT | 3 |
I am having a problem with Excel, I try to center the Column but it still staggers the data. Here is an example Component 109591305
|
| No one gets it... is there a number I can call? | 20 Aug 2007 19:25 GMT | 3 |
Below is a forum I've posted many times on many websites. I don't believe it can't be done. I need a count of each person in one cell. but im being told each name must be on its own cell to be counted properly "add a row" "add a cell" I'm hearing... WAY TOO REDUNDANT!! So is ...
|
| How do I add 24 hours to a date and time value formated cell? | 20 Aug 2007 19:20 GMT | 4 |
I have a cell formatted with DD/MM/YY HH:MM in 24 hour clock and want to add 1 day or 24 hours. When I use the +time(24,0,0) function the date remains the same and the hours are only added. How do I get it to add a day to the date and time. I'm doing time zone convertions for ...
|
| Permutation combination of a 4 digit no | 20 Aug 2007 19:19 GMT | 2 |
I would like to list all the combinations of a digit 4 number ie; 1234. Pls help tq.
|
| how to get serial number in word? like 1=one, 2=two | 20 Aug 2007 19:16 GMT | 5 |
Respected sir, i wanna know, how to get serial numbers in word insteasd of numericals example when i put value in A1 automaticaly i get the answer in shape of serial
|
| Adding first three and last three entries in rows of data | 20 Aug 2007 19:06 GMT | 6 |
I have multiple rows of data where I want to add the first three entries in each row and compare the total to the last three entries in the row. However some of the rows have blank fields so some rows will have differently spaced first and last three entries. If there are less ...
|
| Return a cell from more than just one row of data | 20 Aug 2007 18:50 GMT | 6 |
I have a spreadsheet that looks like this: A B C D E 1 Task Name AA AL PX 2 Task Name BL CE DF
|
| sort | 20 Aug 2007 18:40 GMT | 2 |
can I get help sorting a data if I sent an attached file through email?
|
| excel size limit? | 20 Aug 2007 18:37 GMT | 1 |
I have a computer with 2gigs memory and over 3Ghz cpu, but when I have a 70mb spreadsheet open and I then try to simultaneously open a 50mb speadsheet I get a window message that says I do not have the available resources to do so. Might this be an excel limit, or something going ...
|