Скачать или смотреть Master the Basics of Case Sensitive Comparisons with EXACT!

If you use an Equal to (=) for two text strings with exactly same text but different casing, you will get a true result. Therefore it is best to use the EXACT function with text strings.

The Excel EXACT function compares two text strings, taking into account upper and lower case characters, and returns TRUE if they are the same, and FALSE if not. EXACT is case-sensitive.

Purpose
Compare two text strings
Return value
A boolean value (TRUE or FALSE)
Syntax
=EXACT (text1, text2)
Arguments
text1 - The first text string to compare.
text2 - The second text string to compare.

Usage notes
The EXACT function compares two text strings in a case-sensitive manner. If the two strings are exactly the same, EXACT returns TRUE. If the two strings are not the same (taking into account upper and lower case) EXACT returns FALSE.

#exactfunction #excelfunctions #excelexactfunction
~~~~~~~~~~~
👆Subscribe to the channel at 👆https://bit.ly/3eB8Mmd
👍Like, share and comment on the videos.
~~~~~~~~~~~
'Excel Is Simple' is an effort to make Excel & Google-Spreadsheets usage simple and teach the toughest concepts in the simplest ways possible. Here you will find Excel tips and tricks, Excel Task trackers, Excel Dashboards and different Excel keyboard shortcuts. We also cover various Excel formulas and functions and explain the real-life useability of each one of them. If you don't find a relevant video for you, drop a comment on any particular video and we will try our best to make a new video to answer your query.
~~~~~~~~~~~
Check out some of your relevant content here:
🎯 Excel Task trackers and Dashboards:    • Design an interactive Excel dashboard usin...  

🎯 Google Sheets Videos:    • How to Design a Google Sheets  Dashboard f...  

🎯 Excel tips and tricks for 2021:    • Unlocking the Secret to Excel Productivity...  

🎯 Excel Formulas and Functions:    • Видео  

🎯 How to Excel for Beginners:    • Unlock the Power of Excel: An Essential Gu...  

🎯 Must Kow Excel Shortcuts:    • Видео  

🎯 Time Saving Hacks in Excel:    • Excel Trick for Pros: "Concatenate" or "Am...  

🎯 VBA Macros:    • Power Up Your Excel with this Batch File R...  

🎯 Free Excel Templates to Download:    • Gauge Chart hack for Excel Dashboards - St...  
~~~~~~~~~~~
#exceltutorial #exceltutorialforbeginners #exceltraining #excelvba #exceltemplates #exceldashboard #exceltv2020 #excelpayroll #excelapp #excelautoshape #excelautomation #excelamazingfeatures #excelattendance #excelandroid #excelaccounting #excelapplication #excelbill #excelbutton #excelbeginner #excelbhavcopy #excelchart #excelcalendar #excelcost #excelconference #exceldatefunction #exceldatepicker #exceldatarecovery #exceldateformula #exceldataentry #excelfunctions #excelformulaslist #excelforbeginners #excelformulas #excelforhr #excelformulasandfunctions #excelforbegineers #excelformulabasics #excelgstinvoice #excelhash #excelinvoice #excelinvesting #excelinfographics #excelinventory #excelinterviewquestions #exceljobinterview #excellearningseries #excelmacros #excelmining #excelonsmartphone #excelproject #excelpro #excelpivottables #excelpowerquery #excelquiz #excelquotation #excelquickandeasy #excelquestions #excelrevolution #excelsecurity #excelsheet #excelshortcutkeys #excelshorts #excelsior #excelshortcuts #excelshortcutkeysintamil #exceltricks #exceltasktracker #exceltowhatsapp #exceltopdf #excelutility #exceluserform #excelvisulization #excelvisualization #excelvbacode #excelvlookup #excelvbaforbeginners #excelvbatutorial #excelwhatsapp #excel10tutorial #excel2019 #excel2016 #excel2tally #excel4us
~~~~~~~~~~~ #microsoftexcel