|
|
Sumif (I think) by
Jarod
How do I sum with more than one criteria
Example:
Product Line Period Revenue
Dewatering 1 $5,000
Dewatering 4 ...
|
|
1 |
978 |
|
|
Does anyone read books? by
Dave Thomas
If I were new to a subject, I would read a book about it and practice the
exercises, rather than ask simple questions like: "How do I add the value in
cell...
( 1 2 3)
|
July 26th, 2007 02:16 PM
by CLR
|
25 |
976 |
|
|
Drop down list by
AJ
Hello, Im trying to create a linked multiple drop down list in excel and im
not sure if it can be done, such as in the first list of pipe diameter,
second...
|
|
4 |
976 |
|
|
|
|
1 |
975 |
|
|
|
|
1 |
974 |
|
|
Eliminate rows in a worksheet by
Deedle
I need to do a comparison of 2000 records from 1 month to the next. I
brought in each months 4 columns of financials. I created formulas to
subtract 1...
|
|
2 |
972 |
|
|
|
|
1 |
968 |
|
|
Changing fonts with a formula by
Blue Max
Is there any way to change the font of a cell using conditional formats or a
formula that will specify the font?
It appears that conditional formats cannot...
|
|
4 |
968 |
|
|
How do I match records from two Sheets? by
sebastico
Excel 2003
Sheet1 has one column with 904 records (alphanumeric)
Sheet2 has one column with 1069 records (alphanumeric)
Both fields have same format (17...
|
|
4 |
964 |
|
|
|
|
4 |
964 |
|
|
|
|
11 |
963 |
|
|
microsoft public excel newusers tips by
snack[_2_]
dear friends,
Someone sent me a spreadsheet with a column for email addresses.
Only
some of the addresses are clickable links and I thought I'd...
|
|
1 |
957 |
|
|
Excel format conversion by
Aaron H
Hi guys, is there a way to convert the following
123456789 to 123-456-789
or
abcdefghi to abc-def-ghi
I need to convert a long list of serial numbers so I can...
|
|
9 |
954 |
|
|
WEEKDAY() by
Epinn
Regarding WEEKDAY(), I read that problems can occur if dates are entered as text.
Based on this, it is understandable that =WEEKDAY(2/14/2008) returns a wrong...
( 1 2 3)
|
September 10th, 2006 11:39 AM
by Epinn
|
29 |
954 |
|
|
|
|
5 |
951 |
|
|
|
|
1 |
947 |
|
|
INVENTORY CYCLE COUNT IN EXCEL by
SSJ
Hello to all!
I want to start an inventory cycle count program in my company. How can Excel be used to do random selection? The only data I currently have is...
|
March 21st, 2007 06:16 PM
by gls858
|
3 |
939 |
|
|
|
|
0 |
936 |
|
|
Selection after enter by
Jeanette Caldwell
After entering data into the active cell, pressing the tab key moves the
selection to the right, but pressing the enter key does not move the
selection at...
|
April 30th, 2010 03:43 PM
by JLatham
|
4 |
935 |
|
|
Duplicates - ?? by
JLMcCabes
One worksheet has 600 + lines with a lot of expenses, including SOME of the
local expenses. This is a check register..
Another worksheet has 300 + lines with...
|
|
5 |
934 |