Suljettu

Quick Excel fix - expert help replace my TEXTJOIN nightmare

In have a workbook with just 2 tabs. on tab 1 i have a long list (300K rows) and on tab 2 I have a long list (150K rows). I need to lookup the values in column A on tab 2 against column A in tab 1 and then show the value in column B but i have cases where i have more than 1 match in column A and i need to see all of the matches together on tab 2. so I have this formula which works 100% perfect

=TEXTJOIN(",",TRUE,IF(Master!A:A=A2,Master!B:B,""))

but... its slow and basically everytime i touch the sheet it locks up. I think there is a smarter way to handle with this index or maybe a smart vlookup but I know for sure this textjoin i have now isnt going to work. the reason I choose it was that if i have more than 1 match it nicely combined the values in to a single cell as seen here [login to view URL] but the workbook is not usable at this scale with this formula.

Need some quick help on this and ideally we can just replace what we have with your new formula and keep going on our way. the final output needs to be sure to handle these cases

no matches against tab 1, 1 match against tab 1, many matches against tab 1

Like answer here is something like pre sorting tab 1 and using OFFSET and INDEX and AGGREGATION

here is a sample sheet so you can see what i mean about the performance of this. I have chatted with several people about their ideas and I need to say for sure a solution here is not waiting 10 minutes for it to update and then copying static values.

[login to view URL]

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

Tietoa työnantajasta:
( 456 arvostelua ) Austin, United States

Projektin tunnus: #21784444

42 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_18% %project_currencyDetails_sign_sub_19%/tunti tähän työhön

DataHome

Hello there, Let me handle your requirement. Hope I can do a quality work for you Waiting for your good reply Amaan

$30 USD / tunti
(70 arvostelua)
8.4
schoudhary1553

Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Pl Lisää

$40 USD / tunti
(344 arvostelua)
8.0
P0L

Hello, I’m an Excel expert and I would like to help you with your formula. Please check my profile and contact me to discuss further details. Regards.

$35 USD / tunti
(330 arvostelua)
7.3
dgled

Hi, I am expert Excel, and /VBA/Macro. I have considerable experience in merging files and manipulating the data in a structured database, especially with importing external files to a structured database in Excel and Lisää

$38 USD / tunti
(84 arvostelua)
7.1
elqueabandona

Hello, my name is Cristian, i am Excel/VBA expert. I am in the top 5 of freelancers in this area and i have more than 240 projects successfully completed here. i work alone, i do not have a team or outsource the proje Lisää

$25 USD / tunti
(235 arvostelua)
6.9
TechnoGuruu

Hi, I have checked the project description and I will build a Excel VBA macro for this purpose instead of use of functions, that will be faster and efficient. I am a full time freelancer and can work dedicated on this Lisää

$25 USD / tunti
(87 arvostelua)
6.0
aubrey03

I am an Excel and VBA specialist with a lot of experience in creating complex automation tools, formulas, databases, queries and macros. You may check some of my projects here: [login to view URL] Lisää

$25 USD / tunti
(122 arvostelua)
5.9
c4cuteconain

I am a professional with a decade of experience working in a US based NASDAQ registered company with all the skills and knowledge required for your project. Please send me a message and we can move forward with your pr Lisää

$25 USD / tunti
(72 arvostelua)
5.9
StormLion227

Hello. My name is Marko and I am an Engineering Graduate with an MBA degree. I am a full time freelancer and I will work hard on this till completion. An Expert Excel/VBA programmer on freelancer.com and I do not Lisää

$41 USD / tunti
(36 arvostelua)
5.4
truepai

Hello! I understood your project. I see that you need some help for fixing excel data processing issue. I am on freelancer all day and I will implement all things that you want perfectly. I can help with that and can s Lisää

$45 USD / tunti
(2 arvostelua)
4.4
Ahmed818

Hello, i can write VBA code to do the textjoin work , it will be faster samples of my VBA work : https://www.freelancer.com/projects/excel/Create-Excel-Spreadsheet-Macro-that/ https://www.freelancer.com/projects/exc Lisää

$25 USD / tunti
(52 arvostelua)
4.4
writingapp

Hi. I am ready to write your project Write apps on your demand in many languages (Visual Basic, VBA, VBS, .NET, C#, JS, Python, Java, PowerShell) Write database apps including many db formats: MS Access, MS SQL, SQL Lisää

$25 USD / tunti
(19 arvostelua)
4.6
polite90

I can do it in 3~4 hours Hi, I am a senior windows developer. I have rich experience with excel and vba programming. I can do it perfectly. Thanks

$25 USD / tunti
(4 arvostelua)
4.2
maguirrer

Hello, I can help you with your project, can you send me a message to discuss more details of the file attached?, I can start working on the best solution immediately.

$40 USD / tunti
(26 arvostelua)
3.9
IgeS

Hi there, You have a very huge data set amounting to almost half a million rows. I used to handle data set that was a third of size of yours and encountered same issue. I learned that having arrays formulas nested in Lisää

$40 USD / tunti
(2 arvostelua)
3.6
arash18k

Hi, Vlookup function is one of the most heaviest functions in Excel, so when you use it for a large data (like 300K) and you use it with other formulas (like textjoin) then your Excel will took time to process. There i Lisää

$25 USD / tunti
(7 arvostelua)
3.5
makelegend17

Hello,sir. I have read your post and noticed that you were looking for someone who can do your job - 'Quick Excel fix - expert help replace my TEXTJOIN nightmare' I can show you my work history, if you want. I am a p Lisää

$41 USD / tunti
(1 arvostelu)
2.0
jayantkumar314

Hi there, I am an experienced developer and after reading your project description, I am confident that I am a suitable candidate for this project because I have 3+ years of experience in excel, data-entry, copy-typin Lisää

$25 USD / tunti
(2 arvostelua)
2.1
habalghost22

Hi , I am an MBA professional having 4yrs of experience in Analytics, Tableau, Advanced Excel, VBA and Python. I have done ample amount of work in excel and VBA and I could show some examples of it. I can give you a sm Lisää

$25 USD / tunti
(4 arvostelua)
2.3
reubengi

Hi, I can get you the static values you need in about one minute. (copy paste and excel processing) It will require 2 helper columns in Tab 1. Is that OK? regards Reuben

$25 USD / tunti
(2 arvostelua)
1.1