PDA

View Full Version : Formulas and Functions in Excel



  1. [SOLVED:] Receiving a False in ;If Function
  2. Multi value lookup
  3. [SLEEPER:] Standard deviation of a subset in VBA
  4. [SOLVED:] Searching for special characters
  5. Count of Records IF
  6. [SOLVED:] vlookup across multiple column range
  7. [SOLVED:] Transform count data date wise to Dates
  8. [SOLVED:] Looking convert Number/Letter to a Number Only
  9. [SOLVED:] Convert the formula to a UDF
  10. [SOLVED:] Horizontal sum on rows on spilled table
  11. [SOLVED:] FILTER and extract a column
  12. [SOLVED:] GROUPBY() and PIVOTBY()