Käynnissä

Excel - Macro or Formula

Now i got a huge problem with this excel, i really don't know how to complete it.

As the file that you can see, i got this data column (400k), data are not consecutives (but they are in ascending order), and i need to "order" them in the other table (the example "yellow" one), where each row is composed of a "group" of consecutive numbers (from... to...), for example the first numbers 400004 e 400006 are not consecutive with each other, so they will fill 2 different rows.

I really hope that someone could help me. Thx

Taidot: tietojenkäsittely, Excel

Näytä lisää: excel vba write sql table row, excel macro import csv create pivot table, replace row excel row lookup macro, macro replacing row excel, excel macro view row data form, excel vba paste formula macro, excel macro add row increment, excel paste formula macro, excel macro exporting row text file, excel macro cut row, excel macro next row, excel macro add row fill data, visual basic excel macro next row, excel macro chart row, macro excel 2003 calc, paste area macro excel, script macro excel 2003, macro excel web, data mining macro excel, copy next cell macro excel, copy website macro excel, macro excel string manipulation, macro excel open sort output, show print macro excel, install macro excel

Tietoa työnantajasta:
( 1 arvostelu ) Fontanafredda, Italy

Projektin tunnus: #13106727

Myönnetty käyttäjälle:

rohitagarberg

hi sir, i will fix the consecutive number issue for all 400k rows right now. thanks.....................................

10 € EUR 1 päivässä
(123 arvostelua)
5.2

13 freelanceria on tarjonnut keskimäärin 22 € tähän työhön

P0L

Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

30 € EUR 1 päivässä
(127 arvostelua)
6.4
rameshmahala

Hello there, I would like to be considered for this job as I have great working experience in VB macro writing. I will start this tomorrow morning and will deliver you in next 24 hours. Thanks, Ramesh

29 € EUR 2 päivässä
(3 arvostelua)
2.6
PiasKumarDas

Hello, This types of operation is very tough and almost impossible to do using excel. What u should do load the excel data into mysql or any database then in that database doing the operation u want like removing Lisää

23 € EUR 1 päivässä
(1 arvostelu)
2.4
hedyaouiboubaker

A proposal has not yet been provided

23 € EUR 1 päivässä
(3 arvostelua)
1.1
23 € EUR 1 päivässä
(0 arvostelua)
0.0
12 € EUR 3 päivässä
(0 arvostelua)
0.0
23 € EUR 1 päivässä
(0 arvostelua)
0.0
Alqaaf

Hi I am an excel expert and an advanced excel trainer who has conducted more than 20 training sessions. I also help individuals and corporates in process efficiency initiatives, typically with streamlining and automa Lisää

23 € EUR 1 päivässä
(0 arvostelua)
0.0
JhonCanasto

Amplia experiencia con la creación de plantillas en excel incluidas formulas, así que puedo ayudarlo con su problema.

23 € EUR 1 päivässä
(0 arvostelua)
0.0
Deb67

I'm really good with Excel, and I think I understand what you're trying to do. I have time this evening/tomorrow to help if you would like. I'm in the UK. Deb

30 € EUR 1 päivässä
(0 arvostelua)
0.0
24 € EUR 0 päivässä
(0 arvostelua)
0.0
23 € EUR 1 päivässä
(0 arvostelua)
0.0
16 € EUR 1 päivässä
(0 arvostelua)
0.0