|
|
Concatenate formula by
Bricky
Hi
I'm trying to get a formula using concatenate that will identify numbers in
a row 3 (4&5) and returning the name of the column above into one cell....
|
November 11th, 2009 04:30 AM
by Bricky
|
0 |
110 |
|
|
|
November 11th, 2009 04:27 AM
by GaiGauci
|
4 |
153 |
|
|
Subtotal placement issue by
simmerdown
I am running Excel 2003 SP3.
When calculating a subtotal on location, then by salesperson, excel is
inserting the subtotal for the salesperson after the...
|
November 11th, 2009 04:27 AM
by GaiGauci
|
2 |
140 |
|
|
|
November 11th, 2009 04:27 AM
by GaiGauci
|
3 |
139 |
|
|
|
|
0 |
137 |
|
|
Show Pages for Excel 2007 Pivot Tables by
Jim Georgia
Where do I find Show Pages on the Excel 2007 Ribbon?
In earlier versions of Excel, this feature was extremely useful to
automatically create a new Worksheet...
|
|
5 |
131 |
|
|
FLOOR FUNCTION by
Confused
I am trying to use a floor function to calculate overtime. For every 8 hours
worked, our employees get paid .5 of OT. The floor function works up until
136...
|
|
5 |
162 |
|
|
Special Financing Calculator Help Please by
Steve
Looking for a calculator for estimating insurance premium financing payments.
Here are my "variables"
Premium payment amount = $75,000
Downpayment amount=...
|
November 11th, 2009 04:24 AM
by Steve
|
4 |
127 |
|
|
Password for cells and Password for sheet by
Emece
I have some cells protected with a password so that they cannot be modified,
and I want to add a different password to the sheet. Is this possible? Thanks
in...
|
|
2 |
105 |
|
|
|
November 11th, 2009 04:20 AM
by Melody
|
4 |
142 |
|
|
|
|
1 |
143 |
|
|
Pivot Table Calculated field error by
Jeff Metcalf
I have a pivot table that
As Rows
Service Territories
As Values
Count the number of service calls
Sum two columns of data consisting of 1 or 0 depending on...
|
|
1 |
126 |
|
|
macro for chart data range extension by
mohavv
Hi,
I've 12 graphs with 6 lines each.
I want to extent the ranges of the lines and labels with 1 column
(already extists in data range).
Is there a way to...
|
November 10th, 2009 09:24 PM
by mohavv
|
0 |
156 |
|
|
extract duplicat values by
adeel via OfficeKB.com
i have large amount of data in two sheets with many rows and columns. now I
want a formula which could extract duplicat values (matching sheet 1 & sheet
2) and...
|
|
1 |
158 |
|
|
retaining email addresses by
srd0613
When I’m ready to send the excel sheet as the message body, I hit the ‘send
to mail recipient’.
If this is a sheet that I send out as a message body on...
|
November 10th, 2009 08:28 PM
by srd0613
|
0 |
149 |
|
|
Formula Help by
KBrown
I need help with a formula...
I have two columns of data and I need to figure out a way to have Excel
figure out the third column. The data is being...
|
|
4 |
153 |
|
|
"GWXL97.XLA could not be found" by
300driver
When I try to run any command from the file menu, such as "save as" or
"save" in Excel, I get "GWXL97.XLA could not be found. Check the spelling of
the...
|
|
1 |
366 |
|
|
Need Date Formula Help by
vegasrenie
This formula is supposed to subtract one day every day. It works perfectly to
30 days, and then on the 31st day, it resets to zero. It needs to go...
|
|
3 |
158 |
|
|
Modify excel office online template by
Sam
I downloaded an invoice template and one column is too narrow for the numbers
I have to write in.
I am an experienced user but could not find a way to chage...
|
|
3 |
149 |
|
|
|
|
1 |
107 |