I have a huge worksheet, consisting of codes in Column A, a product name in
Column B and a cost price of the item in Column C.  Each product some times
appears more than once as they may have more than one cost price.
How do I filter the list so it will only show me one record of ...

I created a drop-down menu going to Data and then Validation.  When I click
on the arrow to drop down the menu, the options appear correctly but in font
so small that I cannot read them.  After I click on an option, it appears
correctly in the box.  How can I increase this font ...

I think I'm losing my mind....
.......C...................D...........................E.........
1......1............10/25/2005...........10/26/2005
2......2............10/27/2005...........10/29/2005

I have a table of quarterly shipments by vendor/product and want to convert
this to a pivot table. Right now I have 12 quaters of data, with includes 8
quaters of actual data and 4 of estimates. If I get how pivot tables work, I
would need to add 12 rows for each vendor-product ...

I want to list down all possible combinations of sizes from a size list. We
produce Paper Rolls in a specified size ie; 161 inch. We receive cusomer
orders in small sizes. So I want to know which sizes could be combined to
slice the Big roll to avoid maximum loss. For eg I have ...

On sheet 1 of my spreadsheet I have a cell whose value is the result of a
formula on sheet 2.
I don't want people to enter text or numbers here but I want to direct them
to sheet 2.

Thought I was losing my mind when I set up some conditional formatting
based on datedif # of months.  The number of months between the start
date and the end of January and the end of February (using eomonth
function) were the same.  To double check - I input the following

I need to separate the number from the right of a text string into its
own cell.
For example in the data:
"Salaries - Aides / Assistants                   3708"

This is not the simple question of "I don't know how to hide cells".  Is
there any way that I can hide a cell in such a way that even if copied by
another user over to a new sheet, they won't see a formula?
In other words, I believe that even if rows are hidden, cells are locked,

I've lost my stroll bar on the top and bottom of my spreadsheet how do I get
them back?

I'm hoping to populate a table showing the top 5 values in a list of
20,000+ currency values.
Without having to sort, is there any way of looking up the MAX -1,
MAX-2, etc.??

Can someone assist me with merging the data in four fields into one string of
information?

I am currently using an Index/Match formula to match and transfer data
between two tables
{=INDEX(UPRNmatch.xls!Gaz,MATCH(O10047,UPRNmatch.xls!Match,0),1)}.
This has worked fine, until I added new data to the lookup table which I

I could only find taking one time element to another time element.  Any help
you can give me would be most appreciated.

I have a sheet detailing orders. One of the column is having expir
date of L/C (well LC means Letter of credit its a payment instrument
in case Lc expires before the shipment of order the L/c has either t
be extended or the order has to be cancelled.