Do they work in the same manner. I need something that will help me with putting inventory on and able to transfer information to a website. Will Office work...

CELL AE198 displays 15% of cell AE193. My formula in cell AE198 is: =SUM(AE193*0.15) Whenever the value in cell AE193 is negative, i.e. less than 0.00,...

I'd like to have two occurences of the same pivot data field in one table. I have a date field, and I'd like a monthly grouped version of it to appear in the...

Here's my situation: I have several live data streams coming into my excel spreadsheet over DDE links, the data is being continually updated in the...

Q1. How identify data of two coulams Q2. Every cell count and show result like I need like Coulam A Coulam B 500 1 500 2 500 ...

In Excel: 6399M208 $100,000. 6399M210 $ 25,000. 6399M208 $ 75,000. How can I Sum dollars with they are "99" and "08"...

I am working with the 2006 calendar in the Microsoft Office Online calendar templates. The template that is titled "2006 calendar on multiple...

I have 2 lists & I would like to be to identify data that is in both lists so that I can delete non relevant data & then combine the data from the 2 lists into...

I am ranking set of numbers (# of days worked) in a 10 cell column but the numbers of persons I rank differs from day to day. If I enter "0"(zero) on one of...

Hi, I have an order sheet where along the top I have the items and down the side I have the clients. Currently I enter quantities below the items at the...

Is there a way to save a view (not just settings), but specific filtering choices in a pivot table, i.e. If you want to create different groups specifically...

Hi, I have a worksheet with graphs and tables on it which are all based on a validation list (the drop down menu variety) with about a dozen...

I need to learn more about how to use formulas in excel 2003, where can i buy a book on this subject?

I have the following database table in Excel: A B 1 1 Sep John 2 1 Sep Fred 3 1 Sep John 4 2 Sep John 5 3 Sep Fred 6 3 Sep John

I need to know how to repaetb the same information form the top and bottom of a table on every page. It is not a pivot table. Thanks,

if # of years employed is in C5, salary is in D5, percent to contribute is in D2...I need a formula that determines...IF number of years employed is greater...

Hi, I have a larger spreadsheet and am getting the "too many different cell formats used" error. Is there a utility or method to use to go about first off 1. ...

I've used arrays only once before and need some help please! I want to create a formula that does the following: if A1 is between 0 and 0.5 then "T1," if A1...

Hi, I have developed a check list survey using Excel, however, my problem is that I want to lock certain cells that contains questions such that other users...

I have two columns next two each other in columns E and F: Refferal Date Due date The referral date is entered in the E column and the formula in the F...