_excel-video-371-using-arrays-to-see-if-a-list-is-unique.jpg "Excel Video 371 Using Arrays to See if a List is Unique from set a formula in excel Video Screenshot Preview")
GalleryPlay Video:
(Note: The default playback of the video is HD VERSION. If your browser is buffering the video slowly, please play the REGULAR MP4 VERSION or Open The Video below for better experience. Thank you!)
⏲ Duration: 2 min 80 sec
✓ Published: 21-Mar-2015
✓ Published: 21-Mar-2015
Description:
I have one more array trick in Excel Video 371 before we move on to a new topic.Today we’ll use a COUNTIF function inside a MAX function inside an IF function to determine if a list is unique.It’s really not quite as bad as that sounds.We’ll set up a COUNTIF function first to determine the number of times a doctor’s name appears in a list.Then we’ll use the MAX function to determine the maximum number of times a doctor’s name is on the list.Finally, the IF function will pri
I have one more array trick in Excel Video 371 before we move on to a new topic.Today we’ll use a COUNTIF function inside a MAX function inside an IF function to determine if a list is unique.It’s really not quite as bad as that sounds.We’ll set up a COUNTIF function first to determine the number of times a doctor’s name appears in a list.Then we’ll use the MAX function to determine the maximum number of times a doctor’s name is on the list.Finally, the IF function will pri
Share with your friends:
Whatsapp | Viber | Telegram | Line | SMS
Email | Twitter | Reddit | Tumblr | Pinterest
Related Videos
_creating-microsoft-excel-formulas-and-functions.webp "Microsoft 365")
_slidefab-2-how-to-create-a-basic-92.webp "Go ahead and try it yourself: Free trial available at https://slidefab.com/freetrialnnThis video demonstrates how to set up a simple Hello World workbook and presentation with SlideFab 2. It contains the most simple case where a formula-based text from Excel is multiple times written to a shape in a Powerpoint presentation.nnSlideFab 2 is a software to automatically produce PowerPoint slides from any Excel model. The idea is to empower Excel users. Typically coding skills in VBA (Visual Basic) a")
_excel-apply-formula-to-entire-column-2020-1-minute.webp "Leon Renner")
_how-to-use-formulas-and-functions-in-microsoft-excel.webp "Teacher's Tech")
_how-to-make-formulas-for-dates-in-excel-2016.webp "Excel, Word and PowerPoint Tutorials from Howtech")
_excel-formulas-and-functions-124-full-course.webp "Kevin Stratvert")
_what-is-my-5-minute-maths-tutor.webp "The platform is an ‘on demand’, primary school maths tuition program.nnLesson by Lesson, step by step, the program progressively allows your child to develop certainty of knowledge, capability, and confidence in maths, in primary school… so they don’t get left behind or have to struggle in high school and beyond. nnBuilt using the Maths Mastery Formula, your child is stepped through a lesson structure of explicit presentation, explanation, and constant revision of the entire maths curric")
_10-excel-formulas-that-will-set-you-apart-cheat-sheet.webp "MyOnlineTrainingHub")
Related Video Searches
Back to Search
Search Videos
Recent Searches
×
(Note: The default playback of the video is HD VERSION. If your browser is buffering the video slowly, please play the REGULAR MP4 VERSION or Open The Video below for better experience. Thank you!)
_creating-microsoft-excel-formulas-and-functions.jpg)
_slidefab-2-how-to-create-a-basic-92.jpg)
_excel-apply-formula-to-entire-column-2020-1-minute.jpg)
_how-to-use-formulas-and-functions-in-microsoft-excel.jpg)
_how-to-make-formulas-for-dates-in-excel-2016.jpg)
_excel-formulas-and-functions-124-full-course.jpg)
_what-is-my-5-minute-maths-tutor.jpg)
_10-excel-formulas-that-will-set-you-apart-cheat-sheet.jpg)
❮❯
1 / 10
2 / 10
Play Video: (Note: The default playback of the video is HD VERSION. If your browser is buffering the video slowly, please play the REGULAR MP4 VERSION or Open The Video below for better experience. Thank you!)
3 / 10
4 / 10
5 / 10
6 / 10
7 / 10
8 / 10
9 / 10
10 / 10
![[+]](/images/menu.gif){kind=small}