Access VBA To Assign Alphabet Letter To Strings

$10-30 USD

Finalizat

Data postării:

aproape 4 ani în urmă

$10-30 USD

Plata la predare

I am using Access VBA to manipulate Excel. In Excel I will have data similar to this 1.1.1.1.1.1 1.1.1.1.1.1 2.1.1.1.1.1 3.1.3.3.1.1 And I need the following steps performed 1) Get a unique list of the values 2) Sort the list ascending 3) Assign a alphabet letter to the values ---> like this 1.1.1.1.1.1 A 2.1.1.1.1.1 B 3.1.3.3.1.1 C so on and so forth - and they could repeat, meaning it goes to AA, BB, CC, or even as far as AAA, BBB, CCC. 4) Once the alphabet letter has been assigned to the list, perform a VLookup() to the original list so that original list (with duplicates) is updated to have the alphabet value assigned

Excel

Visual Basic

Microsoft Access

Visual Basic for Apps

ID-ul proiectului: 25613933

Despre proiect

6 propuneri

Proiect la distanță

Activ: 4 ani în urmă

Vrei să câștigi bani?

Adresa de e-mail

Avantajele de a licita pe platforma Freelancer

Stabilește bugetul și intervalul temporal

Îți primești plata pentru serviciile prestate

Evidențiază-ți propunerea

Te înregistrezi și licitezi gratuit pentru proiecte

Acordat utilizatorului:

@shpmadushanka

Hello there, This looks like an interesting task and I'm happy to do it. Manipulating the data to decode them into characters is a cool thing to do. Won't take much time for this. I'll either create a new column and insert the decoded data or will replace the original content depending on your preference. Will use VBA and will put comments so you can modify it later yourself in case you need any change in future. Let me know.

$14 USD în 2 zile

5,0

(1 recenzie)

0,7

6 freelanceri plasează o ofertă medie de $23 USD pentru proiect

@nikhil08

Hi there, I have sound knowledge of excel. I will give u unique list with alphabets in excel. Let me know.

$30 USD în 1 zi

5,0

(196 recenzii)

7,6

@VladimirLilenko

Hello! I am ready to carry out your project in the reasonable price and in the shortest possible time and with the highest quality! You can read reviews about my work at: https://www.freelancer.com/u/VladimirLilenko?w=f From the Microsoft Access, of course, familiar. Regards, Vladimir

$30 USD în 1 zi

4,9

(230 recenzii)

7,0

@sloker18

With respect to this project I would like to present myself as a candidate for your consideration. I read your project descriptions carefully, I am proficient with Microsoft Excel and macro/VBA development, I can write the macro as requested. Would be great if you can share your file for more context, kindly get back to me if you wish to proceed. I am available to start your project immediately. Looking forward to discuss further and work on your project.

$30 USD în 1 zi

5,0

(128 recenzii)

6,6

@hayteekeys

Hi, I'm a professional and expert in Data works or projects..My skills and services include: - Web scraping - Data entry - Data mining - Data processing - Excel - MySQL - Oracle -Financial Analysis -Advanced Excel -MS Office -Python -PowerPointMacros -Automatioin -Automation tools -PowerBI -VBA -Excel and VBA automation - etc. A professional having more than 7 years of experience in financial modeling, VBA macros, MS Office automation with postgraduate degree, Worked in reputed organisations on senior level. I am expert in my field, who knows the value of time, very hard working and always delivers the work on time. I always deliver the work well in advance with continues communication & timely response until satisfactory completion of the project. I only accept the projects which I am sure can be done within the stipulated time frame and budget.. I always deliver 100% Satisfaction to the client. Hope my skill and work can help you with your business. i look forward to have further discussion with you in the chat. Thanks Regards ATEMENU.D

$10 USD în 1 zi