Suoritettu

Excel VBA Organization, Sort Propert list by number of duplicates. grouped by name

READ DETILS FIRST< THEN OFFER PRICE< PRICE IS NOT TO CHANGE

Example:

Column E, F, (G&H)

TMK number (E), Customer (F), Address (G-street&H-state, zip code)

1-1-000-000, Ally, 43 Apple rd, HI

1-1-000-000, Ally, 43 Apple rd, HI

1-1-000-000, Ally, 43 Apple rd, HI

1-1-000-000, Ally, 43 Apple rd, HI

1-1-000-000, Dan, 19 Kite rd, HI

1-1-000-000, Dan, 19 Kite rd, HI

1-1-000-000, Dan, 19 Kite rd, HI

1-1-000-000, Dan, 19 Kite rd, HI

6-1-000-000, Amy, 5 Bike rd, HI

6-1-000-000, Amy, 5 Bike rd, HI

6-1-000-005, Amy, 5 Bike rd, HI

3-1-000-000, Bob, 45 Will rd, NV

3-1-000-000, Bob, 45 Will rd, NV

2-6-000-000, Dylan, 89 Lucky rd, HI

2-6-000-000, Dylan, 89 Lucky rd, HI

2-4-000-000, Emma, 1 Two road, TX

1-2-000-000, Susan, 7 Socks rd, HI

Note: that the duplicates are in order from most to least duplicates.

(Ally-4, Dan-4, Amy-3, Bob-2, Dylan-2, Emma-1, Susan-1)

note: that properties and numbers are grouped to name, not separated.

(Amy's properties with different TMK #s: 6-1-000-000 and 6-1-000-005 are one group of 3 properties. Not separated in groups of 2 and 1)

note: that there will be other columns (A-D and I-Z) of information, but the columns mentioned above are the most important to organize, but each row of information shall not be deleted or mismatched, Row will follow arrangement.

note: that it is in alphabetical order by name AFTER order of duplicates high to low

(Amy does not come before Dan because she has only 3 duplicates)

note: that it is in numerical order AFTER alphabetical order, which is AFTER duplicate order

(Amy: 6-1-000-000 comes before 6-1-000-005)

note: that Amy has duplicate addresses with different TMK numbers ( 6-1-000-000 and 6-1-000-005 ), but it is still grouped to her name and counts as a duplicate of 3, not separated 2 and 1.

note: that they will all be separated, highlighted alternatively.

(Allys group will be red, Dans group will be green, amys group red, bobs group green, dylans group red, emmas group green, susans group red. )

note: i will be able to collapse and expand the groups of duplicates, so that only one name shows. But i can expand to view the information as well.

(All of Ally collapses to one line rather than 4 separate rows, similar to other groups of duplicates.)

note: i also need to be able to isolate rows of information by its TMK number and i can search by the first 2 numbers, rather the whole TMK number.

(if I only wanted to view TMK 1-1,1-2, 2 and 6...it will filter out Bob. if i only wanted to view TMK 2 it will filter out all except Dylan and Emma

...with respect to its order of 1. most to least duplicates, 2. alphabetical, 3. numerical.)

note: if addresses are in another state OR CITY, I can filter this out too. For example, if I only wanted to see states in HI, Bob and Emma would be filtered out. Applies to city as well.

Taidot: Excel, Visual Basic, Visual Basic for Apps, tietojenkäsittely, tiedonsyöttö

Näytä lisää: list files ftp excel vba, create list number separated comma excel, excel vba csv number format time, excel vba directory tree file list, excel vba csv number cell formatted text, excel vba list web files, cisco phone number import excel vba, excel vba column contains text column contains number, group row number excel vba, excel vba cidr number, excel vba list files directory, excel vba create loop list, microsoft excel vba project organization, excel vba extract worksheet number worksheet name, excel vba find value list, excel vba find list list, excel vba find record delete list, need excel vba simple box inventory list, excel vba compare lists add list

Tietoa työnantajasta:
( 0 arvostelua ) Hilo, United States

Projektin tunnus: #20716350

Myönnetty käyttäjälle:

rashedkhanrubel

Hi, I have understand the project requirement & interested to make vba to organize file for this project. Please send a message so we can discuss more & start the project. Thanks.

$20 USD 1 päivässä
(11 Arvostelua)
3.6

20 freelanceria on tarjonnut keskimäärin 27$ tähän työhön

jaylancer43

Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I'm an Expert Excel and VBA programmer on freelancer.com and have been featured by the freelancer community (g Lisää

$50 USD 1 päivässä
(723 arvostelua)
8.5
aubrey03

I am an Excel and VBA specialist with a lot of experience in creating complex automation tools, formulas, databases, queries and macros. You may check some of my projects here: [login to view URL] Lisää

$50 USD 1 päivässä
(115 arvostelua)
5.9
valor312

VERY EASY FOR ME, I can do it within 30 min Hi, Nice to meet you. When it comes to Excel, I am an expert Please see product I made recently using VBA and C#, python, java, excel management https://www.freelancer.com/p Lisää

$30 USD 1 päivässä
(46 arvostelua)
5.6
StormLion227

Hello Sir. My name is Marko and I am an Engineering Graduate with an MBA degree. I am a full time freelancer and I will work hard on this till completion. An Expert VBA programmer on freelancer.com and I do not bid on Lisää

$30 USD 1 päivässä
(13 arvostelua)
4.9
xinglong717

Hi. How are you? I read your description carefully and am very interesting in your project. I can start right now and can help you. If you hire me,i will do my best for your job and you can get the best results. Lookin Lisää

$20 USD 1 päivässä
(11 arvostelua)
4.2
ielucerotrad1

I can get the job done! I have a lot of experience in very large files (data processing for files over 100MB around million rows), for tis kind of data I do not use excel functions because they are very very slow. I ca Lisää

$30 USD 2 päivässä
(11 arvostelua)
3.7
ninestar801

Hi, I have gone through your requirements and I can do this task. The skills and resources needed for this project are in my genes. I can assure you for a complete professional work in given time [login to view URL] share comp Lisää

$70 USD 7 päivässä
(11 arvostelua)
3.5
chraheelbhatti

I have dealt with many such VBA assignments and I am sure to serve you with your desired thing. pl share details.

$10 USD 1 päivässä
(9 arvostelua)
3.7
ironstar20311

Hello, sir! I am happy to put my bid on your project. Here are projects I have done recently using Excel VBA and formulas https://www.freelancer.com/projects/excel/Write-simple-VBA-code-extract/?w=f [login to view URL] Lisää

$20 USD 1 päivässä
(7 arvostelua)
2.6
$25 USD 1 päivässä
(0 arvostelua)
0.0
amirmajeed369

Hello,I will complete your work . I have much experience of word and excel.I will complete your work as soon as possible.I have written speed.I have skill about data entry and typing in english Relevant Skills and Ex Lisää

$20 USD 7 päivässä
(0 arvostelua)
0.0
mittalnaveen007

I will complete your work in one day.. I am very egar to work for you

$25 USD 1 päivässä
(0 arvostelua)
0.0
rajnishbajaj02

My freelancer journey is very short but my skills are very good. So you can hire me to get the cheapest cost and the best quality service. My main goal is to ensure the highest job satisfaction of my clients. Client sa Lisää

$15 USD 5 päivässä
(0 arvostelua)
0.0
sylviabera

hello, i have the relevant skill set, proficiency in Ms Excel and the experience to enable me handle your data entry project. With my excellent typing speed and attention to details i can deliver your work within the d Lisää

$20 USD 7 päivässä
(0 arvostelua)
0.0
$17 USD 1 päivässä
(0 arvostelua)
0.0
surajpandey4999

I have no computer or laptops only work on mobile

$25 USD 1 päivässä
(0 arvostelua)
0.0
AMITALLIED

Dear Sir, You recently advertised on this site regarding your project requirement, after reading the job description I am confident that I would be a perfect fit for this position as my experience and abilities precis Lisää

$30 USD 5 päivässä
(0 arvostelua)
0.0
shahzaibkhandur8

Hi I am an electrical engineer and have attended extensive Microsoft office training from PWC uk while working as a database and financial officer at a UK based charity called wellbeing of women!

$20 USD 7 päivässä
(0 arvostelua)
0.0
vw6609302vw

I have total of 10 years of IT Experience. Currently working as data analyst. Have very good knowledge of MS Office products specially Excel, VBA, Macro etc..

$20 USD 7 päivässä
(0 arvostelua)
0.0