Find Jobs
Hire Freelancers

Basic data manipulation with formulas or VBA

$10-30 USD

취소됨
게시됨 8년 이상 전

$10-30 USD

제출할때 지불됩니다
I have a 2,000 line spreadsheet. Each cell in column B contains one person's name. Column E contains a hyperlink. The hyperlinks are not unique. I require output so that each line has a unique hyperlink in E. The people's names in column B will go into a column, all in one cell, separated by a '|' character. For example Column B == Column E John Smith == Link1 Tom Green == Link1 Mary Davis == Link2 Susan Johnson == Link2 Bob Moore == Link2 The result after manipulating the data would be two lines: Column B == Column E John Smith|TomGreen == Link1 Mary Davis|Susan Johnson|Bob Moore == Link2 Someone with intermediate knowledge of Excel should be able to complete this in 30 minutes or less.
프로젝트 ID: 8569498

프로젝트 정보

34 제안서
원격근무 프로젝트
활동 중 9년 전

돈을 좀 벌 생각이십니까?

프리랜서 입찰의 이점

예산 및 기간 설정
작업 결과에 대한 급여 수급
제안의 개요를 자세히 쓰세요
무료로 프로젝트에 신청하고 입찰할 수 있습니다
34 이 프로젝트에 프리랜서들의 평균 입찰은 $24 USD입니다.
사용자 아바타
Hi, I am an Excel VBA / formula expert and would happy to take on your project. Let me know and provide the source file. Regards, Arul
$30 USD 1일에
5.0 (165 건의 리뷰)
7.3
7.3
사용자 아바타
A proposal has not yet been provided
$70 USD 1일에
4.9 (249 건의 리뷰)
7.6
7.6
사용자 아바타
You dont need to recruit me now. Drop me a message and i can make a free trial study for you. If you get happy, we can proceed. (as i want more references in my profile, i provide this service) I have a 5,5 years of business analyst experience in a global company and 2,5 years data scientist experience in a game company before my freelancer career. Excel is my legs and arms. I can make any reporting, formulas, pivot tables, macros etc. I am mostly online. Just drop me a message so that we can discuss further about pricing and job details. **NOTE: I am not a comissioner like "some guys" here around. I do the job myself with highest attention to the detail. Please consider this while awarding your job to those "middlemen". Thanks,
$24 USD 1일에
5.0 (141 건의 리뷰)
7.1
7.1
사용자 아바타
A proposal has not yet been provided
$30 USD 1일에
4.9 (242 건의 리뷰)
7.0
7.0
사용자 아바타
I'm a computer science professional with a PhD degree and extensive experience in Excel and VBA. Please see reviews on my profile. It would be my pleasure to do your project. Please have a look at some Excel projects I've done: https://www.freelancer.com/jobs/Excel-Mathematics/Convert-math-proofs-Excel-formulas/ https://www.freelancer.com/jobs/php/Need-excel-plugin-convert-USD/ https://www.freelancer.com/jobs/Excel/Need-covert-very-large-dat/
$25 USD 1일에
4.8 (162 건의 리뷰)
7.0
7.0
사용자 아바타
Hi, I would love to work on this project. I have 8 years of experience in Microsoft Excel including working with excel modeling, dashboards and macros. Please contact with further details if interested. Regards Raghav Bansal
$29 USD 1일에
4.9 (95 건의 리뷰)
6.5
6.5
사용자 아바타
Hello I am an excel expert and would like to bid on the project posted by you. I have completed more than 100 projects in excel. FYI: Freelancers are not authorized to send any attachments to the employer before we receive any personal message from the client. I request you to kindly initiate the conversion so that I can send examples of my work. Rgds Rohit Pithisaria
$15 USD 1일에
4.9 (101 건의 리뷰)
6.3
6.3
사용자 아바타
Hi there, I have a vast experience in Excel and VBA and would be happy to help you on the project. Best regards, Eugene
$13 USD 0일에
5.0 (238 건의 리뷰)
6.3
6.3
사용자 아바타
I am an Excel expert and can do this with 100% accuracy. Please share the Excel file with me. Thanks!
$20 USD 1일에
5.0 (123 건의 리뷰)
6.3
6.3
사용자 아바타
Hello I can get the task done in the next 30 mins to 1 hour. Let me know if you are interested. Thanks
$20 USD 0일에
5.0 (96 건의 리뷰)
6.0
6.0
사용자 아바타
Hi, I am interested to work on your project. The requirements are clear. Please provide the source excel sheet to start the work. Regards, Rajesh.
$30 USD 1일에
5.0 (36 건의 리뷰)
6.0
6.0
사용자 아바타
Dear Sir, Done numerous similar projects in the past and always impressed the clients with my excellent VBA solutions. Out of my 40 projects, almost 35+ are complex VB/VBA projects, hence i can definitely deliver an excellent solution to your requirement. Expert in MS excel, complex Formulae, Statistical analysis, Macros (VBA), pivot, Charts, formatting, templates, dashboard, etc. Worked on several complex excel VBA projects, viz converting Raw data to structured using vba, sales dashboard, PO tracking, budgeting, profitability, estimation, time management dashboards, etc. Also I am a quick learner and complete tasks very quickly using keyboard shortcuts and multitasking skills. And I have been consistently rated as excellent by all the employers. Also Having more than 14 years of experience in banking /finance /accounting, Business analysis, Data analysis, Software development, Software Testing, SDLC, Budgeting, estimation, Project management, Process re-engineering, Statistics, Bookkeeping, HR, Payroll, AR/AP, copy typing, ebook creation, publishing, Web research, Social media marketing, lead generation, etc. Looking forward to work with you.. Have a nice day Thanks.
$34 USD 1일에
4.8 (70 건의 리뷰)
5.8
5.8
사용자 아바타
Hi there! Have done this type of work before ! Please feel free to message me with additional information or with questions if any! Thanks! -Steve
$25 USD 0일에
5.0 (73 건의 리뷰)
5.5
5.5
사용자 아바타
I have the expertise in Excel and can do this task in less than 30 minutes, when you share the data file. Ready to start work immediately
$25 USD 1일에
4.5 (64 건의 리뷰)
5.2
5.2
사용자 아바타
Hi there, I've been working with Excel since before '98 and I've been using all possible versions of it. I have years of experience working with macros and writing / debugging VBA code. You may check my portfolio images to see few pieces of my work. (This is what I do on daily basis). I am a professional and I can do a very good job. Also accurate. Do not hesitate to contact me for further details. Kind Regards, Jon
$20 USD 0일에
5.0 (34 건의 리뷰)
4.9
4.9
사용자 아바타
Hi I am interested in this project. I can do this job for you. am an experienced VBA developer. if interested in hiring me then please let me know so that we can finalize it. Regards jawad
$35 USD 1일에
5.0 (22 건의 리뷰)
4.5
4.5
사용자 아바타
I'm very well-verse in spreadsheets and Microsoft Excel, particularly strong in Formulas, V-Lookups, Pivoting, conditional formating, filtering and sorting.I also develop Professional Dashboards for Corporates with thier themes & SME as well. All work is delivered with high quality standards, without errors.I'm looking forward to serve you, on your available task.
$20 USD 0일에
4.7 (39 건의 리뷰)
4.5
4.5
사용자 아바타
Hello. So, we need: 1. Find unique links; 2. Find names, correlated with these links, and show them in way you described? Is this correct? Let's deal :-)
$15 USD 1일에
5.0 (18 건의 리뷰)
4.4
4.4
사용자 아바타
A second worksheet will be created, the second worksheet will include the data in a different format. Half an hour work. Please share the file (recommended), if I am awarded. If that is not possible I will work with dummy values, and will share you the macro. Macro is ready...
$10 USD 1일에
5.0 (21 건의 리뷰)
4.5
4.5
사용자 아바타
A proposal has not yet been provided
$10 USD 0일에
4.6 (31 건의 리뷰)
4.2
4.2

고객에 대한 정보

국기 (CANADA)
Calgary, Canada
5.0
25
결제 수단 확인
11월 21, 2007부터 회원입니다

고객 확인

감사합니다! 무료 크레딧을 신청할 수 있는 링크를 이메일로 보내드렸습니다.
이메일을 보내는 동안 문제가 발생했습니다. 다시 시도해 주세요.
등록 사용자 전체 등록 건수(일자리)
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
미리 보기 화면을 준비 중...
위치 정보 관련 접근권이 허용되었습니다.
고객님의 로그인 세션이 만료되어, 자동으로 로그아웃 처리가 되었습니다. 다시 로그인하여 주십시오.