Can anyone help me in simplifying the following formula:
=IF(AND('Shift Entry'!$I6="Y",(AND((OR('Shift Entry'!$E6<=1,'Shift
Entry'!$E6<2)))),('Shift Entry'!$F6>1)),1,IF(AND('Shift
Entry'!$V6="Y",(AND((OR('Shift Entry'!$R6<=1,'Shift

I am sending this to several Excel newsgroups, because I am not sure
which one if the most appropriate.  I apologize in advance for the
multiple postings.  I have MS Excel 2000 (version 9.0.3821 SR-1).  How
can I format only a selected character or number within each cell in a

Hello there and thanks in advance for people that are gonna help!
At the beginning of my module, I define the following public variables
as I will need to use them in different calculations
______________________________________________________________

I have built a matrix and would like certain cells to display their
cell name.  ie, cell C5  would simply have C5 displayed, but if I
insert a row above it should shift to C6, etc.
I've searched around but can seem to find a function or formula to do

Using Excel '97.
How do I create a set of Global Excel macros? In MS word I simply put a .dot
file in the microsoft office/office/STARTUP folder, and the macros are
automatically available. How is that done for Excel? I''ve tried to put both

I need help with creating a formula.  I want to count the total number
of individuals who meet a certain criteria in one column and a certain
criteria in another column.  For example: I want to find out the total
number of people who live in Germany and went on a specific trip.  For

I'm not exactly a novice with Excel, but there are quite a lot of
functions I haven't yet needed to use in the various positions I've
held. What I'm trying to do now is very, very different from anything
I've done before, so I hope this is the proper forum.

does anybody know if it's possible two put 2 autofilters in one map?
at this moment i have them seperated in two maps, but i have to switch the
whole time.

For some reason or other,in a few certain cells,mainly the ones I was trying
to use,the numbers kept centering.I clicked the center icon and it would go
off untill I got back to those certain cells.Then back on again.After 4 tries
I Quit.

When i format cells to show the € symbol in the currency format it appears as
a| instead, can anyone explain why this is happening, it happened even when i
opened the document on another pc.

I am trying to eliminate the spaces between digits in Australian
Business Numbers which have the format "NN NNN NNN NNN" to produce an
eleven digit number with no spaces. I have written a function to do
this that appears to work. I now want to call this function from a

In debugging a program, I isolated the problem to the following issue.
I manually created the following situation in column A, rows 1 to 6, by
copying and pasting actual data in order to accurately re-create the
problem:

I have set up a new spreadsheet with pupil's achievement levels in different
subjects.  Each subject data is stored on a separate sheet.  Each pupil has a
unique ID - which is on each sheet.  Is there any way I can set up excel to
combine the results of one pupil acheivements in all ...

I have a field called date entered and lots of formulas.  My problem i
that
when I applied the filter non of my formulas change.  I am trying t
keep a

i need to sort out duplicate names and dates from spreadsheets. i am working
with names and dates daily and sometimes there are names that were not on the
log i received one day but show up at a later date.is there a way to do
this???