I have Excel 2007 and my wife has Excel 2003.   I regularly get Excel files
mailed to me from work that have two Worksheets of two pages each for a
total of four pages.  When I open these files on my wife's machine I can see
both Worksheets and all 4 pages.  When I open it with ...

The computer is set to use the long date format and everything is OK until I
make changes to a chart which causes all dates in all open worksheets to be
displayed in the short date format.  When excel is closed down and restarted
the problem is resolved - but doing this is ...

Hi guys here is the issue.
Under column A, which is titled serial number, I have listed the formula
=IF(ISNUMBER(B28)=TRUE,A27+1,""). What this does is that it detects if there
is a date in column B and then inputs a serial number that is one more than

Hi guys I recently decided to put in my students' attendance into a
worksheet. A sample of one of the student's sheets can be seen at
http://i291.photobucket.com/albums/ll304/dioprem/attendance.jpg (at lot
easier to upload a screenshot than to explain ;))

Tried the C.Pearson site.... Couldn't get that formula to work.
=IF(ROW()-ROW(NoBlanksRange)+1>ROWS(BlanksRange)-
COUNTBLANK(BlanksRange),"",INDIRECT(ADDRESS(SMALL(
(IF(BlanksRange<>"",ROW(BlanksRange),ROW()+ROWS(BlanksRange))),

I have tables of calling rates. I have 5 tables as follows:
_tblAccount - It's an account type such as pre paid or post paid
_tblEmployees
_tblProvider - list of all the providers. I have 7 so far.

Certainly there is a simple way to find out if a cell that has text in
it contains a certain word.  For example, cell A1 is populated with
the words "Houston, TX, USA."   In Cell A2 I want a function that can
look into A1 to see if the word "Houston" is contained in there.  If

(Kinda long explanation here to make people understand what I want t
know, just *read the summary if you don't want to read everything her
for topics I need help with*)
All right, so I haven't used Excel in years so there are some things

Can we make a vlookup when lastname may have slightly differnt spelling in
middle characters?

I have a spreadsheet with 4 columns.  I am scanning some bar codes
into the 2nd and the 3rd column.  I want to the active cell to change
to the 3rd cell after I scan the bar code for the second column.  This
is obviously easy to do.  But I want it go to the 2nd column of the

I have a list of names. Is there any way to count the unique names in
a corresponding row, and if a name repeats, list the same number it
had before?
Names      #

Hello, I have a summary sheet which links to many (20ish) password protected
files. Every time I open it or update the links, I have to enter many
(20ish) passwords.
Is there a way I can avoid or automate this process.

I'm using Excel 2003.
Does Excel allow me to change the fill-color of a cell based upon the
contents of that cell?
For example: If the formula of a cell calculates its value to be less then,

I'm currently downloading SP1 for the Microsoft Office Suite 2007.
Does anyone know if this addresses the issues of Excel
2007--slowness--hangups, etc.

Is there a way to make a conditional custom number format?  I have two
formats that ALMOST work for what I need, but not quite.  #.# works for most
numbers, but if there is no decimal in the number it displays an unnecessary
decimal.  ## works for most numbers EXCEPT for ones ...