Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Having troubles with conditional formatting
FOM DEC JAN
Rich G james-8 Mark Hamm Korry-11 Mark Hamm Chris-21 Dave-2, Matt-22,Chris 23 Mark Hamm Korry-26 Rich G Steve-20 Mark Hamm Matt-11 Matt-22 Mark Hamm Korry-3 Matt K Mark Hamm Chris-25 Mark Hamm Korry-11 Rich G James-8 Mark Hamm Mark Hamm Rich G Mark Hamm Chris O - 22 Mark Hamm Matt K John K-16 Mark Hamm matt-7 Mark Hamm Korry-16 Mark Hamm Matt-11 Mark Hamm Ok so here is what im trying to do, for example there are 4 rows that have Rich G as FOM in those 4 rows there was 3 monthly checks done in DEC so at the bottom of that column it would show 3, and for Jan it would show 0, I am having trouble trying to write a formula that filters the month columns by a FOM that counts how many rows have non blank cells if that row matches a certain FOM. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Having troubles with conditional formatting
Try this in B26 (DEC column, below last Mark Hamm entry)
=SUMPRODUCT(--($A$2:$A$25="Rich G"),--(B$2:B$25<"")) You can fill that formula to the right to check JAN column (and others) -- as written it will always use names in column A and the B column will automatically change as you fill to the right. Row numbers stay same regardless. You could use another cell's contents to replace the literal "Rich G" in the formula and then what ever was in that cell is what would be tested as (to still check for Rich G) =SUMPRODUCT(--($A$2:$A$25=$A$2),--(B$2:B$25<"")) or =SUMPRODUCT(--($A$2:$A$25=$A$3),--(B$2:B$25<"")) to count Mark Hamm entries. "schwartzki" wrote: FOM DEC JAN Rich G james-8 Mark Hamm Korry-11 Mark Hamm Chris-21 Dave-2, Matt-22,Chris 23 Mark Hamm Korry-26 Rich G Steve-20 Mark Hamm Matt-11 Matt-22 Mark Hamm Korry-3 Matt K Mark Hamm Chris-25 Mark Hamm Korry-11 Rich G James-8 Mark Hamm Mark Hamm Rich G Mark Hamm Chris O - 22 Mark Hamm Matt K John K-16 Mark Hamm matt-7 Mark Hamm Korry-16 Mark Hamm Matt-11 Mark Hamm Ok so here is what im trying to do, for example there are 4 rows that have Rich G as FOM in those 4 rows there was 3 monthly checks done in DEC so at the bottom of that column it would show 3, and for Jan it would show 0, I am having trouble trying to write a formula that filters the month columns by a FOM that counts how many rows have non blank cells if that row matches a certain FOM. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
COM Add-in Troubles | Excel Discussion (Misc queries) | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
IF troubles | Excel Worksheet Functions | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions |