Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • Highlight dates dynamically AND
  • CountIf limitation COUNTIF
  • Convert 2-column into wide (column-row) table Formulas - combined functions
  • Cells with additional spaces AND
  • Worksheet name, dynamically using formula CELL
  • Text-to-Columns, dynamically using formulas IFERROR
  • Stale values (Scratched functions) Excel User tips
  • Change Calculator – calculate change in multiple bills/coins Formulas - combined functions

Min Max vehicle

Posted on July 20, 2022 By ANmar

Finding which vehicle with minimum (or maximum) amount of savings among peers.

This is an old request, found its formula in my archive to calculate which of the 4 columns is actually has the minimum (or maximum) of savings among other columns.

Trick is as you guessed it was OFFSET.

Excel Online
Download
Formulas - combined functions, Lookup and References, MATCH, Math and Trig, MAX, Min, OFFSET, Standard functions Tags:MATCH, MAX, MIN, OFFSET

Post navigation

Previous Post: Shapes with dynamic output
Next Post: Search across sheets in function

Related Posts

  • FORMULATEXT to show formulas FORMULATEXT
  • Standard math to calculate Aspect Ratio Basic Math
  • Tally chart in functions Formulas - combined functions
  • Multiple lines in cell using functions CHAR
  • CountIf limitation COUNTIF
  • State Abbr with Index+Match+Validation Data Validation

Recent Posts

  • Stale values (Scratched functions)
  • Middle name + 1st name
  • LastSunday, LastSaturday
  • Paste Special Percentage
  • Jan8 date format

Archives

Categories

  • Array formula (1)
  • Formulas – combined functions (58)
  • Google Sheets (2)
  • Non-functions (36)
    • ActiveX controls (2)
    • Conditional Formatting (7)
    • Data Validation (7)
    • Excel User tips (19)
    • Format Cells (6)
    • Graphics (4)
    • Names (3)
  • Standard functions (82)
    • Basic Math (18)
    • Date and Time (16)
      • DATE (9)
      • Hour (1)
      • MONTH (7)
      • NETWORKDAYS (2)
      • TODAY (7)
      • WEEKDAY (8)
      • WEEKNUM (1)
      • YEAR (8)
    • Engineering (1)
      • CONVERT (1)
    • Information (6)
      • CELL (4)
      • ISERROR (1)
      • N (1)
    • Logical (30)
      • AND (5)
      • IF (24)
      • IFERROR (6)
      • IFNA (1)
      • IFS (1)
      • ISERROR (1)
      • OR (2)
    • Lookup and References (36)
      • ADDRESS (4)
      • CHOOSE (3)
      • COLUMN (7)
      • FORMULATEXT (1)
      • HLOOKUP (1)
      • HYPERLINK (2)
      • INDEX (5)
      • INDIRECT (6)
      • MATCH (12)
      • OFFSET (15)
      • ROW (11)
      • VLOOKUP (5)
    • Math and Trig (24)
      • ABS (1)
      • CEILING (1)
      • COUNT (1)
      • COUNTA (4)
      • INT (9)
      • LARGE (2)
      • MAX (1)
      • Min (2)
      • SMALL (3)
      • SUM (3)
      • SUMIF (1)
      • SUMIFS (2)
      • SUMPRODUCT (1)
    • Statistical (5)
      • COUNTIF (4)
      • COUNTIFS (1)
    • Texts and Strings (24)
      • CHAR (5)
      • CONCATINATE (1)
      • FIND (1)
      • LEFT (8)
      • Len (4)
      • MID (9)
      • REPT (3)
      • RIGHT (2)
      • SEARCH (9)
      • STRING (1)
      • SUBSTITUTE (2)
      • TEXT (4)
      • TRIM (2)
      • VALUE (2)
  • Uncategorized (2)
  • User-Defined f(x)s = UDF (3)
    • HyperlinkOf (1)
  • Worksheet (16)
  • XLfxs (2)

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org
  • Rotate table using 1 formula ADDRESS
  • Excel Functions = XL f(x)s XLfxs
  • Always get 1st name (or last) Formulas - combined functions
  • Search across sheets in function ADDRESS
  • MID + SEARCH to convert cell to rows MID
  • Worksheet name, dynamically using formula CELL
  • Searching table in 2 dimensions. Formulas - combined functions
  • DayName Date and Time

Copyright © 2026 Excel Functions.

Powered by PressBook News Dark theme