I've got a spreadsheet linked to Access which pulls in a year's worth of actual sales numbers (of products). I need to figure the average sales over either...

I created a SQL query using MS Query in Excel 2003 and now I need to open it in Excel 2007. I can open the spreadsheet but am unable to open the query to...

I have opened up a worksheet that a coworker created last year and cannot figure out the purpose of the isnumber function in this...

How can I refresh pivottables in a shared workbook? I have "refresh on open" marked which doesn't seem to refresh unless I remove sharing. Also, is there a...

I have a column with about 7000 rows. Many of these rows are subtotals, summing 2-10 rows each. I'd like to delete all the subtotal rows all at once. I...

I have 500 names and addresses in an excel spreadsheet that I need to merge with a word doc so that it creates 500 of the same document to the individual...

Hi all, cost aggregate dep c/fwd charge for year agg dep b/fwd value 2007 1000 100 50 ...

I am trying to sort my colum by the last two digits of the number in each...

If this is a duplicate question, I apologize. Not sure my first made it. Some simple text functions work in some of my worksheets but not in others. Could...

I would like to change the format to show hours and minutes where the hours are over 24. By going to the format list I see one that almost fits the bill but...

Hi, many thanks for the peice of code as below: net use d:/delete/y net use d:"\bft-123456w\d$"/PERSISTENT:yes pause wherby d:/ is the Drive letter for the...

Help

This is probably a fairly basic question, but I just cannot seem to figure it out. I'm working with a previous excel file that I need to edit. In my edits...

I am trying to open two excel files simultaneously in different windows so I can view them side by side. I open one file, but when I open the second it...

I have a work book that has about 20 colums. 3 of the colums are "stage" "Company" and "value" - they are not next to each other. each row has a value in...

I am trying to open two excel files at the same time so I can view them side-by-side. I open one, but when I open the second it simply replaces the one that...

Hi, real simple one here for someone who knows excel. I'm creating a simple spreadsheet for an assignment and need to use the IF function. Basically I need...

Hi to all, Wonder if you can help me. I have the following formula which works ok, is it possible to have a similar formula but with extended choice of...

hi - i work with a lot of sales unit data, and need to total weekly sales data of duplicates under one row name. For example, i would like to turn the raw...

G'day! My first sheet is a summary sheet. All the subsequent sheets are identically designed data entry sheets, BUT the sheet names are random (not...