|
|
|
November 11th, 2009 07:44 PM
by CLR
|
3 |
220 |
|
|
|
|
2 |
252 |
|
|
3-d reference is not updating by
TigerMO
I copied a range of cells from Worksheet2 and went to Worksheet1 where I used
Paste Special, then clicked on Paste Link. The cell formulas now show a cell...
|
|
1 |
256 |
|
|
Automatically color merged cells by
Rick
Using Excel '07, I'm trying to automatically highlight a list of vertically
merged cells the same color as their unmerged rows next to them. For...
|
|
1 |
241 |
|
|
Date reverts to numeric format by
ManhattanRebel
I have a date in this format May 1, 2009. I’d like to keep it in that format,
but when I concaternate it with another cell, the date converts to a numeric...
|
|
3 |
246 |
|
|
excel formula won't copy down by
Janet T
=sum(c1-a2+b2). Just a simple formula for keeping track of cks for bank
statement. Have used it for well over a year with MSC Office Home and
Student, now...
|
|
7 |
255 |
|
|
Copy Problem with 2007 Conditional Format by
Andy
The link below will let you see what I am doing. I have created the formula
in F3 based upon the values for D3 and E3, but when I copy it down through
the...
|
|
2 |
202 |
|
|
Numbers in a formula! by
Shadowdw
This may sound daft but i'm baffled! I have an IF formula shown below:
=IF(T4= ,"Level 4","")
in the large gap above I would like to place the...
|
|
4 |
202 |
|
|
Saving in new file format by
moon
Hi,
I just upgraded from Excel 2003 to Excel 2007. When I saved an Excel
document written with Excel 2003, I got the following Compatibility Checker...
|
|
2 |
350 |
|
|
Addition based on left column by
Marc
How can I add the column on the right based on entries to the left? I want to
add up all Zuari Inds., Zydec Gentech, Zydus Wellness, Zylog Systems.
Zuari...
|
November 11th, 2009 05:56 PM
by T. Valko
|
4 |
257 |
|
|
Hide/Show details in an Outline Group by
JimAA
I'm trying to create a simple two column cost summary in Excel 2007. Column
A has about 700 rows of Cost Item descriptions and Column B is where I want
to...
|
November 11th, 2009 05:56 PM
by JimAA
|
0 |
234 |
|
|
|
|
6 |
192 |
|
|
|
November 11th, 2009 05:49 PM
by CLR
|
2 |
220 |
|
|
Truncating a VIN by
lputnam
I have an excel spreadsheet with several hundred VINs and want to truncate to
show only the LAST 6 digits. What formula do I use that will look at the cell...
|
November 11th, 2009 05:28 PM
by CLR
|
3 |
240 |
|
|
Finding duplicates within a column by
Cynthia Amrit
I need to find duplicates within a column. I want it to say what is the
duplicate and the non duplicate to blank in column B.
A B
Dog ...
|
November 11th, 2009 04:56 PM
by Madwitch
|
3 |
185 |
|
|
FAO VBA Code MVP's! by
Buyone
Hello,
I found and borrowed this macro from Dave Peterson. It works, but i need to
add in a couple of things to make my life that one bit easier.
I need to...
|
November 11th, 2009 04:34 PM
by Buyone
|
4 |
206 |
|
|
|
|
1 |
222 |
|
|
tools options view window options by
Joe[_45_]
If I bring up a shared workbook and when I look at the windows options under
tools, options, view, the box is checked and gray - you CAN"T change the box....
|
November 11th, 2009 04:08 PM
by jlclyde
|
1 |
193 |
|
|
|
|
1 |
210 |
|
|
|
November 11th, 2009 03:57 PM
by jlclyde
|
1 |
244 |