what does ^ mean when used in a formula

Is it possible to type a value in a cell that would then be referenced by a
field in a pivot table and then lookup and select that value instead of using
the drop down box and having to search through the entire list to find the
value necessary.  Thanks.

We have a problem with pivot tables which is becoming quite troublesome.  We
have a excel spreadsheet which includes a large datatable and we summarise
the data using a pivot table.
Often, this pivot table will convert itself to a text block - i.e. it looses

I need some major help.
I have a spreadsheet with around 28000 rows. In Columns C and D, there are
two different lists. Each column has text that should match. For example in
Column C it might say "sprockets," and in Column D it would say "Sprockets

I would like to be able to change a field selection in a row area of my pivot
table by typing into another cell outside of the pivot table.  There are so
many selections in the field that it would be much easier for the user to be
able to type what they would like the select in ...

i know the regular way to insert comments, but i've just saw one kind of
comment that show up when u click on the cell which is not editable so the
user can only see it.
How can i do that?

in trignometry what is the formula for TAN INVERSE? What to use this formula
in microsoft exel worksheet. Plz help me out.
Thanks

free to listen live.. +86 13925265554

Sir,
I have filtered some range in a sheet in Excel 2000, with a title. But it
take only 1000 records / rows in its filter range while searching, such as if
I had entered some 1500 different values it will show me the first 1000 value

Is there a way for a Macro to open the most current file in a folder?  I have
a file copied to a specified folder nightly (C:\DLY\PB061807.txt) for
example.  The PB stays the same in every file, and then it adds the date to
the end.  There may be several in the folder(for example ...

I am using Excel 2007 and often cut and paste data in number and scientific
number format.  The problem is that Excel will often decide that I need to
see a large number of numbers after the decimal place and will change the
width of the columns to fit that many numbers.  I am ...

Is there a preference (on Macs) or an option (on PCs) that a user can set to
specify the size of the window Excel opens a workbook in? Some of our
vendors, mysteriously, send us spreadsheets that, when you open them, open in
a teeny tiny window. It's not hard, of course, to drag ...

I would like to have a template based on excel for description of a "property
to sell" in which I could put numbers, calculation etc.

I have 4 forms on one tab. I have check boxs on each form. If a box is
checked on the first sheet I need the same box on the three other sheet to
change to checked as well.
Since they will always be the same this will save on errors in filling it

Hi
I am trying to make a holiday sheet , every employee gets 20 days holidays
per year, but if they have worked for us for more than 15 years then they get
an extra day, and another extra day for more than 20 years service, i have a