Find Jobs
Hire Freelancers

9-9-14 Query data from Excel Spreadsheets

$30-250 USD

Đã hoàn thành
Đã đăng vào hơn 9 năm trước

$30-250 USD

Thanh toán khi bàn giao
I have a very large excel file (7163 rows) that I need to have unique data sets extracted. I need: 1) A list if all the unique products. (ID#, Description, Manufacturer, Model, Unit$) 2) A list of all the Unique Rooms (Department, Room Name, Room#) 3) A list of all the Unique Manufacturers (Manufacturer) I assume you can convert into Access, run a query, and export the results back into Excel. Thanks, George
Mã dự án: 6434367

Về dự án

47 đề xuất
Dự án từ xa
Hoạt động 10 năm trước

Bạn muốn kiếm tiền?

Lợi ích khi chào giá trên Freelancer

Thiết lập ngân sách và thời gian
Nhận thanh toán cho công việc
Phác thảo đề xuất của bạn
Miễn phí đăng ký và cháo giá cho công việc
Đã trao cho:
Avatar người dùng
Dear Sir, I'm happy to help you on this task. If you are comfortable along wit my ratings and reliability, send me your file to confirm. I assure you that I will go beyond your expectations. I look forward to hearing from you. Best regards, Priyal
$30 USD trong 1 ngày
5,0 (120 nhận xét)
6,3
6,3
47 freelancer chào giá trung bình $66 USD cho công việc này
Avatar người dùng
"Dear employer, I am a highly trained Data Entry ,Research, Web search, Web scrape, Product Add Any Type Of eCommerce Cart, Expert with great knowledge of Excel and all Social Networks. Please check my profile and ask me if you have any quest?? My bid is optional and I will let you chose the price that suits you best!!! I just want to prove my skills and have a long-term employer in you!!! Ready to work right now.Jewel."
$147 USD trong 2 ngày
4,9 (289 nhận xét)
7,1
7,1
Avatar người dùng
Consider it done. Check my past reviews for your reference. Eagerly waiting for your reply so that i can start with the implementation.
$100 USD trong 0 ngày
4,9 (220 nhận xét)
7,0
7,0
Avatar người dùng
Dear sir, Experts and top data entry service provider here to do the jobs very fast accurate .My team finished many similar project last 3 years. I look forward to hearing from you.
$147 USD trong 3 ngày
4,9 (162 nhận xét)
6,9
6,9
Avatar người dùng
Hi George. 7163 rows is not that many. I'll do that with VBA code directly in Excel. Just let me know if you need to have the code for future use. Regards, Svet.
$100 USD trong 1 ngày
5,0 (63 nhận xét)
6,6
6,6
Avatar người dùng
I am a self-motivated, detail-oriented, organized and good with multitasking indepandent contractor. please check my profile, i've no incomplete project sorry to say, its not a large file, i worked on 10K rows which are really exist in my pc, anyhow, i can use advance function of filters and extract the required data it wouldn't take me more than 1 day to complete please send me file, i show you sample work before we move ahead ready to start the work right now IF YOU NEED QUALITY WORK THEN ASSIGN ME THIS JOB thanks
$35 USD trong 1 ngày
4,9 (161 nhận xét)
6,5
6,5
Avatar người dùng
Hi George, I am an Excel macro expert and would be happy to take on your project. There's no necessity to utilize Access. The query can be completed using Excel macros itself. Let me know and provide sample data. Regards, Arul
$64 USD trong 1 ngày
5,0 (123 nhận xét)
6,3
6,3
Avatar người dùng
Hi George. I can extract the unique data set from the Excel file in few hours. Kindly share the sheet so I may take a look. You can pay after I work out the sheet for you. Regards.
$60 USD trong 1 ngày
5,0 (43 nhận xét)
6,1
6,1
Avatar người dùng
Such jobs are my daily practice. This job can be completed with advanced Excel functions, no need for Access. Fixing of bugs and minor changes are included in the bid without any additional fees. Regards
$35 USD trong 0 ngày
4,9 (55 nhận xét)
5,7
5,7
Avatar người dùng
Hi, I'm an expert in MS Access, Excel and database, so I can convert your data set in Excel into Access, run queries, and export the results back into Excel. The cost and time are $60 and 1 day. Best regards, svteam.
$60 USD trong 1 ngày
4,9 (41 nhận xét)
5,7
5,7
Avatar người dùng
Hello George, There are different ways to find the unique data from a dataset. This can be done using as you mentioned access or from within excel itself. If you could share your file with me, I would be able to pull the desired data and send it to you. I can assure you of quality work like I have been doing for past 6+ years as you would see my work history. I have been highly rated and recommended for solutions I provide. Please let me know if you would like me to work on this project for you and we may discuss the details and the next steps. Look forward to hearing from you. Thanks and Regards, Shikha (Automyze Consulting)
$45 USD trong 1 ngày
4,9 (50 nhận xét)
5,1
5,1
Avatar người dùng
Hi: Excel has a remove duplicates feature in "data" tab. Please try it. Let me know if you need any help.
$35 USD trong 3 ngày
5,0 (30 nhận xét)
5,1
5,1
Avatar người dùng
Hi, I can confirm you that I will be able to complete your project with the highest quality and accuracy. No need to pay me anything if you are not satisfied with my work. I will be more than happy if I get the opportunity to work with you on this project. Please feel free to check my reviews here (https://www.freelancer.com/u/safiqulislam67.html) . Best regards, Safiqul Islam
$70 USD trong 1 ngày
5,0 (27 nhận xét)
5,0
5,0
Avatar người dùng
Hi, I can help you with your requirement. I have closed more than 150 excel projects at various forums. Please provide more details to help you better. Regards Sawan
$40 USD trong 3 ngày
5,0 (16 nhận xét)
4,9
4,9
Avatar người dùng
I can retrieve three excel sheet from large excel file based on your requirements. I will complete this work in a day. Looking for your reply to start this work immediately.
$44 USD trong 1 ngày
4,9 (34 nhận xét)
4,9
4,9
Avatar người dùng
Bets is to convert to csv and then into mysql , followed by query using PHP. I can automate the entire process Few reasons to select us 1. we are registered PREMIUM member from 2004 2. Our bid is always in the top 3 (without being sponsored) 3. We are a registered company in India as well as in the UK. 4. We provide telephone / skype / email support during and after completion of a project. 5. We have cleared most of the core exams (see our profile to verify)
$63 USD trong 3 ngày
4,3 (6 nhận xét)
5,0
5,0
Avatar người dùng
Hi there, I'm interested to help you with your project. I have experience in excel, access and also SQL Server. If needed, I can process your product data through queries. But first let me check with the data since excel itself already have functions that can be used to create unique list. I will use the most simple and efficient way to product the result. Kindly provide the file and I will start working on this right away. Looking forward for your reply. Regards, Susanto
$30 USD trong 3 ngày
5,0 (43 nhận xét)
4,8
4,8
Avatar người dùng
Hi, I am an expert in data processing and data manipulation projects that you can see in the feedback I gained from earlier employers. Please browse my 'Reviews' for more details about my services. If you think project price and TAT offered by me are matching with your selection criteria then send me source excel file that you stated in this project post. Sample file will be transcribed from source excel file and send it to you for prior review. I look forward for your reply. Thanks, Ashok
$60 USD trong 3 ngày
5,0 (29 nhận xét)
4,8
4,8
Avatar người dùng
Hi George, Using regex would do the job. Can you attach or send me your Excel file so I can demo/sample 1 set of data for you? Ishfaq
$30 USD trong 1 ngày
5,0 (15 nhận xét)
4,1
4,1
Avatar người dùng
Hello, I am excel expert. Please send the file. I will have a look & let you know. Looking forward for the reply. Regards, Aditya
$61 USD trong 1 ngày
5,0 (31 nhận xét)
4,0
4,0
Avatar người dùng
Hello, i'm student from Lithuania, studying at KAUNAS UNIVERSITY OF TECHNOLOGY -automatic controlling bachelor. Now i got a lot free time, so i can do this job as soon as you give me the information. I can work over hours. I guaranteed speed, very good quality, responsibility, accuracy, end line time. I am working till the job is completed. So please appreciate it. Have good skills with Photoshop, excel, word. Very communicative, native. Have very good typing skills, can work with office programs very well. Also good English (in writing and reading, understanding). Have done many data entry jobs, also data collecting, transcription, mining, scraping. Always trying to do my best and do job as fast as i can. Give me a chance to prove my excellent work and i want to be a part of your team. Hope you will consider my offer. I can guaranteed speed, accuracy and responsibility. Gonna start working immediately my bid will be approved. Have done similar jobs before. Also have very good internet connection for uploading. Do not award me a project without discussing about it with me. Can start right now. Yours sincerely, Sarunas
$45 USD trong 1 ngày
5,0 (10 nhận xét)
3,9
3,9

Về khách hàng

Cờ của UNITED STATES
Phoenix, United States
5,0
311
Phương thức thanh toán đã xác thực
Thành viên từ thg 5 14, 2007

Xác thực khách hàng

Cảm ơn bạn! Chúng tôi đã gửi email chứa đường link để bạn lấy tín dụng miễn phí.
Đã xảy ra lỗi trong khi gửi email của bạn. Hãy thử lại.
Người Dùng Đã Đăng Ký Tổng Số Việc Đã Đăng
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Đang tải xem trước
Đã cấp quyền truy cập vị trí.
Phiên đăng nhập của bạn đã hết hạn và bạn đã bị đăng xuất. Hãy đăng nhập lại.