EXCELXOR

Advanced Excel Techniques with XOR LX

Main menu

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

Tag Archives: Extracting Data

October 7, 2014

Advanced Formula Challenge #7: Asterisk and Obelisk 17

Advanced Formula Challenges, Extracting Data • Tags: Advanced Formula Challenges, Extracting Data

The challenge this week is as follows: given a string in A2, return the single-word substring which immediately precedes the only occurrence within that string of a substring of the form XabcdY, where X and Y are either an asterisk or an obelisk and a, b, c and d are integers from 0 to 9.

For example:

Asterisk and Obelisk

More…

September 11, 2014

Advanced Formula Challenge #4: Missing Values 7

Advanced Formula Challenges • Tags: Advanced Formula Challenges, Extracting Data

The challenge this week is as follows: given the two lists of numbers in A2:A12 and B2:B12, generate the list as per the Results column, beginning in C2:

Picture1

A single formula should be placed in C2 such that, when copied down an arbitrary number of rows, generates the results as above.

More…

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
 

Loading Comments...