Categories

JavaScriptPHPHTMLCssPythonWordPressWeb developmentLinuxMySQLAndroidWindowsJavaC++ / C#LayoutReactUbuntuYiiDjangoProgramming1C-BitrixLaravelSystem administrationTelegramJSONDebianPostgreSQLIOSGoogleHtaccessWindows ServerGitMacOSGoogle ChromeCMSWooСommerceBootstrapNginxSQLUnityAPI
Make a leaderReport
M
M
mts20502016-07-30 14:43:22
excel
mts2050, 2016-07-30 14:43:22

How to remove non-matching text values ​​in Excel?

There is a list of 1600 elements. There are two columns of 280,000 items. How to remove from these columns all values ​​that do not match the list of 1600 elements.

Reply
Answer the question

Answer the question

In order to leave comments, you need to log in

1 answer(s)
Report
K
Konstantin Nagibovich, 2016-07-30
@nki

Use the VLOOKUP function to find mismatched elements and delete them.

Similar questions
K
Kolyaka2016-08-12 17:07:51
How to open hyperlink in Excel 2013 via https? 0Reply
N
new20leon2020-10-27 18:58:16
How to get (determine) the last filled cell in excel as a variable? 0Reply
A
Alexander Diunov2016-08-16 20:33:35
What a field fields! in Excel and how to edit them? 1Reply
R
Rxd2016-08-18 13:02:02
Why doesn't DoCmd.OutputTo close files in Access? 1Reply
G
gizmo_zx2022-03-14 13:12:53
Different width of Excel columns in blank file on different PCs? 0Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question