EXCELXOR

Advanced Excel Techniques with XOR LX

Main menu

Skip to content
  • Home
  • Blog
  • Contact Me
  • Consultancy/Tuition

Monthly Archives: August 2016

August 26, 2016

Advanced Formula Challenge #13: Results and Discussion 6

Advanced Formula Challenges

Apologies to all for the hiatus – hopefully I will have a bit more time now in which to post some new material.

Anyway, before beginning anything new, I would just like to offer my thanks to Alex, Lori and Michael for their illuminating contributions to the challenge I set a while back and which can be found here.

Another challenge to follow shortly. Watch this space!

Post navigation

Categories

  • Advanced Formula Challenges
  • Alternative Constructions
  • Coercing an Array of Returns
  • Conditional Counting
  • COUNTIFS
  • Esoteric
  • Excluding Values
  • Extracting Data
  • Extracting Numbers from a String
  • INDEX
  • Indirect Referencing
  • Integer Generation
  • Manipulating Arrays
  • Maximum/Minimum Values
  • Multiple Worksheets
  • Redimensioning
  • Shortest Formula Challenges
  • Sorting Data
  • String Extraction
  • SUMIFS
  • Uncategorized
  • VLOOKUP

Tags

Advanced Formula Challenges AGGREGATE Anagram Array Formula CODE COLUMN COLUMNS COUNT COUNTIF COUNTIFS CSE Date String Evaluate Formula Extracting Numbers FALSE FIND Formula Abbreviation FREQUENCY IF IFERROR INDEX INDIRECT INT ISERR ISNUMBER LARGE LEFT LEN LOOKUP LOWER Manipulating Arrays MATCH MAX MID MIN MMULT MOD MODE.MULT Multiple Criteria Multiple Worksheets N Non-Array Alternative OFFSET OR Orthogonal Pandigital PERMUTATION Re-dimension REPT RIGHT ROW ROWS Shortest Formula Challenges Single Column from Many SMALL String Extraction SUBSTITUTE SUBTOTAL SUM SUMIF SUMIFS Summing to Total SUMPRODUCT Syntax T TEXT Three-Dimensional TRANSPOSE TRIM TRUE Two-Dimensional Unique List Vector VLOOKUP Volatility

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 217 other followers

Contact Me: xorlx99@gmail.com

Blogroll

  • *My Posts at Excel Forum
  • *My Posts at Mr. Excel
  • Chandoo
  • Daily Dose of Excel
  • Excel Hero
  • wmfexcel
  • xl-central

Recent Posts

  • Advanced Formula Challenge #13: Results and Discussion
  • Advanced Formula Challenge #13: Single Array Containing All Entries From a Given Range in Multiple Worksheets
  • Update: Formula Wrapping Issue in Firefox and Google Chrome
  • Apologies to Readers: Formula Wrapping Issue in Firefox and Google Chrome
  • Molecular Weights

Archives

  • August 2016
  • April 2016
  • March 2016
  • February 2016
  • January 2016
  • July 2015
  • June 2015
  • May 2015
  • April 2015
  • March 2015
  • February 2015
  • January 2015
  • December 2014
  • November 2014
  • October 2014
  • September 2014
  • August 2014
Blog at WordPress.com.
  • Follow Following
    • EXCELXOR
    • Join 217 other followers
    • Already have a WordPress.com account? Log in now.
    • EXCELXOR
    • Customize
    • Follow Following
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar