⛔ Restrict the entry of DUPLICATE data in EXCEL, without Macros.
🟢 👩💻 Prevent/Restrict, for example, the same invoice from being entered twice, or if you're in HR, avoid entering the same work week twice for the same employee 👍😁, and best of all, without using MACROS 😋.
00:00 INTRO
✅ 00:59 Step #1: Learning Data Validation.
✅ 02:31 Step #2: Learning Data Validation with a Custom Formula.
✅ 06:47 Step #3: Learning the COUNTIFS function.
✅ 09:07 Step #4: Applying Data Validation to our exercise.
✅ 13:41 Step #5: Customizing the Error Message.
-----------------------------------------------------------
LINKS to the referenced videos:
▶ 1-minute Tip - Restricting entry of ONLY DATES in EXCEL:
• Tip 1min - Restringir que se ingresen SOLO...
------------------------------------------------------------
👨💻 If you want to download the video file for practice, download it from the following link:
https://smartprosoluciones.com/restri...
-----------------------------------------------------------
📒 Would you like to know your current level in EXCEL? Take our free test:
https://maraton.smartprosoluciones.co...
-------------------------------------------------------------
✅🚀 🅼 🅸 🆂 🅲 🆄 🆁 🆂 🅞🆂
DO YOU WANT TO BOOST YOUR EXCEL SKILLS 👩🏻💻 👨🏻💻 and STAND OUT FROM THE MASS OF PROFESSIONALS? GREAT! Visit my academy's website for more information about my training:
https://www.smartprosoluciones.com/
---------------------------------------------------------------------------------------------------------
👨👨👧 LET'S STAY CONNECTED! 😁:
Instagram and Facebook: @SMARTpro Academy
► Instagram: / smartproacademy
► Facebook: / smartproacademy
► TikTok: / smartproacademy
---------------------------------------------------------------------------------------------------------
💡💻 Get the Microsoft 365 Excel Version (Starting at $5.99):
https://click.linksynergy.com/fs-bin/...
🎥💻 I use this program to produce and edit my videos: https://techsmith.z6rjha.net/c/273772...
#excel #microsoftexcel