PDA

View Full Version : Formulas and Functions in Excel


  1. [SLEEPER:] Standard deviation of a subset in VBA
  2. [SOLVED:] vlookup across multiple column range
  3. [SOLVED:] Looking convert Number/Letter to a Number Only
  4. [SOLVED:] Convert the formula to a UDF
  5. [SOLVED:] Horizontal sum on rows on spilled table
  6. [SOLVED:] FILTER and extract a column
  7. [SOLVED:] GROUPBY() and PIVOTBY()