| Thread | Last Post | Replies |
|
| Vlookup to transform columns to rows | 20 Oct 2007 21:36 GMT | 2 |
I have data, for example: Empl No. Emp First Emp Last Dependents Dep1 Dep2 Dep3 98789991 John Doe Mary Mary
|
| functions for if | 20 Oct 2007 21:34 GMT | 2 |
Hello I need your help again. I am working on a spreadsheet for recording condensate return which is metered and read daily (almost daily). I want my sheet to subtract the reading from today from the reading for yesterday. then i'll have a totals cell. the problem is that ...
|
| Exponential equations | 20 Oct 2007 20:16 GMT | 5 |
How do I enter and exponential equation in a cell?
|
| Name Generator | 20 Oct 2007 18:04 GMT | 3 |
As a soon to be father we have a list of 1st and 2nd names. I want to create a spreadsheet where I bang in these two lists and it then shows all the permutations with the surname. What formula/s do I need to use for this, or better still can anyone point
|
| Count Functions | 20 Oct 2007 17:04 GMT | 34 |
Hi Everyone i am looking for a formula that would let me count the number of cells with a value between zero and 15? is there something that would work... Thanks
|
| warning box | 20 Oct 2007 15:31 GMT | 3 |
How can I have a message come up when a cell breaks a record. Example if A4 is greater than 50 the say new record
|
| Count occurences and return total | 20 Oct 2007 07:29 GMT | 2 |
HELP! I know someone here can help me! I want to count the number of times a specific ID number occurs in a column, and return the total count in the cell adjacent to each occurrence of that number: ID # Combined Count
|
| TO Average Previous values | 20 Oct 2007 07:08 GMT | 7 |
I have 3 cols such that they look like this: colA colB colC colD 1931jfm 1931jan 1 mean of 1930(j,a,s,o,n,d) 1931amj 1931feb 2 mean of 1930(o,n,d),1931(j,f,m)
|
| Excel 2003 "VLOOKUP" function | 20 Oct 2007 05:01 GMT | 4 |
Can anyone help me with using this feature. I am trying to compare data in one column to data in another and place a 1 in another column to sort by later. Thanks
|
| Serial number generate | 20 Oct 2007 04:59 GMT | 4 |
I am writing a formula to generate a serial number automatically. I use “A1+1” in cell B1. A1=0, then each record will increase. But I can’t do any sorting. On the other hand, I don’t want to change the formula into a value then I can do sorting. Can anyone help please ...
|
| How can I check whether a column of dates are all before today's d | 20 Oct 2007 04:50 GMT | 1 |
I'm working in Excel 2007. I've got a column of dates, and I need to check the column as a whole to ensure that every date is prior to today's date. E.g. if today's date is 10/19/2007, and my column is the following:
|
| grouping help!!!!!!! | 20 Oct 2007 04:16 GMT | 1 |
is there a function called collate to help group stuffs from different cells? my boss told me collate items. but i didnt know what exactly she meant. i dont even know if it s called collate.
|
| negative numbers | 20 Oct 2007 02:48 GMT | 1 |
How do I get a negative number to appear in red with a minus sign instead of brackets or a minus sign in black?
|
| find cell with matching text, then reference cell in same row | 20 Oct 2007 01:05 GMT | 2 |
I have a main sheet and many additional sheets with peoples names' (each sheet is named for a person - including a command and space). The main sheet is named 'Master Inventory' On the main sheet, there is a row for each person. Column A has the
|
| Type a cost code in one cell and discription in an other | 20 Oct 2007 00:25 GMT | 4 |
I would like a formula that will let me place a number in one cell (its a cost Code) then the next cell to show the discription of the cost code selected. I have it working using "if" but i have the problem of the dreaded "Seven" is there any way that i can increase the seven. ...
|