|
|
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 |
995 |
|
|
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 |
992 |
|
|
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 |
988 |
|
|
|
|
1 |
987 |
|
|
Random Function in VB by
Jim Campbell
I am trying to use the Random Function in VB to generate a series of Random
numbers equal to a counter that is date based. and insert the random numbers
into a...
( 1 2)
|
|
10 |
986 |
|
|
|
|
1 |
986 |
|
|
|
|
1 |
984 |
|
|
|
|
4 |
980 |
|
|
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 |
978 |
|
|
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 |
977 |
|
|
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 |
974 |
|
|
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 |
972 |
|
|
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 |
971 |
|
|
|
|
11 |
969 |
|
|
|
|
5 |
959 |
|
|
|
|
1 |
954 |
|
|
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 |
951 |
|
|
|
|
0 |
949 |
|
|
Conditional Formating by word(s) by
Michaelcip
Hello, I have 2003, I'm trying to color cells that have specific words w/in
the cell. I want to count words like "*broke*" and "broken*" as the same to
get...
|
|
2 |
946 |
|
|
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 |
944 |