Is there a function that will allow me to find a median age? The data I have is in the following format: Age Range Population 0-14 ...

I have a PivotTable in Excel 2003 set up with salesperson name and region fields in the row area and thier sales totals summed in the data area. Things are...

I would like to automatically compute a 'net wage to gross wage' on a calculation based on some algebra. Basically the calculation is a function that...

I have two columns of data, production in tons and emissions in lbs for each calendar day, no missing data, but can have values=0 (no production). What I what...

I have set up a spreadsheet model for my pupils based on the F1 motor racing season. As well as the other attributes I wish to add each driver's helmet as...

Help. I can't find out how to use or locate how to tranfer data using isers. I had it befor I updated to 2007...Can anyone help?

I tried using the Data Validation in order to have the 'user' select from a range of values. The list is in a hidden sheet within the worksheet. However,...

I am working in a model where lines are summing improperly. I have tried deleting and re doing the formulas, but I then get 0 or blank in the cell. Can...

How do I do this? In my budget spreadsheet, need to auto-populate an entry in Column E based on what is typed in Column A. Have account #'s 200-294. If "213"...

I have a chart that shows dates on the x-axis such as "Jan-09". When I copy the chart into the presentation deck, the format changes to the excel serial...

I was doing something (I don't recall what) and suddenly all of the excel (2007) icons changed to become gray upward pointing arrows. How can I change them...

I'm trying to display a blank space (or nothing) when there is no difference between two cells, as in: =IF(C6-C15=0,"",C6-C15) However, when the answer is 0...

Is it possible to store custom commandbar buttons somewhere so it is possible to use those buttons on different computers? There are a lot of blank FaceID...

Hi, is there a way I could display how many sheets I have in a workbook Thanks

Hi All We sell a part that is based on size and has a part number named "CH##R##" where the number after "CH" is the number of characters and the number...

Need spreadsheet not unlike Quattro-Pro. * Must be able to graph 2 variables (eg:volume, temperature VS time) and show each with its own grids in its own...

Can I have a message box with fonts of one word being bold. For instance: msgbox("You have done it!") showing the word "You" in bold?

I am trying to lookup a value without using the vlookup or hlookup functions, as I am unable to. My data range is in A1:D2. I need to find the corresponding...

Hello, I have a spreadsheet which I've added a macro button onto to quickly password protect all worksheets, I send this spreadsheet out to others and have...