Cancelled

Add x rows in MS Excel based on Cell value

Hi everyone,

I'm looking for help creating an automated task with MS Excel.

Current I have a document that looks something like this...

ROW USER ID NAME POINTS

1 64 Jimmy 293

2 62 Thomas 32

3 66 Jarred 20

4 67 Bill 7

5 65 Ben 5

I would like to have an automated script or formula that would allow me to add rows for each users based on the numbers of points they have.

For an example let's take USER 65 (BEN)...

I would like to see the following:

ROW USER ID NAME POINTS

1 65 BEN 1

1 65 BEN 1

1 65 BEN 1

1 65 BEN 1

1 65 BEN 1

4 67 Bill 1

4 67 Bill 1

4 67 Bill 1

etc...

So it's adding the same value based on the number of points this user has.

Thanks everyone!

Skills: Excel

See more: adding row excel, adding rows, cell add rows excel, so ben, me excel, excel help formula, value, thomas, thomas i, rows, ms s, MS excel, jimmy, excel formula, excel based, excel add, excel 7, ben, add number, excel cell, excel numbers, excel rows, excel task formula, excel task, formula based

About the Employer:
( 18 reviews ) Moncton, Canada

Project ID: #562190

75 freelancers are bidding on average $41 for this job

nagybatonyi

Such jobs are my daily practice, please see PMB for details! Regards!

$30 USD in 0 days
(40 Reviews)
5.4
agihcam

Check PMB.

$30 USD in 1 day
(39 Reviews)
5.2
SamNanton

This is an extremely simple request. If I could bid less than $30, I would.

$30 USD in 0 days
(25 Reviews)
4.9
best4best

Hi, The template is ready. Please refer PMB. Thanks

$30 USD in 1 day
(55 Reviews)
4.9
dev3dworx

Please check PMB for details.

$55 USD in 1 day
(19 Reviews)
4.7
DrTech76

Hi, It's done. A demo waits for you to review it in the message I have sent you. Regards, DrTech76

$30 USD in 0 days
(23 Reviews)
4.6
srinichal

Delivery under a day and also willing to show a demo

$30 USD in 0 days
(3 Reviews)
4.4
Kryptora

Hello, l already have the macro code for this. Please see PM for demo.

$35 USD in 0 days
(14 Reviews)
4.2
mahfuzmurshed

Please see PMB.

$30 USD in 0 days
(46 Reviews)
4.1
xamdam91

Looking forward to working with you...

$30 USD in 0 days
(14 Reviews)
4.1
candida

I am a 1st class degree holder in IT with 4 years experience in online projects including spread sheets. I am an excel expert and willing to do this for you. So please refer PM for more details. Thanks in advance!

$30 USD in 1 day
(9 Reviews)
3.9
rajtuhin1

I can do this in 1 hour.

$30 USD in 0 days
(3 Reviews)
3.8
nmppatel

I am an Excel VBA expert. I have completed many projects on GAF in Excel skill. I will provide quick & professional service.

$30 USD in 0 days
(9 Reviews)
3.7
johnsinit

Dear Titorvis! I am an experienced VB and VBA programmer and would be happy to work for you. Please, check PMB. Sincerely yours, John.

$30 USD in 1 day
(11 Reviews)
3.6
d2imatrix

Please check PMB

$30 USD in 0 days
(1 Review)
3.2
oFAZo

Exceptional quality & Quick work. Please refer to Profile & PMB for details. Thanks FAZ

$30 USD in 0 days
(9 Reviews)
3.1
monica365

Hi, I have many years of experience developing macros in MS Excel. It is possible to create a macro to add an amount of rows based on the points the user has.

$30 USD in 1 day
(3 Reviews)
2.7
snitchell

Hi, i'm confident that I can deliver the project to the required specification. I assume there is a good reason for this extra row requirement & would happlily help you with further functionallity within the bid.

$50 USD in 1 day
(1 Review)
2.6
KellogITSolution

Hello Ready to start right now. Please see your PMB for details. Thanks

$30 USD in 0 days
(3 Reviews)
2.6
Abikris

Hi, Check your PMB. Kris

$30 USD in 0 days
(5 Reviews)
2.5