In any row, columns P and T may hold data.
In column G I am trying to put a 'tick' if there is data in P and two ticks
if there's data in both P and T.
By formatting G as Wingdings2, a P (capital letter) will appear as a tick.

I use the EDATE function a lot. My setting are set to 'Automatic
Calculation' and Analysis toll pack is also added in. However, when i open
files with the EDATE function used, the relevant cell returns the #NA result.
Any ideas why this might happen and how I can get a permanenet ...

I am trying to make a booking spreadsheet with each tab being a month with
all the days and then another tab being a 2008 summary sheet. I want when i
fill in dates on one sheet (say colour them red to show it is booked on those
days) to automatically fill in the same colour in ...

I set up this if function in a cell and it reads in a worksheet the different
cost codes I input, in all the "12" cells and matched them into another
worksheet were it brings the values that are in the "41" cells....but I can't
figure out how to add the results if in the "12" ...

I'm timing myself running laps. I want to enter in my lap times in hours,
minutes and seconds. Example:
24 minutes 28 seconds, put in as either 00:24:28 or 24:28
I then want to average out my lap times in the same format. Can anyone help

If I typed a sentence as lower case, is there a way to change the sentence to
upper case without having to retype it?  I've tried the UPPER function but
I'm either not doing it the right way or it just capitilizes anything new
that is typed but doesn't change what already exists ...

Iam using Excel 2003.   I have 2 col of a couple thousand rows and need to
determine where a gap in numbers exist between the rows  Example:
    a    b
1   1    5

I am using Excel 2003.
I have two columns in which I enter the weight of individual rolls of
plastic...first down column A, then down column B. I'd like to have one cell,
say in column C, that reflects the last entry I made, no matter where it is

I know it looks kind of bad but it is an IF function (7 of them) that reads
the value of a column in a worksheet that has 7 columns and puts it in a
specific cell in another work sheet, not a big deal, but it has worked for
me, but if two columns have the same cost code it will ...

Here's what I got..
I have 15 packing slips. Each has anywhere from 1 to 14 items and the
quantity of that item shipped. The 14 items are the same items for all
orders, except not everyone got the same items and qtys.  So.. I took each

The following coding is working, when the specific file is opened, there is
no need for the drive and directory for closing the file.
Workbooks.Open Filename:="E:\dir\File1.xls", UpdateLinks:=3
Workbooks("File1.xls").Close savechanges:=True

I have a group of 5 colums in each month every colum has a amount in £ and I
have 15 months no I also have a colum with the total of all the months
together "M3", but now I have created check boxes for each month. What I want
to do if possable is when the month is checked i want ...

I'm sure the answer is in here somewhere but I've been reading posts that I
just find confusing and I feel like there must be a simple answer that I'm
missing.
I have a workbook with multiple worksheets and I have created a list of the

I have a workbook with 20 pages.  On one page I am trying to reference
cells from other pages.  Example:  I want cell B2 on the Shipping page
to emulate cell C7 on the PO-1 page.  I type the following command in
Shipping B2:  ='PO-1'C7     however, when I hit enter, the formula

I have 10 text statements in A1:A10. Is it possible to return in A15 1
radom selection from this range, only proviso is that if Z1=0, <blank>
i.e. don't show anything in A15
Is this possible?