A repo of code snippets ..

...this is a log of code snippets and useful tips I wrote/found. Should you find any mistakes or have any useful suggestions, please do not hesitate to write to me.

Monday, February 6, 2017

Most frequently occuring data in a row

=INDEX(B2:D2,MODE(MATCH(B2:D2,B2:D2,0)))

can be used for example to count votes
Posted by Neelima at 2:30 PM

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Blog Archive

  • ▼  2017 (7)
    • ►  June (3)
    • ►  April (1)
    • ►  March (1)
    • ▼  February (2)
      • Most frequently occuring data in a row
      • Splitting a colum into multiple columns Excel
  • ►  2016 (2)
    • ►  December (1)
    • ►  October (1)
  • ►  2015 (6)
    • ►  June (1)
    • ►  April (1)
    • ►  March (1)
    • ►  February (1)
    • ►  January (2)
  • ►  2014 (21)
    • ►  September (2)
    • ►  August (5)
    • ►  July (4)
    • ►  April (1)
    • ►  March (4)
    • ►  February (4)
    • ►  January (1)
  • ►  2013 (7)
    • ►  November (2)
    • ►  October (1)
    • ►  September (4)
  • ►  2012 (4)
    • ►  August (2)
    • ►  February (2)
Simple theme. Theme images by luoman. Powered by Blogger.