Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • Tally chart in functions Formulas - combined functions
  • Comments versus Notes Excel User tips
  • Convert 2-column into wide (column-row) table Formulas - combined functions
  • Sorting with functions only CHOOSE
  • SimpleANBox Basic Math
  • The Excel “&” bug Excel User tips
  • Hello world! Uncategorized
  • Progress bar in pure functions CHAR

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

  • Cuts string of list of items Formulas - combined functions
  • Fx to cut long column into two columns Formulas - combined functions
  • CamelCase to Camel Case CHAR
  • MID + SEARCH to convert cell to rows MID
  • Expenses calendar, FaCal Basic Math
  • SimpleANBox Basic Math

Recent Posts

  • Calculate above and below me
  • Stale values (Scratched functions)
  • Middle name + 1st name
  • LastSunday, LastSaturday
  • Paste Special Percentage

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 (83)
    • 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 (31)
      • AND (5)
      • IF (25)
      • IFERROR (7)
      • 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 (6)
      • Average (1)
      • 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
  • Excel Limits Excel User tips
  • Calculate hours between two cells ABS
  • Get column name (columnname as A,B,C, etc) as input inside cell ADDRESS
  • Week number to Sunday date – Weeknum reverse DATE
  • Expenses calendar, FaCal Basic Math
  • Multiple-Validations (connected to each other) Data Validation
  • FORMULATEXT to show formulas FORMULATEXT
  • MATCH fumction, just a simple search Lookup and References

Copyright © 2026 Excel Functions.

Powered by PressBook News Dark theme