General

How do I create unique pivot tables from the same data
I have a table for inventory. It has 31 rows as one per day. It has a column for each product, about twenty or so in all. I can create the PT without a problem. But if I create a second PT based on the same table, even if I place it on it's own worksheet, all the variables change on both pivot tables. Examp... 9 Apr 2010 17:53

HOW CAN I SORT SUBTOTALS FROM HIGHEST TO LOWEST
-- JG ... 9 Apr 2010 11:10

HELP! Lookup
Simply, i have a worksheet that has one row of ss#'s and next column datat that refers to that ss#. In a larger worksheet, I have the column ss#, and i need the data from the first worksheet to be in this one.... for some reason.. i cant get vlookup to work.. Its over 8K rows. -- Excel isnt just a program it... 9 Apr 2010 11:10

enter a formula
i am trying to enter a formula in a cell, but it is coming up as a value. how do i change it from value to formula. -- Louise ... 9 Apr 2010 12:18

"seeing" hyperlinks in a worksheet
I have to edit a worksheet to add numerous lines. This is an inventory sheet with many hyperlinks between finished products and the raw materials used to make them. I would like to be able to "see" the hyperlinks that are currently in place in order to be able to add the lines and then correctly reset the hyp... 12 Apr 2010 00:31

counting numbers
Hi All, I have a Query like This. Pls Give your Suggestions. DATA: anil 0 sunil 1 anil 1 sunil 0 anil 1 sunil 0 Ans: Anil 2 Sunil 1 I need to count the numbers against name which number is more that 0. Regards, Anil. ... 13 Apr 2010 08:22

What does the number 1.26E-23 mean? Is it a large or small num
Or, maybe, 0.0000000000000000000000126 Micky "RonaldoOneNil" wrote: Its a huge number. The E stands for exponetial and the 23 means 23 decimal places to the right. 126,000,000,000,000,000,000,000 "Tommy37" wrote: What does the number 1.26E-23 mean? Is it a large or small number ... 9 Apr 2010 07:48

What does the number 1.26E-23 mean? Is it a large or small number
What does the number 1.26E-23 mean? Is it a large or small number ... 9 Apr 2010 12:18

Data validation list, combobox
Hi, I had asked for a help against limitations of data validation list. Thanks to Master Mike H., he had suggested http://www.contextures.com/xlDataVal14.html site. Yes, this solution does exactly what need. But there is one problem. I should not use aroows when I want to simply move the cursor. It says "Pres... 9 Apr 2010 06:43

external data table sort order
Hi, I am querying a SQL database view to return a table of data in Excel. The view is setup to sort the data they way I need it so my query within excel is literally "select * from MyView". However in Excel 2007 I now get this fancy data table with filter headers that seem to override my views sort order. I... 9 Apr 2010 06:43