Suoritettu

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

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

Taidot: Excel, Excel Macros, Excel VBA, Visual Basic, Visual Basic for Apps

Näytä lisää: count how often a value occurs in excel, vba for each array, how do i count the number of times a value appears in a column in excel?, vba for each cell in range, excel macro merge cells with same value, vba set variable across modules, vba merge duplicate rows, excel count how many times each value appears in a column, excel vba create menubar, access vba create pdf, vba create catalog html, solidworks vba create excel, vba create file, word 2007 vba create xml, word 2007 vba create custom xml, excel vba create data file, flash set static text value, access create custom error message duplicate index values table

Tietoa työnantajasta:
( 0 arvostelua ) United Kingdom

Projektin tunnus: #17889035

Myönnetty käyttäjälle:

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 1 päivässä
(202 Arvostelua)
6.6

14 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

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 Lisää

£20 GBP 0 päivässä
(773 arvostelua)
7.8
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 Lisää

£20 GBP 1 päivässä
(213 arvostelua)
6.8
zebracaro

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

£23 GBP 1 päivässä
(115 arvostelua)
6.5
TonmoyRoy111

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

£20 GBP 1 päivässä
(266 arvostelua)
6.5
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 Lisää

£100 GBP 3 päivässä
(52 arvostelua)
5.3
RushService

Feel fee to contact me for create a variable when value hits last [login to view URL] me message to discuss further more details .We provide the commments,images,videos,demos and live sessions in order to help the clients. Lisää

£20 GBP 1 päivässä
(5 arvostelua)
4.0
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 1 päivässä
(5 arvostelua)
3.7
£18 GBP 7 päivässä
(0 arvostelua)
0.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, Lisää

£18 GBP 1 päivässä
(0 arvostelua)
0.0
£10 GBP 0 päivässä
(0 arvostelua)
0.0
£23 GBP 1 päivässä
(0 arvostelua)
0.0
£13 GBP 10 päivässä
(0 arvostelua)
0.0
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 1 päivässä
(0 arvostelua)
0.0