Not sure if this is the right forum, but -
Have a pivot table in which I've created a calculated item.  The data set
contains several different data groups, and I use an attribute field as a
page field to select the group of interest.  So far, so good.

I would like to be able to type the first few letters in a cell that uses a
long drop down list and quickly go to the full name in the list without
having to start at the top of the list and scrolling down every time.

I have created a workbook with several sheets inside.
Each sheet has specific dates, ready for data to be inputted.
As data is inputted then there are graphs along the top.
The problem is when I set up the sheet I set the first one up and then

Is it possible?
I have a folder, which contains files named "1", "2" & "3"
and then I have cells including names of those files, ie "1", "2" &
"3".

I have the following formula which works well:
SUMPRODUCT((Main!$G$4:$G$2885 = "I")*(Main!T4:T2885))
but i want to amend it slightly to check if column B equals GL as well -
think that is: (Main!$B$4:$B$2885 = "GL")

I am not sure how to get my words to go vertically on top on my spreadsheet
in excel.

I'm doing the net promotor score. How do I get the total number of
cells with 9 and 10?
Is there an example of calculating net promotor scores?
Thanks,

Hi, Basically I have an Excel data table and I have a Product name
drop down list. I want to create a formula or macro so when a Product
is selected, it would output the list of companies and their spend
with the product.

On a weekly basis the company at which I am on assignment downloads data
from a huge database which they then cut and paste into various Excel
reports. I want to replace this cut and paste process using external links
from the reports to the downloaded data files (which are ...

I need to flag duplicate names in a spread sheet sorted by Surname,
Given Name (separate columns).
In other words...
IF (the surname and the given name in row(n) match the surname and given

A1 I have 01/01/08   (1st Jan)
A2 I have 14/01/08   (14th jan)
How do I get A3 to show 14 days, ie I want to subtract one date from another
but show the answer in days.

I'm trying to create a generalised expense claim form for a group of
people. Each row refers to a particular expense and the user of the form
(the claimant) adds rows as needed, so the actual number of rows is
unknown at the time of creating the form.

I'm in search of a WORKSHEET function that returns a range. I realize
that this can easily be done in VB but that's not an option at this
time.
So, for all the functions that have as an argument "lookup_array,"

How to find repeated data and then merge and centre.
My data is from A to M.Range from A1 to M4500
Any Function Or Macro.
Thanks

I have a column filled with text. there are about 100 cells in this column.
Those cells each have the name of a single corporation within them. many of
those corporation names are repeated throughout the column, but not all of
them.