How do I use Excel to convert feet to kilometers? I'm trying to use Excel 2002 to convert feet to kilometers. When I try to use the CONVERT worksheet function, "#NAME?" is returned. It does the same thing no matter what units of measure I try to convert. I copied and pasted the syntax directly from the Office Help section. Any ideas? ... 22 Feb 2010 17:35 changing a calculation in a pivot table I have a pivot table from a db that shows 10 rows of dates and data. each week i delete the oldest row and add it adds the new one. What i need to do is calculate the % change from the oldest to the newest each week. right now i do it each time i run the db. what i want is to have a cell calculate it for me. when i... 22 Feb 2010 16:26 Extracting the latest info from 1st sheet and placing into a2nd s tech1NJ wrote: I will like to extract the latest information from a given column in a sheet (sheet1) and place it in another sheet (sheet 2) in B1. Here is my example of data located in Sheet 1. I'm looking to extract specifically the latest build number and place it in sheet 2, B1. Date Time ... 22 Feb 2010 16:26 Excel "IF" functions Hello, I am trying to create an "IF" formula to indicate an "X" in a cell if the following criteria is met: 10% of entity's Total Assets(C11) and .05% total variance (between two periods) and any variances over \$500K Thanks! ... 22 Feb 2010 19:50 Locating values in a range and bringing up the corresponding p Duke, I just noticed that the formula works well with the Bronze and the Silver plans, however when I input Gold as a plan it returns the values of the Bronze plan. Please advise. Regards, Zuo "Zuo" wrote: Duke, Thank you for your insight. It works! Regarding the over 1000 Lbs items t... 22 Feb 2010 15:19 How do I print my spreadsheet to show the formulas of a cell? I have a speadsheet with many cells all containing a separate formula. How do I print out the formula of each cell and not the result? ... 22 Feb 2010 16:26 Rounding I have 2 values which I know equal however when I use the round function below it states it does not equal =IF(ROUND(BH3,3)<>SUMPRODUCT(--('Jan Data'!\$F\$3:\$F\$12230)=\$B3)*('Jan Data'!\$N\$3:\$N\$12230=FALSE)*('Jan Data'!\$I\$3:\$I\$12230),"not balanced","") What am I doing wrong thanks ... 22 Feb 2010 14:11 Office Project vs. Office Web Component Help. I have an intranet site using Sharepoint and Business Portal functions. The users are all off-site using their home computers to access. There are lists rendered as queries within the site that should be exportable to excel. Most users can do this using Office Web Component - and some never have to downlo... 22 Feb 2010 11:52 Extracting the latest info from 1st sheet and placing into a 2nd s I will like to extract the latest information from a given column in a sheet (sheet1) and place it in another sheet (sheet 2) in B1. Here is my example of data located in Sheet 1. I'm looking to extract specifically the latest build number and place it in sheet 2, B1. Date Time Error Message... 22 Feb 2010 10:45 Counting Values in a list Hi I have a list of 7766 text strings in an excel sheet. I would like to count the frequency of each string and create a new table. For example, had.... Cat Dog Hamster Dog Horse Cat Hamster Hamster ....in my list, I'd like to produce a table Cat 2 Dog 2 Hamster 3 Horse ... 22 Feb 2010 09:38