Peruttu

MACRO, Power query, to remove duplicate from excel file

Hi,

looking for a power query /VBA / Power BI ,to remove duplicates,

I have an excel sheet with 4 Million mobile numbers in Multiple Column,

I want an output in excel sheet with Unique numbers, Also when i add a new column with new data, query must give output for Unique number from all existing data in the sheet including the newly Added data,

I am attaching a sample file here with,

[login to view URL]

Taidot: Excel, Visual Basic, Tietojenkäsittely, Excel Macros, Power BI

Näytä lisää: save excel file older version using vba, remove readonly excel file, remove read excel file, remove duplicate records file, import excel file power point macro, remove permissions excel file, excel power query macro, power query remove duplicates keep latest, macro to open password protected excel file, upload excel file to sharepoint using vba, sql query remove duplicate rows based on one column, power query remove duplicates keep highest value, power query remove duplicates from list, power query remove duplicates, keep latest, power query remove duplicates slow, power query remove duplicates based on multiple columns, power query remove both duplicates, power query remove errors not working, convert excel file to exe with vba macro, query from sharepoint excel file

Tietoa työnantajasta:
( 0 arvostelua ) New Delhi, India

Projektin tunnus: #30577606

15 freelanceria on tarjonnut keskimäärin ₹1877 tähän työhön

(103 arvostelua)
5.8
(39 arvostelua)
6.0
(22 arvostelua)
3.5
shantanuhouzwala

I am a Google Certified Data Analyst so I think I will be a great fit for this job. I have been using Excel for past 4 years so I know all the shortcuts and tricks to get the job done quickly and accurately.

₹2000 INR 2 päivässä
(0 arvostelua)
0.0
dmo35904

consistent in updating patient’s charts that I was promoted to a position responsible for training new hires. I’m very cheerful—Studies show that positivity can have a huge effect on patient recovery times, so I smile Lisää

₹1050 INR 7 päivässä
(0 arvostelua)
0.0
raviprasadadiga

I am expert in excel vba and I have seen your sample file. I can create macro to do clear duplicate and provide clean unique mobile number. Happy to work on your project.

₹1250 INR 2 päivässä
(0 arvostelua)
0.0
Rafirm

Hello!! I can do the work in one day. I'm ready to get started right away! I guarantee a 100% clean job and on time delivery.

₹1050 INR 2 päivässä
(0 arvostelua)
0.0
Alokrai87

I'm new to freelancer.com. I'm well versed in Excel work, need more details of your project, would be able to complete ASAP. Would be able to spend 4 hours daily. I've mentioned the price of the project, please let me Lisää

₹1050 INR 7 päivässä
(0 arvostelua)
0.0
nhungnhdrb

Hello mam/sir, I'm so interested to your project. I’m Nhung Nguyen, I have 12 years in Finance data and developing Power BI I’m founder and director of DrB VietNam Consulting and Management Jsc, a business specializin Lisää

₹1050 INR 7 päivässä
(0 arvostelua)
0.0
mranubansal

I am an expert in writing excel VBA and creating custom formulas. I assure you that you will not be disappointed with my work.

₹1000 INR 2 päivässä
(0 arvostelua)
0.0
Wahinnovations21

Hi, I am glad to share with you that I am a Microsoft Certified Consultant, and would love to be your virtual Power BI consultant. I have experience creating Views, Constraints, Triggers, Joins, Cursors, Temp tables, Lisää

₹1500 INR 7 päivässä
(0 arvostelua)
0.0
yogeshraghav2708

I have excellent knowledge of excel. I can make your excel sheet in minimum time with 0% error rate.

₹750 INR 4 päivässä
(0 arvostelua)
0.0
shaggy1661

i can do this work because i have experience in this with long time go.... i dont need to prove myself for this job.,....

₹880 INR 7 päivässä
(0 arvostelua)
0.0
sharmakalpana182

Hello My name is Kalpana. I m interested to do this work. I have more than 1 year of experience in Excel and data Entry Work. I m very hardworking and honest person. Give me a chance to do this work.

₹1070 INR 6 päivässä
(0 arvostelua)
0.0
AQADEER01

hi I would like to assist you in your above task of removing duplicate number and addition of new details. I assure you of quality work and timely execution of your required task. Sincerely, Abdul Qadeer

₹1000 INR 5 päivässä
(0 arvostelua)
0.0