reps

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)...

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...

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...

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...

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...

<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...

<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...

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...

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...

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...

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

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...