First  |  Prev |  Next  |  Last
Pages: 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196
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 In the above link go to the end there you will see more link to other pages 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
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
First  |  Prev |  Next  |  Last
Pages: 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196