Alert icon
We're changing our privacy policy. This stuff matters.  Learn more  Dismiss

Excel Magic Trick 862: Count Numbers In Column, But Only If Number Is Not Repeated In Row

Loading...

Sign in or sign up now!
Alert icon
Upgrade to the latest Flash Player for improved playback performance. Upgrade now or more info.
3,750
Loading...
Alert icon
Sign in or sign up now!
Alert icon

Uploaded by on Jan 20, 2012

Download from: http://people.highline.edu/mgirvin/ExcelIsFun.htm
Create:
1. Helper column using AND function and the "not comparative operator" to check to see if numbers in row are all not the same
2. Helper column using OR and NOT function and the "equal comparative operator" to check to see if numbers in row are all not the same
3. COUNTIFS function with Mixed Cell References to count numbers in column, but only if number is not repeated in row
4. SUMPRODUCT function with Mixed Cell References to count numbers in column, but only if number is not repeated in row
5. SUMPRODUCT formula with four arrays that count numbers in column when when number is not repeated in row

  • likes, 2 dislikes

Link to this comment:

Share to:

Uploader Comments (ExcelIsFun)

  • Hi. Where is excel basic for 2010. I am having a hard time finding the beginning of excel 2010.

  • @blackultra2000 , watch this auto play video that shows how to get to videos and files for Excel Basics:

    youtube [dot] com/excelisfun

  • @ExcellsFun is there a way to create a database of info in excel that can be used for future reference in separate excel window. I want to make a database with names and room numbers. in a separate excel workbook i want to be have room numbers pop up just by typing in the name. is this even possible?

  • @iGreek88 , try the Data Validation and VLOOKUP tricks in this video:

    Excel Magic Trick 334: VLOOKUP & Data Validation for Invoice

  • You are so awesome! thanks for sharing your knowledge =)

  • @MsJoanbabe , I am glad to help!

see all

All Comments (10)

Sign In or Sign Up now to post a comment!
  • @krn14242 , you are welcome!

  • Thanks Mike.

  • @Cosme422 , I am glad that you like it!

  • useful, thanks!

Loading...

Alert icon
0 / 00Unsaved Playlist Return to active list
    1. Your queue is empty. Add videos to your queue using this button:
      or sign in to load a different list.
    Loading...Loading...Saving...
    • Clear all videos from this list
    • Learn more