| Thread | Last Post | Replies |
|
| count | 03 May 2006 04:41 GMT | 1 |
I have put * on some values to differiante these from other values. i need to count how many value are with * but * is special character which count all the text values. if i can count these values if yes how?
|
| how do i set up repeating row/column titles in Excel? | 03 May 2006 02:05 GMT | 2 |
i want row and column titles to automatically fill into place in a working spreadsheet, but i do not know how. can someone tell me how to do this?
|
| Formula | 03 May 2006 01:08 GMT | 1 |
I am extremely new a this. I need to find a formula to calculate a net cash flow for a three month period. Where do I start?
|
| Random Selection | 03 May 2006 00:05 GMT | 2 |
How do I randomly select say 6 names from an 18 word list from excel?
|
| lost . . . | 02 May 2006 23:57 GMT | 3 |
I have a range of six cells in a row on my spread sheet. Five cells are empty and one contains data. I would like to find the single cell that contains text and copy that text into a cell at the end of the row. any help appreciated.
|
| #Value! Error when Concatenating | 02 May 2006 23:56 GMT | 8 |
I am trying to concatenate two fields together. They are both numerical fields. I have never had a problem but for some reason some will work but most give me the #Value! error. I am using the 2003 version
|
| add all contiguous numbers-column-row | 02 May 2006 23:52 GMT | 2 |
Hello Group: I have a problem. I used the AutoSum function (Capital Sigma) to total a column, so I don't have to keep changing the sum formula when I add extra rows. My problem is that when I get to the third column, Autosum
|
| columns | 02 May 2006 23:29 GMT | 1 |
I have this spreadsheet and it has two columns A and B. A has name and B has email addresses. I need to in column B sort out the emai addresses that I dont need and leave the ones I do need? :confused --
|
| Help with date ranges | 02 May 2006 23:06 GMT | 3 |
I've got a sheet where I have some columns with dates in and I want a column with the number of working days between them. I've used the DAYS360 function, which gives a rough indication of the number of days, but it's not very accurate. Can anyone give me an idea
|
| Is this Possible? A bit of a brain teaser if you ask me. | 02 May 2006 22:37 GMT | 11 |
I am trying to creat a formula that allows me to change say Smith, John to John Smith. However, It must be done using the LEFT, RIGHT, TRIM, LEN, and SEARCH functions only. The kicker is that I need it to transfer from one cell to another, so CELL:A1 would appear like this: ...
|
| Numbering rows in A1 only no matter info in other columns. | 02 May 2006 21:29 GMT | 3 |
I'm trying to creat a chart 7 columns wide. A1 has customer names. The info in the other columns will runs several rows deep. How to I number just A1 - customer names?
|
| Form Numbers Automatically Increment by 1 Upon Opening | 02 May 2006 21:22 GMT | 2 |
I need to have the form number on the form increment by 1 when the form is opened by another user on the system.
|
| On Error not working | 02 May 2006 20:39 GMT | 4 |
What am I missing here ... Neither On Error Resume Next nor On Error Go To 0 seem to work. Any ideas why? Roger
|
| Function for add different values | 02 May 2006 20:34 GMT | 1 |
I need one function that adds values that are not equal. Like this: 3 3
|
| I keep getting supscript out of range error how do I solve? | 02 May 2006 19:16 GMT | 5 |
Sub ImportCarryLists() ' ' ImportCarryLists Macro ' Macro created 2000/07/07
|