Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • Shades of gray Graphics
  • LastSunday, LastSaturday Date and Time
  • Get 3rd Wednesday of month Basic Math
  • Schedule column Basic Math
  • Compare2, a tool to compare two sheets using formulas Conditional Formatting
  • Search across sheets in function ADDRESS
  • IFS (and IFNA) to avoid nested IFs Formulas - combined functions
  • WorksheetName and WorksheetsNo UDFs Lookup and References

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

  • Dynamic selection list ActiveX controls
  • Fx to cut long column into two columns Formulas - combined functions
  • Fixed length ID Formulas - combined functions
  • GoLast to jump to last cell in a column CELL
  • DayName Date and Time
  • Week number to Sunday date – Weeknum reverse DATE

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
  • Dynamic selection list ActiveX controls
  • OFFSET+MATCH Formulas - combined functions
  • Get 3rd Wednesday of month Basic Math
  • Progress bar in pure functions CHAR
  • Why I ran from =INDIRECT() function Formulas - combined functions
  • Extract Address into table Formulas - combined functions
  • Multiple Dual-Validations COUNTA
  • Shapes with dynamic output Excel User tips

Copyright © 2025 Excel Functions.

Powered by PressBook News Dark theme