CTRL + `
Thu, 28 Aug 2008 12:02:45 +1000
JE McGimpsey mentioned this keyboard shortcut in a post back in June 2008.
It appears to change all cells in a spreadsheet from dates to date serial
numbers and vice versa. But I can't find any mention of the shortcut in
Excel 2003 Help. Can someone tell me where it is in Help or explain what it
is suppos ...
|
cell display 2
Wed, 27 Aug 2008 19:03:01 -0700
Hello Everyone,
I have another question to ask from a previous question that I posted a
while ago, I have included my prev question and it was as follows:
"hi,
-my question is basically for example if u type a value of 50 to lets say
cell A1.
-then u make a simple equation in cell A3 which says the valu ...
|
VBA code for sizing/showing pictures
Wed, 27 Aug 2008 17:51:19 -0700
I'm using the following code to size and display a specific picture based on
my list box in cell A4. It does a "VLOOKUP" from cell A5 and then displays
the picture that is tied to the selection in the list box. This code is
specific to cell A5 only. I need to duplicate this function to cell C4 and
cell C5. B ...
|
vlookup to find match only part of a text value
Wed, 27 Aug 2008 17:44:00 -0700
am trying to match two columns of data were column b has text values that
are very similar but not formatted exactly the same as column a. The slight
formatting differences result null values on the vlookup. One solution for
this challenge is to match the first 15 characters of a cell rather than the
entire ...
|
lower case letter "i" always converts to upper case
Wed, 27 Aug 2008 17:01:00 -0700
When typing in a lower case "i" it shows up as an upper case in my spreadsheet. ...
|
delete conditional formatting via macro
Wed, 27 Aug 2008 15:44:36 -0700 (PDT)
Hi,
Is it possible to remove conditional formatting setting vai a macro.
I use a macro to copy a range (visible rows only) to a new sheet, the
cond.formatting gets messed up because the row numbers change.
The macro recorder doesn't record the cond.format part.
Cheers,
Harold ...
|
Report Format - Pivot Table not working
Wed, 27 Aug 2008 15:42:01 -0700
I have this report of raw data, I would love to put the data into a pivot
table as its the best way to present. Problem is that the source data
precalulates the higher levels of the hiearachy in the raw data so in a pivot
table
Ex: Director, team manager and team employees give combined $1000
---------Tea ...
|
|
|
Picture in a cell
Wed, 27 Aug 2008 15:20:02 -0700
How can I place a picture in a cell in Excel 2007? ...
|
Lookup a value and count the number of associated occurences
Wed, 27 Aug 2008 15:10:12 -0700
I have 2 worksheets. I want to obtain the summary counts in worksheet 1 from
Worksheet 2. What formula should I use to poulate worksheet 1.
Worksheet 1
2008 File counts by Lender and Month
Lender Jan Feb Mar
Aurora 3 2 4
BofA 6 7 8
CCM 8 9 5
Worksheet 2
Jan Aurora 1
Jan Aurora 1
Jan Aurora 1
Feb Au ...
|
Re: Help with cells contents sum
Wed, 27 Aug 2008 15:09:03 -0700
X and Y are not numbers so you can't "sum" them as you can 2DO and 3DO so
you will get the error.
You would have to go back to one of the pther poster's formulas for finding
DO and DI
My formulas dealt only with your examples.
See Roger Govier's posting with SUMPRODUCT
Gord Dibben MS Excel MVP
On ...
|
