-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
headache!
-
M
Unique count of column cells based on date column and specific text in another column issues. Nested IF's within FREQUENCY
So far my formula (non-working) is as follows. =SUM(IF(FREQUENCY(IF(CritDateTest<=CritOutDate AND IF(ISNUMBER(SEARCH(Vuln1,CritVulnTitleTest)),MATCH(CritIPTest,CritIPTest,0)))),ROW(CritIPTest)-ROW(CritIPBeginTest)+1),1)) or...- morlince
- Thread
- column frequency headache! ifs
- Replies: 8
- Forum: Excel Questions
-
Z
conditional formatting
<tbody> Name purchase 1 purchase 2 purchase 3 Amount customer since years membership <colgroup><col></colgroup><tbody> Abricht </tbody> <colgroup><col></colgroup><tbody> 1 </tbody> 4 0 <colgroup><col></colgroup><tbody> $291 </tbody> <colgroup><col></colgroup><tbody>...- zoinc
- Thread
- conditional formatting excel headache! purchase years
- Replies: 4
- Forum: Excel Questions
-
Z
Conditional formating for two columns
I can't sleep, this is driving me nuts <colgroup><col><col></colgroup><tbody> Dieter Adriaensen € 4,820.40 Sammy Bogaert € 3,716.60 Griet Coostermans € 2,190.90 Andy Peeters € 3,170.49...- zoinc
- Thread
- conditional formatting excel excel 2013 headache!
- Replies: 4
- Forum: Excel Questions
-
W
Sum multiple columns based on column and row criteria
Hi all, I need to be able to sum multiple columns based on the column header (to select the columns) but also particular rows based on the first column. Please see the below example: <tbody> Basic Allowance Basic Tax Basic Emp No. Salary Accom Hol Pay Tax Temp Sal 1 5000 1250 850 500...- WardyKSA
- Thread
- headache! index & match multiple columns multiple critera vlookup
- Replies: 18
- Forum: Excel Questions
