First  |  Prev |  Next  |  Last
Pages: 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199
SUMIF based on cell shading
Is it possible to write a SUMIF formula based on cell shading? If so, how? I want to add up cells based on the shading of the cell. Thanks. ... 17 Feb 2010 17:57
New free mail add-in for Excel/Outlook 2007-2010
Posted to more then one newsgroup FYI Today I upload a new version of my Excel Mail add-in for Outlook. If you want to test it you can find it here Let me know if you have problems -- Regards Ron de Bruin ... 17 Feb 2010 15:39
sorting multiple columns
I have multiple addresses on a work sheet. I need to have all the same zip code # together. How do I sort them by zip code so right name and address ends up with right zip code ... 17 Feb 2010 16:48
Countif across multiple sheets - sheet NAME issue?
Hi there, I am using the following formula (see below), but wondering if the sheetnames I enter have to be in the EXACT order that there are in the spreadsheet? =SUMPRODUCT(COUNTIF(INDIRECT("'"&BA2:BA151&"'!e50"),"x")) where BA2:BA151 is a range housing the relevant sheetnames in separate cells ... AND e50 ... 18 Feb 2010 07:14
highlighting different line in a cell
How do I highlight different lines within the same cell two different colors? ... 17 Feb 2010 15:39
Does anyone know if you can use a wildcard with the cubemember function, and if so, how? I am trying to pick up all product IDs that start with KRLMJ129* (ie, KRLMJ129arj, KRLMJ129lik, KRLMJ129pwr, etc.). Is this possible? I have tried adding the * at the end of the ID, but it doesn't work. Using Excel 2... 17 Feb 2010 14:31
why do print range erase in Excel when import data from access
I have a workbook set up in Excel 2007 that serves as a template for data dumps from Access 2007. In the Excel template, I have set all the print titles and print ranges for the various worksheets that need to be printed. These worksheets use vlookup formulas to grab the data from Access. When I export my da... 17 Feb 2010 15:39
Conditional Formatting for entire row
I know how to use conditional formatting for a cell, but is there a way to do conditional formatting for an entire row? Example: if cell A18 contains the text, "total" then row 18 has a top and bottom border. Thanks, Heather ... 17 Feb 2010 15:39
HELP!! Formula with different conditions
Suppose your 15 is in A1. This will give you 3.5 in one column: =MAX(0,MIN(11,A1)-7.5) and this will give you 4 in another column: =MAX(0,A1-11) and will cope with other values as expected. Hope this helps. Pete On Feb 17, 5:36 pm, Teri <T...(a)> wrote: Hi there.  I'm hopi... 17 Feb 2010 13:24
First  |  Prev |  Next  |  Last
Pages: 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199