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

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

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 create a macro that will do quick. Looking forward to work on the project. -Chandra

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 regards

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

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

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 markets. Experienced MBA Finance as well. 3. Your project will be delivered on time with high standard 4. Assistance will be provided with number of clarifications until client satisfaction

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

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, Attention to detail is my key strength and have received several appreciations from my clients I am very good at: Communication (both spoken and written - English) Advanced MS Word/Excel Google Docs/Spreadsheets Basic Working with Data entry,wordpress, SEO, Social Media Platform Handling multiple email accounts Managing calendars Data entry/data processing Hope I have provided all the necessary details. Please let me know if you have any questions.

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