Ok, here's a complex one. If a specific value is entered in column B1, "8536"
for example, I'd like a message such as "Pieces Needed" to pop-up in A1. Any
thing you can do to help would make life so easy. Thanks

I made a formula in conditional formatting to create colours A=Yellow,
B=Yellow, P-Blue and C-Gray, I made the following formula which is devided
into three column in which:-
=if($C$236="c",column($C$236),if($T$236="c",column($O$236),if($C$236="c",column($O$236),

Can someone tell me how to use the if and round functions together.  My
if functions is =IF($A5<1,K5-(K5*$A5),K5-$A5) and I need my answers to
be round to the nearest hundred.

I have a column (OWNER ID, Col. B) with about 2500 rows of numbers, that are
supposed to be in succesion, incremented by 1, starting at 1. When I
highlighted the entire range, the last number in the series was 2546.  But
the "COUNT" in the lower right corner of the screen shows ...

I have a SUMIF statement that doesn't appear to be working -- not throwing an
error, but not returning the correct value:
=SUMIF(DataSheet!$C:$C,"61505 OR 61515 OR 61517",DataSheet!$E:$E)
What I'm trying to say is that if the value in column C is 61505 or 61515 or

I'd like to know how I can sum, say 100 cells among which there is on
cell with #N/A, without getting #N/A as a result.
Thamks in advance for your support
Paolo

I have created a VLookUp which works fine, however, because I want the data
returned to be exact and not return the closest figure, I have entered
'false' at the end of the formula.  It works as expected, however, when it
cannot find an exact match it obviously returns 'N/A'.

I have cells linked in a destination workbook to a source workbook that is in
a separate folder.  If I open the destination, the cells display "#REF" until
I open the source.  How do I update the values without having to open the
source workbook?  If it is not possible to do that ...

Good Morning,
I have a file that has a column of dates.  I would like to use advanced
filter to filter anything with a date that is <today()-1 but I can't seem to
make the fomula work.  I  can make it filter on =today()-1 but when I use the

I have a workbook with 50 sheets. I would like to protect all of these sheets
with the same password at the same time. i.e. i do not want to protect the
workbook but every single sheet and I don't want to go through every sheet
protecting it.

I have a spreadsheet with a monte carlo simulation in it, that the creator,
who is now on holiday, says i need to install user defined add in
triangle.xla, to run.... anyone know what this means?

How does one convert a julian date back to regular date?

The concern is did swomething get turned off in excel or is this the work of
a virus?

Set Rng = lObjInterimWrkSht.Range("$L2:$O1000")
lStrResult = Application.VLookup("1001001", Rng, 4, False)
If Not VBA.IsError(lStrResult) Then
lDblExpensesThisMonthAmt

I ahve a worksheet with approximately 44,000 lines. When I attempt to use a
pivot table Ihet the following error message:
A field in your source data has more unique items than can be used in a
Pivot Table.