Hello Folks,
Im looking to create a group based of the following categories with a specific set of range rules.
E= IF column (e) is >5
and column (c) <5
and SUM column (es1+es2) <5
else BLANK
C= IF column (c) is >5
and column (e) <5
and SUM column (es1+es2) <5
else BLANK
EC= IF column (c) is >5
and column (e) >5
and SUM column (es1+es2) <5
else BLANK
ES= IF SUM column (es1+es2) >5
else BLANK
<tbody>
</tbody>
SOLUTION that I'm trying to strive for is listed below. This would be on a separate worksheet and where the formula would be placed. This would be reading off of the data worksheet. I am thinking it probably requires a Nested IF statement in combination with a VLOOKUP for the User names and the ability to read column headers or column numbers or something to that nature.
<tbody>
</tbody>
Any help would be much appreciated
Regards Mo.
Im looking to create a group based of the following categories with a specific set of range rules.
E= IF column (e) is >5
and column (c) <5
and SUM column (es1+es2) <5
else BLANK
C= IF column (c) is >5
and column (e) <5
and SUM column (es1+es2) <5
else BLANK
EC= IF column (c) is >5
and column (e) >5
and SUM column (es1+es2) <5
else BLANK
ES= IF SUM column (es1+es2) >5
else BLANK
User | electronics (e) | cats (c) | special 1 (es) | special 2 (es) |
Brett Hart | 176 | 66 | 0 | 0 |
Charlie Murphy | 34 | 4 | 0 | 0 |
Sam Pelt | 6 | 0 | 53 | 53 |
Max Keller | 3 | 45 | 0 | 0 |
<tbody>
</tbody>
SOLUTION that I'm trying to strive for is listed below. This would be on a separate worksheet and where the formula would be placed. This would be reading off of the data worksheet. I am thinking it probably requires a Nested IF statement in combination with a VLOOKUP for the User names and the ability to read column headers or column numbers or something to that nature.
User | Group |
Brett Hart | EC |
Charlie Murphy | E |
Sam Pelt | ES |
Max Keller | C |
<tbody>
</tbody>
Any help would be much appreciated
Regards Mo.