Hey y'all, if didn't know this, I just discovered:
You can embed internal carriage returns (i.e. Enter's) in a formula.
Insert a <CR> into a cell with Alt-Enter, while in edit mode.
I have many calls to home-grown functions (UDFs) which I pass up to

I use pivot tables a lot and the vast majoirty of the time I use it to sum
data. Excel defaults the Value Field Setting to Count so I have to change it
every time. Is there any way I can change the default to Sum?
Thanks

Excel 2002 seems to retain tons of hidden stuff you thought you
deleted from your workbook or VBA project.
Two symptoms:
1. I had a 5-megabyte workbook. I:

On Friday, I asked a question and was given INDIRECT and/or INDIRECT.EXT as
possible solutions.
I finally managed to make INDIRECT work but I cannot make INDIRECT.EXT work.
My problem:  120 files with identical architecture - two worksheets each. I

I created a local cube in Excel 2003. Unfortunately I had to move to
database afterwards (Access mdb file). Now, when I click refresh in the
Excel pivottable based on the cube it says, that the path is incorrect and
allows to point a new location. How can I change the path in the ...

I am not good at this at all, novice at best.  This is my current formula,
are you able to tell me how to alter my formula to yield a - or 0?  I
appreciate your help
=VLOOKUP(F12:F45,Sheet3!G4:H51,2,FALSE)

I have a worksheet with 3 rows of columns headings.
The first row is standard columns headings.
The second row is a merged cell text line.
The third row is a blank row - which allows me to selct A4 and do a

I have list of names (column A) and every time I put a code (example:
2), instantly the function will create a list in another column.
For example
Data:

I am converting EST to CST and rounding down to nearest half hour.
The rounding portion, I got....
=FLOOR(F2,1/48)
Having trouble subtracting one hour from the result.

So, I want to be able to use the Icon Sets in conditional formatting
with text values. I bet there are a bunch of other people out there
that would like to have the text "green", "yellow" or "red" converted
to the appropriate stoplight icon, but I cannot figure out how to make

Looking for help...... In column A1:A16, I have names. In B1:B16 I will
assign random numbers to those names from 1-16. In another part of the sheet
I have 16 columns lets say D:S, (D) being column 1 and (S) being column 16.
when I assign a number in column B, I want the name to ...

I have ~2,000 worksheets with data all formatted identically.
Here's the problem:
Users manually divide continuous data (such as sentences or
paragraphs) across multiple rows in one column. These data can be

I have this formula i B1
=A1&";"&A2&";"&A3
Now I want to copy it down in the B-column, but instead of being
change to

I have created a workbook to track all my bank deposits, automatic deposits,
and credit card receipts.
Each worksheet has a cell that contains the total receipts from the deposit
entry date.

I'm not good on excel formulas. even though i knew this i tried to
come with some formula for my excel workbook but it returns #REF.
There is a big mistake but i can't identify it.
=INDIRECT("'sheet1'!D2"),IF(INDIRECT("'sheet1'!D2"="others"),'sheet1'!