Hi, I am looking for a formula that will allow me to calculate a weighted average price. The data is as follows: Vol Price Price x Vol 27 ...

I have a spreadsheet in which the data changes daily (As far as number of rows in each section) Basically the data I want to sort is in columns A through...

Hello, I generate a large report every day with different information for projects my company is working on. Currently there's about 120 projects in the...

اريد تنزيل microsoft office2007نسخة دائمة �ماذا ا�عل

Excel 2007 Student Edition: How do I combine values from multiple rows about 1 item into 1 row about that item? For example: Header: Year Title ...

I have a group of people that access an excel spreadsheet that containsaccounting data for each ones clients.Each person pulls their data out of the...

I recently reloaded office 07. Now an excel spreadsheet I am working on has (shared) and (compatabilty mode) in the title bar. I can't find any explanation...

I would like to take the highest value minus the lowest value in groups that are divided by a blank row. The group can consist of different number of rows....

Excel 2003 I would like to know if there is a method to show which cells are linked to charts? I have a rather large spreadsheet ( 40 worksheets) this...

I was very happy to find out about the possibilities of the INDEX/MATCH combination...and making links to several source documents. However, as the function...

I have a long lists for of stores that contain texta and a number. I am doing a Vlookup for this column but the formating is wrong. Here are examples of...

I need advice on how to create a macro in excel. I have a spreadsheet that contains all the data. I want to create a macro that will run a pivot table off of...

New to Excel 2007. Baseline data (seperate sheet) with a list of all utility accounts (hydro, gas - two seperate sheets). I want to click on account number...

Hello, Need your help regarding excel formula. I have one excel data. In Column "D" I have dates. I want to write a macro which can put some kind of word...

Greetings, All, I'm doing gross arithmetic functions on various pivot table results. The pivot table is Access-driven, and the target cells move around,...

if in cell A1 date is given, how can i do week entry of the month in cell B1/B2. e.g. A1=2-APR 09 B1=1st Week A2=28- Mar 09 B2=4th...

I have a column of info with text and numbers. Is there a way to make all the text become lowercase? Thanks, Adam

Can anyone tell me if I can chage the size settings in Excel from cms to inches? When formatting the size of a chart or picture for example. Many thanks in...

I have imported my contacts from outlook into excel and having trouble with the phone numbers. for some reason sorting does not go as it should and a vlookup...

Hi, I have two worksheets in the same book. Sheet 1 ID / Course / Description / Amount 01/PH 101 /Basic PR / $200 01/PH 102 /Inter PR / $50 02/GD...