Please solve In an excel spreadsheet, need the formulasuggestion please.I have 4 names in a singlecolumn in 4 rows - I need to assign eachperson to 25% to a column of 60 objects.Logially 4 sales people need to evenly split acolumn containing 60 customers. We need touse the formula in all cells (assignment of the60 objects)

Answered: In an excel spreadsheet, need the…

MATLAB: An Introduction with Applications

6th Edition

ISBN:9781119256830

Author:Amos Gilat

Publisher:Amos Gilat

Chapter1: Starting With Matlab

Section: Chapter Questions

Problem 1P

See similar textbooks

Related questions

Concept explainers

Question

Please solve

In an excel spreadsheet, need the formula
suggestion please.I have 4 names in a single
column in 4 rows - I need to assign each
person to 25% to a column of 60 objects.
Logially 4 sales people need to evenly split a
column containing 60 customers. We need to
use the formula in all cells (assignment of the
60 objects)

Expert Solution

Step 1

Given: 4 names

Names: A, B, C, D

Objects=60

Assign each person to 25% to a column of 60 objects.

This is performed in excel for the reference. First of all, put the names A,B,C and D in the single row then for customers. Assign the names to the customers such as each person covers 25% of the objects. Then apply the following formulas for further calculation.

Column D formula

SORTBY(SEQUENCE (60), RANDARRAY (60))

Column E formula

IFS(D2<=15,$A$2,AND(D2>15,D2<=30),$A$3,AND(D2>30,D2<=45),$A$4,D2>45,$A$5

Step by step

Solved in 2 steps with 2 images

Knowledge Booster

$Types of Data and Their Measurement$

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.

Similar questions