Suoritettu

Match data in two columns Excel CSV

We have 3 columns in a csv

1. List of current SKUS

2. List of old SKUS

3. Suppliers that are attached to the old SKUS

The order of column 1 cannot change. We need to match column 3 values to column 1 and have a list of "new SKUS" with a list of the suppliers next to it.

So we are trying to get the list of suppliers attached to the new SKUs (column 1) but finding out which SKUs appear in both columns... hope this makes sense.

File attached.

Taidot: tiedonsyöttö, tietojenkäsittely, Excel, Visual Basic

Näytä lisää: compare multiple columns in excel for matches, powershell compare two excel columns, python compare columns in two csv files, how to compare two columns in excel using powershell, compare two csv using powershell and return matching and non matching values, powershell compare two csv columns, powershell compare csv rows, compare two csv files for differences, excel vba import data csv file, excel update data csv file often, excel chart data csv file, data link excel mdb file, excel automatic extraction data csv file, macro export range data excel csv file, read data csv file vba excel, excel macro match data columns, extract data csv file excel, data excel file csv file mining, extraction data csv file excel, export data macro excel text file

Tietoa työnantajasta:
( 209 arvostelua ) London, United Kingdom

Projektin tunnus: #17557583

Myönnetty käyttäjälle:

$15 USD 1 päivässä
(6 Arvostelua)
2.9

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

jaylancer43

Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I'm an Expert Excel and VBA programmer on freelancer.com and have been featured by the freelancer community ( Lisää

$35 USD 0 päivässä
(604 arvostelua)
8.3
Khurramz

Hi I can match the columns / Data as you need. Please send me chat and I'll send you sample data .

$25 USD 1 päivässä
(359 arvostelua)
7.4
AhmedSalahA

okay no problem let's be first work with us check my profile and speak with me and i need show you some examples of my work

$30 USD 1 päivässä
(80 arvostelua)
6.0
$25 USD 1 päivässä
(72 arvostelua)
6.0
$30 USD 1 päivässä
(38 arvostelua)
5.7
SayTechSolution

Hello there? Hope you are having a good day! I am sending my recent similar project work to welcome you and asking an opportunity to work with you. https://www.freelancer.com/projects/excel/verify-that-two-product Lisää

$25 USD 1 päivässä
(44 arvostelua)
4.9
$10 USD 1 päivässä
(7 arvostelua)
2.5
$35 USD 1 päivässä
(2 arvostelua)
2.6
ananthgadag

Hi, I have been working on excel files since last 8 years now and I understand you need to find out what SKUs are appearing in 2 of the columns. I just need a little more clarity and I would be happy to help you in Lisää

$15 USD 1 päivässä
(7 arvostelua)
2.2
noshinnur1

I can get this done for you within an hour. Please let me know if you are interested. Thank you. [login to view URL]

$25 USD 0 päivässä
(2 arvostelua)
0.9
SureshXobos

Hi there, I saw your project on matching the data in the 3 columns SKUS. I can easily match it using the MATCH & INDEX function in excel. It is a 10 minute task. I've done plenty of such works. See my profile fo Lisää

$10 USD 1 päivässä
(2 arvostelua)
0.6
areverence

Hi There! I am an excel expert. I can see that you're looking for someone to match your existing columns with the desired output? Well, I would love to do it for you. Please inbox me for further details. Kind regards Lisää

$30 USD 1 päivässä
(0 arvostelua)
0.8
seabdulbasit

Hello sir, i hope you will be alright.i can change the column. i have great programming and i can do this. i guarantee that you will not be disappointed

$20 USD 1 päivässä
(0 arvostelua)
0.0
$20 USD 1 päivässä
(0 arvostelua)
0.0