dears,
I have a excelsheet with name excelsheet 3 with 5000 rows.
It has more or less same information i.e. 2 or 3 rows with empid 1  will be
present though one hightligted in yellow and another highlighted in green

First, I apologize for what are probably newbie questions.  I'm trying
to get up to speed quickly on Analysis Service, Pivot Tables and Excel
and have about a week of experience thus far...
What I'd like to do is use the values specified in the Pivot Table

Hoping someone might be able to help.
I currently use the formula
=IF(SUMPRODUCT(($A$2:$A2=A2)*($C$2:$C2=C2))>1,0,1) from the Contextures
website to count unique records in data sets, where a record is

Using conditional formatting, I need to know if this is possible:  If
the value of cell A1 is is between the value of B1 and 2500 then I
want to set the font color and background color of cell A1 to some
other color than the default.

I keep getting error 91 messages (Object variable or with block
variable not set) with the below code. It happens when FoundRange comes
back as Nothing in the loop; but I'm not sure why it should come back
as Nothing. Surely it should just go back to firstFind, then the loop

I have data from a access DB that i am exporting into a table in excel.
This table keeps track of samples and what testing has been done to
them in a lab.  When the data is refreshed the formatting for my table
[e.g. bolds, fonts, center, etc] gets wiped out, except for the first

I would kike to calculate shipping costs before I receive the invoice from
the supplier. The costs are based on destination and weight of the shipment.
For example, I may have one shipment to Austria weighing 2.5 kilos, and
another weighing 25 kilos. The rates are calculated in ...

Can anyone tell me please why this formula is returning a 4 figure % in my
destination cell Q13 even though I have cleared the cell to "No Decimal
Places":
=IF(OR(V13="",

I've developed a simple program using Microsoft Excel and Visual Basic
Editor. In the worksheet, I have specified 10 cells according to their
own formula. All the cells contain #N/A sign as to show that the cells
contain their own formula ( I guess!)

I have seen MSExcel printouts that have dotted or solid lines of different
colors connecting different cells in a sheet. Is that something that can be
done in MSExcel or would they have  been added outside of MSExcel? If it can
be done in MSExcel, how?

I got a few text files and all of the text file is more than 65535. I need to
know how to create a Pivot table since all of the text file is inter-related
to each other.

I would kike to calculate shipping costs before I receive the invoice from
the supplier. The costs are based on destination and weight of the shipment.
For example, I may have one shipment to Austria weighing 2.5 kilos, and
another weighing 25 kilos. The rates are calculated in ...

I have a combobox where the user selects a city.  The cities come from
a spreadsheet where all the cities are listed in one column, and all of
their zip codes are in the column next to it.  How can I allow the user
to pick a city, while putting that city's zip code into the ...

Does anyone know to add a calendar drop down for all cells in a
particular column?

I know I can add a Custom format but can I add to the list of Special
formats? If so how?
Thanks