You need a simple name filter in Excel or what you can offer
20 USD A1 and B1
ID of Timur Photographer
ID of Oleg Lifestyle
by Artemius Safron
......................
ID of the Academic
I need to check each line in the cell B1 if it has a name from my table.
My table consists of the format names (the number of names approximately 7000):
The Timor
by Artem
... ...
by Marina
If the name in my table coincides with the name in a line, then in that same line set the flag (e.g. a plus) so that I then select all the lines in which there are coincidences.
You need to look for the accurate coincidence. If in the millionic table there is the word "Arthemy", then this line is not suitable, as we have only "Arthem".
I explained it clearly on the screen.
Applications 1
Work results
Client's review of cooperation with Anton T.
You need a simple name filter in Excel or what you can offerA great executive. The work was done better than the TZ was provided. I recommend cooperation.
Freelancer's review of cooperation with Konstantin Zhuravlev
You need a simple name filter in Excel or what you can offerThe customer was in contact, after the discussion came to the rational solution of the task, then the customer quickly checked the work of the program and accepted the project.
-
Winning proposal1 day20 USD
5859 345 0 Winning proposal1 day20 USD
I can solve this task in a variety of ways: in Excel itself using a macro or a separate program. Indeed, here and the Excel format is overwhelming, it is easier to deal with two text files.
The specific implementation depends on whether it is a single operation or you need +- constantly solve such a task.
There are a lot of options to choose after discussion.
-
1 day11 USD
31 1 day11 USD
Good day !
I process the table with SQL.
I work carefully.
-
1 day11 USD
176 17 0 1 day11 USD
Hello to you.
an interesting task. Ready to take.
Write in the face, we will discuss details.
-
1 day18 USD
2437 76 0 1 day18 USD
Constantine, good night.
If the task is one-time, a formula of Excel is enough to solve it. If you do it often, it makes sense to automatize.
I will send you the finished file within one day with "1" in the rows of coincidences of names.
I will be happy to cooperate! Go to)
-
1 day11 USD
1572 19 0 1 day11 USD
I have a lot of experience in Excel. By your task, the formula can solve the question very quickly.
-
1 day11 USD
4461 102 0 1 day11 USD
Good day . I will be glad to help. I do everything quickly and efficiently!
-
1 day11 USD
364 16 0 1 day11 USD
Good evening . I can make a script on Python that processes 2 documents and displays the plus against coincidences.
The extra lines can be removed immediately.
The script can also be compiled into exe under windows.
-
1 day11 USD
419 13 0 1 day11 USD
Welcome to!
I work with Excel and Google tables.
Ready to help with a formula or macro (scripts).
I will be happy to cooperate.
-
2 days11 USD
647 11 1 2 days11 USD
Good Morning, Constantine
The task is clear.
Ready to perform today. I can get to work immediately.
Google Sheets and Excel (profile work)
I will be happy to work together, good day.
-
1 day18 USD
2864 72 0 1 day18 USD
There is similar. With the possibility of searching for words, word forms, text.
Write in private, I will show you.
-
А если есть имя Артем Гонов, а у вас будет в списке либо Артем либо Гонов, либо Гонов А.?
-
Konstantin Zhuravlev RK Promotion
Если в милионнике будет Артем Гонов, а в моём списке будет "Артем" то +
Если в милионнике будет Артем Гонов, а в моём списке будет "Гонов" то +
Если в милионнике будет Артем Гонов, а в моём списке будет "Артем Г" то -
-
Можете дать что-то (часть) для пробы?
-
А чому не використовувати звичайний фільтр по стовпчик ? Без вибору а сторонній таблиці . Це ж простіше
-
Konstantin Zhuravlev RK Promotion
А як у той стовпчик додати 5000 імен? І той фільтр ніколи не обробить мільйон строк з 5000 ключами
-
https://i.imgur.com/ZtizA9x.pngось ваша ситуація тільки в числах я вважаю що спсиок імен з 1 рядка.
в стовпчик С просто формула з перевірками =ЕСЛИ(ЕСЛИОШИБКА(ПОИСКПОЗ(A1;$E$1:$E$7;0);"")<>"";"true";"")
-
Konstantin Zhuravlev RK Promotion
Я пользовался такой формулой, но она не ищет точное совпадение
-
Тоді вам в екселі макрос краще писати , але в будь якому випадку це буде не швидкий шлях при умові мільйону рядків, але з іншої сторони менш глючний
-
Или программку которая сделает все намного быстрее макроса.
-
Теоретично так, наприклад на пайтоні можна зробити утілітку
-
Current freelance projects in the category Desktop Apps
Need an Airtable architect to build a relational schema and a new clean Airtable base.Need help rethinking and building a clean relational schema for an internal operational system on Airtable. The current database is already in use by the team, but it has grown organically: the structure is partially flat, some tables/views are actively used, while others are… Databases & SQL, Desktop Apps ∙ 2 days 23 hours back ∙ 9 proposals |
Creation of software for generating cutting files for wooden puzzlesWe are looking for a developer to create software that automates the process of building cutting files for wooden jigsaw puzzles. Current Process Currently, each file is created manually by a designer in Adobe Illustrator. The file contains: the outer contour of the puzzle in… Desktop Apps ∙ 3 days 3 hours back ∙ 14 proposals |
Small edit on the website
16 USD
Need to update the offer agreement in the footer to a new one, the company has changed its regulations Task will take 20 minutes Web Programming, Desktop Apps ∙ 4 days 5 hours back ∙ 110 proposals |
Account reconciliation tool with the bank, cards, and accountantTechnical Assignment: Tool for Reconciling Accounts with Bank, Cards, and AccountantGeneral Goal A local tool (script/small application in Python) is needed, which is manually run once every 1-2 months on my computer and performs reconciliation between: Invoices I issued to… Python, Desktop Apps ∙ 6 days 12 hours back ∙ 44 proposals |
Add pauses of 10-30 seconds between sending emails.
Hello! I am looking for an experienced 1C / BAS (BAF) programmer to promptly resolve a technical issue with email distribution.Problem essence: We use the accounting program BAF (Business Automation Framework), version 2.0. Once a month, there is a need to send about 300 emails… Web Programming, Desktop Apps ∙ 12 days 4 hours back ∙ 10 proposals |
Kharkiv