Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • SimpleANBox Basic Math
  • Count cells with condition – multiple conditions COUNTIFS
  • CamelCase to Camel Case CHAR
  • Convert cell into textbox Excel User tips
  • LastSunday, LastSaturday Date and Time
  • Week number to Sunday date – Weeknum reverse DATE
  • Fx to cut long column into two columns Formulas - combined functions
  • Rotate table using 1 formula ADDRESS

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

  • iframe in Excel (XLiFrame) ADDRESS
  • Insert Blank rows into table using functions CHAR
  • Middle name + 1st name Basic Math
  • Sheet() and Sheets() Lookup and References
  • The Excel “&” bug Excel User tips
  • Multiple lines in cell using functions CHAR

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
  • CTRL+Y a mini macro Excel User tips
  • Searching table in 2 dimensions. Formulas - combined functions
  • Jan8 date format AND
  • Looplist – Repeating months using formulas Basic Math
  • Sum of divide – Array formula Array formula
  • Spreadsheet Compare application Excel User tips
  • Count Unique COUNTIF
  • Standard math to calculate Aspect Ratio Basic Math

Copyright © 2026 Excel Functions.

Powered by PressBook News Dark theme