checking input in a cell and return by copying info from a other c What I want to do is the following. I have a worksheet in which I have created the following; Name-Column , select-Column. I now want to created a formula in a new sheet which check if the are "x" in the select column and copy the names of the name-columns to cells in that new sheet. (which is in the same workb... 19 Feb 2010 12:08 How to round & sum only the displayed (rounded) numbers I have rounded some numbers to the thousands digits. I need help finding a formula that rounds the displayed (rounded thousands) digits. Everything I try only calculates it based on the unrounded numbers and as such many sum numbers are off by 1 (or really 1,000). Any help would be awesome! thanks ... 19 Feb 2010 12:08 Macro for summarizing multiple sheets Hello all I have a workbook with multiple sheets. Each sheet is identically laid out (the only difference is the sheet name - cart1, cart2, etc). Each sheet represent the contents of a cart and the expiration date of applicable items. I would like to create a macro or function that will search each sheet in... 19 Feb 2010 15:32 Calculating Average Salaries with Three Other Variables - Pivot Ta Hi, Take a look at Debra web, she has an excellent explanation and great video about Pivot tables http://www.contextures.com/Pubn01.html In the above link go to the end there you will see more link to other pages http://www.contextures.com/Pubn03.html if this helps please click yes thanks "RobFJ" wrot... 19 Feb 2010 08:45 percentage of green cells in list Hi i have a list of dates coloured either red or green in column A and i want to express the green cells as a percentage of the total list ie 12/02/10 14/02/10 20/0210 etc this list is constantly bei... 23 Feb 2010 04:40 unexpected file lock by user Hi I am using EXCEL 2007 and one of my file is shared work sheet. when i try to open the file i am getting a error "unexpected file lock by "user". Do any one has a fix for this please let me know. I have not faced this problem in excel2003. Regards Chethan ... 19 Feb 2010 08:45 Sharing Macros I have a macro to be released to a number of positions held not by the same person. This is to be run with a New Worksheet with data created from SAP, so therefore cannot be a Macro assigned to a Worksheet? Personal is out and "Assigned to a ToolBar" I do not think is the answer. Is there something I am m... 19 Feb 2010 08:45 Calc sometimes off by a penny Hey everyone. Excel 2003. I will frequently add up a range of cells (all dollar amounts that were typed in manually). When I add those numbers up with the calculator, let's say they equal \$1865.60. Then when I take them and put the same exact numbers into a Column and do an autosum, the number comes up \$186... 21 Feb 2010 02:46 combine/merge 2 worksheet (tabs) into 1 work sheet Hi, after reading countless forum discussions, i am still very confused for something that should be fairly simple! i have a workbook file with several work sheets (tab) that have data comparing two year revenue income. And now we need to compare them side by side vertically. I tried consolidation but it do... 19 Feb 2010 04:23 formular Hi Help needed A1 3.5 B1 4.5 resultin C1 if less than 3.5 i need "low" if between 3.6 and 4.5 i need "medium" if higher than 4.6 i need "high" A1 3.5 B1 4.5 result in C1 and if less than 2 i need "very low" if between 2.01 and 3.5 "low" if between 3.6 and 4.5 "medium" if bet... 18 Feb 2010 21:51