VBA - create a variable when value hits last value in a set of duplicate values

Completed Posted 5 years ago Paid on delivery
Completed Paid on delivery

Hi,

I have a field 'Field' in attached excel and I want a VBA code that will loop through the column values in Field and create a new field 'Field2' which will flag 1 when loop hits the last

value in the Set of same values. Finally, the macro should delete the original Field, retain Field2

Excel Excel Macros Excel VBA Visual Basic Visual Basic for Apps

Project ID: #17889035

About the project

13 proposals Remote project Active 5 years ago

Awarded to:

danielgpratidya

Hi, It'll be done quickly, I am available to write the code for you now. Let me know when you're ready. Regards, Daniel

£15 GBP in 1 day
(205 Reviews)
6.6

13 freelancers are bidding on average £24 for this job

cgullapalli

HI, I am good at Excel and vba. I have referred the file. You want to allocate 1 at the end of each block of similar numbers and remove the first column. It is possible with simple if statement. However, i can c More

£20 GBP in 0 days
(877 Reviews)
8.0
elqueabandona

Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews, they speak for themselves. Best rega More

£20 GBP in 1 day
(236 Reviews)
6.9
zebracaro

I can do it for you quickly and exactly . Please contact me for saving your time and your money .

£23 GBP in 1 day
(126 Reviews)
7.0
TonmoyRoy111

Dear Client I can make the macro for you in less than an hour. Please contact me............................... Roy

£20 GBP in 1 day
(349 Reviews)
6.9
citijayamala

1. I am an expert in Excel, Excel formulas, and all excel functions, macros, lookup, pivot tables and charts. 2. Have done many projects in Excel, created many dashboards, and Business intelligence tool for forex mar More

£100 GBP in 3 days
(65 Reviews)
5.6
vijayvizzu7

Hi, i have 10+ years of experience in Advance Excel, VBA, Macros and other office integration development. I am sure i can handle your request

£17 GBP in 1 day
(11 Reviews)
4.0
harsh2244

Hi, Can I help you with this? I should be of good help to you with all of these tasks. Shall we have a chat more in detail about this? Look forward to hearing from you. Regards Harsh To give you more details about me, More

£18 GBP in 1 day
(6 Reviews)
3.7
bamiteko1969

Hi, I can do your excel VBA and macro for you with coding and looping.I will deliver your work at a stipulated time.

£18 GBP in 1 day
(1 Review)
1.7