reps

  1. 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)...
  2. D

    use VBA to group rows in Excel

    I have a fairly large spreadsheet to list customer details which is sorted by sales reps (about 40 reps). I want to be able to double click on a rep's name (in Column C) and have VBA automatically group the rows below it that have the same data in column C as what was in the cell that i double...
  3. P

    Lookup function for sales tracking workbook

    Hi friends! Looking for some help here with formulas (trying to do this without VBA); I've done something similar years ago and can't remember how I did it! :( I am working on a sales tracking workbook. I have Zapier dumping raw data into the workbook from my transaction database and am...
  4. G

    How to Calculate Number of Sales Reps needed based on Expected Clients

    I have a problem I'm trying to analyze. We have to do an analysis on how many new sales reps to hire based on the number of expected onboarded clients. The dynamic part of the problem is that when we hire a sales rep, they have a 2 quarter training period, after which they are able to make a...
  5. S

    UDF not working as expected

    I have a UDF I based off of a prior I was using. The prior one works just fine. But for some reason, this new one just returns a #VALUE error. I have 3 columns with Headers of: TD ST FLR In the FLR I input my UDF and it is based off of the TD & ST. Could someone give it a look over and...
  6. C

    If Cells Contain (Specific) Text Multiply Corresponding Cells (Excel-Meathead needs help)

    <tbody> (A) Exercise (A) Sets (A) Reps (B) Total (B) Sets (B) Reps Squat 1 5 Squat 1 5 Bench 2 5 Bench 2 10 Deadlift 3 5 Deadlift 3 15 </tbody> Hey everyone, I'm using Excel 2016, and I'm trying to have Excel auto-calculate the total number of reps based on the exercise. I've managed...
  7. C

    If Cells Contain (Specific) Text Multiply Corresponding Cells (Excel-Meathead needs help)

    <tbody> (A) Exercise (A) Sets (A) Reps (B) Total (B) Sets (B) Reps Squat 1 5 Squat 1 5 Bench 2 5 Bench 2 10 Deadlift 3 5 Deadlift 3 15 </tbody> Hey everyone, I'm trying to have Excel auto-calculate the total number of reps per exercise in my training programs. I've managed...
  8. B

    Formula Problem

    I have made a table that allows me to manually input a number of repititions and the next cell gives me the score that is associated with number by using INDEX MATCH. As long as the score is for each exercise is "100" and over, the next exercise score does not populate and stays white until...
  9. B

    Altering data depending on conditional format

    Hello everyone, I have a table with 3 different cells that have data in them (F4, H4 and J4). These cells are set as scores. The next cell, L4 has a SUM formula to get the total score of all 3 score cells (G4, I4 and K4). The scores are for number of push ups, number of sit ups and run time...
  10. A

    Change Cell Range Based On A Drop Down

    Hi, I am trying to create a sheet for training programmes, whereby I can select the training parameters i.e. set x reps etc. from a dropdown say 4x8. This then updates the training programme from the parameter set out on another existing sheet. So sheet 1 might look like this, with different...
  11. S

    Auto Populating into a workbook

    Mr.Excel Experts, I have a spreadsheet of goals for individual sales reps that i need to put into a simple goal workbook for each rep. Is there a way to auto populate the data? or do i need to manually do each one? There is a total of 36 reps. Thanks, David
  12. L

    Conditional copy between two worksheets - VBA

    Hi I have a list of quotes that I track for five sales reps. Each sales rep has their own worksheet. I would like to copy data from Columns A, C, and D of each row to the corresponding rep's worksheet, based on the value of Column B (Rep) So that all of CL's quotes go on CL tab...

Some videos you may like

This Week's Hot Topics

Top