| Thread | Last Post | Replies |
|
| Overrule/Replace | 20 Sep 2006 18:22 GMT | 1 |
I have a row where I will be using tally marks. I only want one tally per row but it is based on a progression to track steps in the process. So if they have reached the next step they can just put a tally (an X) in the new cell and it will auto replace the previous
|
| Printing the first two rows as headers. | 20 Sep 2006 17:33 GMT | 3 |
I would like to have the first two rows print at the top of every page of my print out. I know this is a basic function, yet I can not seem to find it in the help function. Could someone please post how to do this /AND/ tell me what key words to put in the search/help ...
|
| Format Column by text in first row | 20 Sep 2006 16:22 GMT | 2 |
I have multiple documents with similar data, but not always in the same format (thanks to too many users touching them). Each document has multiple sheets and I would like to write a Macro that will format a particular column to a certain Date Format. I know how to write this
|
| Concatenate error/problem | 20 Sep 2006 15:50 GMT | 4 |
Who can help me with this problem>>?? I have to concatenate 5 items (and between all items an ", " (comma)), which I let lookup from a list containing 24 rows. This is what I'm using:
|
| Prevent Auto Parse | 20 Sep 2006 15:47 GMT | 1 |
This is the behavior I observe in Excel that I would like to change: Excel 2003 1) Paste from a delimited text file (comma, tab, space, doesn't matter) into Excel (text appears in a single column)
|
| Help with SUMIF function | 20 Sep 2006 15:40 GMT | 4 |
I'm trying to add up a range of cells based on two IF statements, but with no luck :( What I was trying to do was: =Sum(If (G3:G2224,"Home")*(M3:M2224,"Blue"),P3:P2224)
|
| i cannot use the mouse right click in excel. how to rectify? | 20 Sep 2006 13:54 GMT | 6 |
i cannot use the mouse right click in excel. how to rectify?
|
| Taking out domain names out of e-mail adresses | 20 Sep 2006 08:42 GMT | 1 |
In Excel I have a column with a few e-mail addresses. And I was wondering if it's possible to take the domain name out of the e-mail address and put them in the column next to it? Thanks,
|
| text in rows in small height | 20 Sep 2006 07:16 GMT | 3 |
I have set up a fine grid (small row/column spacing) that I want to use to display text at specific coordinates. Is it possible to put normal sized text (let's say size = 10) in 'small' rows (let's say row height=3) such that the text is still
|
| Hello and Help with dropdown list with error control | 20 Sep 2006 06:47 GMT | 5 |
Greetings all!!! I am new to the group. thanks to the owner of the group for creating it. I work for a cement company and i have made a excel sheet with mixing of diffrent types of cements. I would like to know if anyone can
|
| Food Details. | 20 Sep 2006 04:30 GMT | 2 |
OK. I am going to start weight training and need to set up th following. I have 8 sheets (1 for each day) and another sheet with the food I lik to eat. Each food has details such as. Protein, Fat, Carbs etc. What
|
| formula | 20 Sep 2006 04:25 GMT | 3 |
a b c d 1 Mon 0 0.00% 100% 100% 2 Tue -5141 -7.32% 93% 100%
|
| Advanced filter and a list | 20 Sep 2006 02:11 GMT | 14 |
Today's discovery:- I have a *column* of first names, some of which are duplicates. I did a sort and then I tried to do advanced filter and I ticked unique records. The info generated was not 100% correct - one name showed up *twice*. In other words, I didn't get a list of ...
|
| Advanced Filter | 20 Sep 2006 01:16 GMT | 1 |
I need help with my advanced filter. I want to filter my customer list, sheet 1 to work sheet 2, with only the customers located in Palm Springs, Rancho Mirage, Indian Wells, La Quinta & Cathedral City, CA. In cell W43, I have inputed CITY & below that, W44:48
|
| Macro Help | 20 Sep 2006 01:14 GMT | 2 |
I don't know very much about coding macros at all so I was wonder how I would get one to change the content of a selected column's individual cells based on that cell's content. For example, if have column A with either "e" or "c" in each cell I want the macro to change the c's ...
|