-
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.
performing
-
V
Exclude some records from a SUMPRODUCT ranking formula
Hi, I have a table of SalesReps with a two ranking formulas. The resulting rankings are used on dashboards on other worksheets. The formulas rank the performance of SalesReps within each RepGroup in ASC and DESC order (so that we can report on the top performing and bottom performing reps)...- vegasbaby207
- Thread
- achieved formula performing ranking reps
- Replies: 12
- Forum: Excel Questions
-
S
Performing some data validations.
Hi there. I am performing data validations on a sheet, and created the following code. I created a variable 'z', and added a formula that works. When I run the code in the debugger, I get a type mismatch error. Expanding on this a little, I would like to add vbyesno to the MsgBox, and if no...- srosk
- Thread
- code data end msgbox performing
- Replies: 11
- Forum: Excel Questions
-
J
If statement problem
=IF(OR(A4="WL"),("0"),0) + IF(OR(A4="BL",A4="DL",A4="LL",A4="LGL",A4="NL",A4="MDL",A4="RL",A4="WGL",A4="XL", A4="A",A4="B",A4="CB",A4="D",A4="K",A4="V",A4="X", A4="H",A4="L",A4="LG",A4="M",A4="MD", A4="N",A4="Q",A4="R",A4="T",A4="W",A4="WG",A4="Y"),(A7*B7),0) In the above statement, only BL...- jgold20
- Thread
- performing properly results statement suggestions
- Replies: 11
- Forum: Excel Questions
