filmov
tv
Excel compare two or more text strings
Показать описание
To compare two text strings in Excel, you can use the EXACT Function or you can use =A1=B1. The EXACT function checks for case sensitivity. Example "Chris" is not the same as "CHRIS" if you use the EXACT function. With =A1=B1, Chris would appear as the same.
Example:
A1 is Chris
B1 is CHRIS
=A1=B1 will return TRUE. It is not case sensitive.
=EXACT(A1,B1) will return FALSE. It is case sensitive.
IF you want to compare three or more cells, you can use EXACT Function with the AND function.
Chapters:
00:00 Introduction
00:34 Case-insensitive compare
01:08 Trim spaces either side of strings
01:47 Case-sensitive compare
03:10 Case-insensitive multi-compare
#excel #msexcel #microsoftexcel #chrismenard #chrismenardtraining
Chris Menard's Website:
And make sure you subscribe to my channel!
-- EQUIPMENT USED ---------------------------------
-- SOFTWARE USED ---------------------------------
DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!
Example:
A1 is Chris
B1 is CHRIS
=A1=B1 will return TRUE. It is not case sensitive.
=EXACT(A1,B1) will return FALSE. It is case sensitive.
IF you want to compare three or more cells, you can use EXACT Function with the AND function.
Chapters:
00:00 Introduction
00:34 Case-insensitive compare
01:08 Trim spaces either side of strings
01:47 Case-sensitive compare
03:10 Case-insensitive multi-compare
#excel #msexcel #microsoftexcel #chrismenard #chrismenardtraining
Chris Menard's Website:
And make sure you subscribe to my channel!
-- EQUIPMENT USED ---------------------------------
-- SOFTWARE USED ---------------------------------
DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!
0:02:39
How to Compare Two Excel Sheets and Find Differences
0:08:47
How to Compare Two Excel Sheets and Find Differences
0:06:17
Compare Two Columns in Excel (for Matches & Differences)
0:05:34
Excel compare two or more text strings
0:03:10
MS Excel - Compare Two Sheets
0:03:18
How to Compare Two Columns in Excel to Find Differences (The Easiest Way)
0:07:16
Compare Two Lists and Find Matches & Differences with 1 Formula - Excel Magic Trick
0:03:00
Excel Tricks: Compare Two Excel Files [Find the Differences]
0:34:41
Artificial Neural Networks Made Simple: Learn & Create One in Excel (No Coding!)
0:04:33
Excel Formula to Compare Two Lists - Excel Magic Trick 1596. Is Item in List?
0:07:25
How to compare two Excel files for differences
0:05:56
Compare Two Excel Worksheets & Find Duplicates Using Formula or Conditional Formatting
0:01:14
How to Do a VLOOKUP With Two Spreadsheets in Excel
0:01:55
How to Use Excel to Match Up Two Different Columns : Using Excel & Spreadsheets
0:10:15
Find Multiple Matching Values in Excel and Highlight - Match & Highlight Names from Two Sheets
0:01:51
Conditionally Format When Two Columns have Same Value. Excel Magic Trick 1704.
0:06:12
Excel How To Compare Two Tables in a Second
0:09:43
Compare Two Sheets for Duplicates with Conditional Formatting
0:04:29
Excel: compare two worksheets and highlight differences
0:03:36
How to compare two lists in Excel
0:03:50
How to compare two columns in different Excel sheets using Vlookup
0:06:16
Compare Two Columns in Excel to Find Differences or Similarities
0:08:41
Match Names on Two Excel Sheets with VLOOKUP – Create Unique ID in Excel
0:11:00
Three quick ways to compare data in Excel
Комментарии