| Thread | Last Post | Replies |
|
| matching data on two separate worksheets | 17 Sep 2007 03:16 GMT | 1 |
Can anyone give me a succinct way to match two sets of information relating to names (as matching field(s)) and merging both sets of information on one line to create a new full record for each name. eg One worksheet contains Forename, Surname and various field containing
|
| why does the date 09/01/07 come up as January 9, 2007? | 17 Sep 2007 03:10 GMT | 4 |
When I type September 1, 2007 as 09/01/07 excel formats it to 09-Jan-07. Why is that? It didn't used to do this, it changed to this recently and I can't find the option to change it back.
|
| I need Formula help | 17 Sep 2007 03:03 GMT | 7 |
I need to enter a # into a cell C4 down the page in C33 I need a formula that will accept the # entered in C4 if it is between these two numbers 50 & 252
|
| Filter and copy to combo box | 17 Sep 2007 02:42 GMT | 1 |
I have 4 col. that I want to filter them based on a criteria that is in a combo box then I want to populate the result into another combo box . is this possible? thx.
|
| Match function | 17 Sep 2007 02:22 GMT | 3 |
I run football pool and am trying to find out how to make my life easier lol I am looking for the formula I would need where I would put the winning teams in column A, paste their entry into column B and have column C show a value of 1 if it matched. Would appreciate any help ...
|
| Another Formula Question | 17 Sep 2007 01:50 GMT | 3 |
I want to have a cell equal the sum of two cells, only if the value of one of the cells is greater than zero. If the value of the cell is less than or equal to 0, i want the value of the cell to equal 0. Example:
|
| Looking for add-in for excel named PHStat. Any ideas? | 16 Sep 2007 23:40 GMT | 1 |
I am looking for an add-in for excel named PHStat. Any ideas where I can find it?
|
| Cell to red flag duplicate numbers | 16 Sep 2007 23:14 GMT | 1 |
I want to add nine numbers like a social security number and if it's duplicated it will red flag is this possable
|
| How to red flag certian numbers when entered to a spredsheet | 16 Sep 2007 23:03 GMT | 4 |
Is there a formula that can be made so when you enter a bank numbers in to a column it will red flag those certian numbers on the spredsheet column ie if i entered 123 in a cell it would be formatted to come up red?
|
| How do I make cells blink or flash in EXEL | 16 Sep 2007 22:47 GMT | 1 |
I'm using Exel 2000. I want to condition format certain cells so they blink if the meet a certain condition.
|
| Formula | 16 Sep 2007 22:35 GMT | 7 |
We are trying to get a formula to use for reponse times for our Fire Rescue. For a list of response times, we are trying to get a formula to tell us what percent of the time did we respond less than "x" amount of time. (i.e. 90% of the time we responded in less than 4 minutes if ...
|
| copying formulae along rows. | 16 Sep 2007 22:12 GMT | 6 |
Hi, I'm trying to set up a sheet with the formula ='Sheet1'!E2 in the first cell. I would like to be able to copy this to all cells along the row, so that it increases to ='Sheet1'!E3 then to E4... E5... etc etc. I've tried using
|
| Need Help on formula | 16 Sep 2007 20:47 GMT | 7 |
Have list of column of type of products in C and Total of pounds in D, in cell F3 how do you add up total pounds if E is type of products in column D if Column C have same products? A B C D E F
|
| Validation Question | 16 Sep 2007 20:29 GMT | 2 |
I would be most grateful if someone could offer some help or advice. I wish to Validate a range of cells from D4 to D100 which will only allow the following: 1. only a 7 figure number to be entered.
|
| What program do I need to download clip art onto my computer? | 16 Sep 2007 19:40 GMT | 1 |
I'm trying to download free clip are, but my computer doesn't have a program for the clip art to go into. I have no idea what I need to do.
|