General
in [Excel]
|
Sorting by number of characters I am using Excel 2007 (thought I posted this earlier, but can't find it - even with google group search). I need to sort an inventory list according to the number of characters in the item number (not by numerals). Is this possible? Thanks! Nicole ... 13 May 2010 13:50
Counting Colored Cells that are Conditional Formated Hello All, In Excel 2003, I am looking for a way to count colored (conditional formated cells) in a column. Desired outcome.... Counted cells #'s in (A1) where the colored cells are between A:2 and A:4000 TFTH ... 13 May 2010 21:36
Indirect function help Please help - I followed the directions at the site below to set up data validation where the second list is based on the selection of the first list. The first list works fine but the second list doens't have anything in the dropdown, even though there are items on the list. The name box for the dependent li... 13 May 2010 12:43
edit CF in Excel 2007 General question - CF Excel 2007 - is there some way to view and/or edit what conditional formula had been used in a file? It looks like you can only make a new rule or clear rules. ... 13 May 2010 12:43
Macro I'm having problems with the last part of a macro. The macro deletes 4 columns, sorts on column G then subtotals column H on each change in column G. The final piece is to remove all the rows where the subtotal is zero so that just the non zero subtotals are left. Does anyone know how to do this? ... 13 May 2010 11:37
Cell Formatting Is there a way to format a number cell to change to red fonts if less than another cell? Ex: Cell H2 is 29 which is less than Cell K2 which is 35. I would like to drag a formula down column H to change to red if the value is less than column K. ... 13 May 2010 19:24
FILTERS HOW DO I GO ABOUT INSERTING A FILTER FOR EACH ROW THAT I HAVE DATA ON EXCEL ... 13 May 2010 10:30
Viewing multiple worksheets 4.5 years later and this post helped me out with exactly what I wanted to know Thanks! ... 13 May 2010 10:30 |