Cancelado

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!

Habilidades: Excel

Ver mais: excel add row based cell value, excel add rows based value, adding row excel, adding rows, excel add rows based formula, cell add rows excel, add row cell value excel, so ben, me excel, add row excel based value, excel add rows based cell value, ms excel help, excel help formula, Value, thomas, thomas i, rows, ms-excel, ms s, ms excel, jimmy, excel formula, excel based, excel add-in, excel add in

Acerca do Empregador:
( 18 comentários ) Moncton, Canada

ID do Projeto: #562190

75 freelancers estão ofertando em média $41 para este trabalho

nagybatonyi

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

$30 USD in 0 dias
(40 Comentários)
5.4
agihcam

Check PMB.

$30 USD em 1 dia
(39 Comentários)
5.2
SamNanton

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

$30 USD in 0 dias
(25 Comentários)
4.9
best4best

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

$30 USD em 1 dia
(55 Comentários)
4.9
dev3dworx

Please check PMB for details.

$55 USD em 1 dia
(19 Comentários)
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 dias
(23 Comentários)
4.6
srinichal

Delivery under a day and also willing to show a demo

$30 USD in 0 dias
(3 Comentários)
4.4
Kryptora

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

$35 USD in 0 dias
(14 Comentários)
4.2
mahfuzmurshed

Please see PMB.

$30 USD in 0 dias
(46 Comentários)
4.1
xamdam91

Looking forward to working with you...

$30 USD in 0 dias
(14 Comentários)
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 em 1 dia
(9 Comentários)
3.9
rajtuhin1

I can do this in 1 hour.

$30 USD in 0 dias
(3 Comentários)
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 dias
(9 Comentários)
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 em 1 dia
(11 Comentários)
3.6
d2imatrix

Please check PMB

$30 USD in 0 dias
(1 Comentário)
3.2
oFAZo

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

$30 USD in 0 dias
(9 Comentários)
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 em 1 dia
(3 Comentários)
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 em 1 dia
(1 Comentário)
2.6
KellogITSolution

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

$30 USD in 0 dias
(3 Comentários)
2.6
Abikris

Hi, Check your PMB. Kris

$30 USD in 0 dias
(5 Comentários)
2.5