software

I have a master spreadsheet that contains 100 worksheets, the worksheets

I have created a pivot table to extract iformation from a data base. I have
now added to the data base therfore I need to expand the renge for the table

I've built a workbook to keep up with purchase/sales of Stocks, to keep

In excel I set up a parameter query. In the query parameter properties I
checked quot;Get the value from the following cellquot; and checked the box quot;Refresh

how do i get excel to give me the sum if two criteria are true, but i want it
to return a value of only one of the criteria. For example, column A is the

If CoLumn A, E, I, M, P, U all have Name (with Different names) how do I
combine that so it all fill sout in rows under column A

Hi All

I have an excel file of 19 sheets, each sheet has nine data coloumns from b
to j. I made nine offset() to plot these data. But, its not working. Here

I am trying to create a formula in exel that will return a value from the
final cell in a row. this cell reference will be moving on a weekly basis.

I want to know how to deal with this statistical data