I use data validation tool the basic way, LIST setting as validation
criteria and SOURCE range in the same worksheet. I do not use any static or
dynamic named ranges.
The problem is that no dropdown list is displaying anymore. I correctly have

Where can I go to get some excel Rate of Return formulas?
Thanks, jcs

Missing Pivot Data in Pivot Page Field (PF)-Weird!
Dear All,
Does anyone have an idea of why this happens. It's not often but sometimes.
This will be the first time after almost a year now. (had it like less than

B        C        E        G
2 SubtotalRetail   SubtotalCost     SubtotalComsn          SubtotalGrossProfit
3 =Formula(j7:j10)  =Formula(K7:K10) =Formula(l7:l10) =Forml(m7:m10)        
   A           B             C           D            I           J        

Hey All.
I run an football poll and I'm trying to get away from manually putting
checkmarks beside the players who select the correct team and was wondering
if it's possible to have this done automatically.

I have the following code to bring up the Calendar control.  When I
converted the excel workbook from XP version to 2007 version on my home
computer it worked fine, but when I open it on my office computer I get a
message saying "Object required".  When I open the older version ...

I have a sheet with a series of numbers with which I want to make
combinations.
Approximately 100 lines
Sheet named Base

Many of my spread sheets use color to indicate status. Some of these
formulas are quite extensive and quite frankly I forget some of the evolved
logic. Is there a way to test for the color of a cell.
For example, I can write an IF statement as follows :

I have devised a workbook where I enter the credit card details of the
transactions received at my hospital for people who pay by credit card. In
this there is one column where I enter the credit card number. This cell I
have given a general format, text format and a number ...

I'm trying to create a list of alphabetized text items with frequency
count in the adjacent column.
I want to be able to add new entries to the list and then have Excel
compare the new entry to the existing entries and either add the item

let's say I have data on A1 to A5 (1;2;3;4;5)
I also have A10=A1
and: B10=2*A10+3 ; C10=B10*3 ; D10=C10+B10 ;
I then transcript the value of D10 in B1.

,I have peoples' names listed in the cells in column A.  For example, in cell
A1, I have:
Brown, Jane
I would liike the name to read:  Jane Brown (switch the first and the last

I have beem trying to save an excell document to my E floppy disk driveusing
a dvd/Rw disk.  I have an HP computer with windows XP

The ctrl+; shortcut inserts the date as formatted in regional settings
rather than the "day number" date. I want the "day number" date so I can
process it.
Any suggestions?

Hello, I need to fill in all blank cells a large data range. My data is
randomley scattered accross several hundred thousand cells and needs to
remain in place. I need to have a text string as a place holder in all blank
cells before importing into quickbooks.