Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • Workdays – Across months DATE
  • State Abbr with Index+Match+Validation Data Validation
  • Recover the unrecoverable Excel User tips
  • MID + SEARCH to convert cell to rows MID
  • Compare2, a tool to compare two sheets using formulas Conditional Formatting
  • CTRL+Y a mini macro Excel User tips
  • When Excel tells you to go get some life Excel User tips
  • Calculate above and below me Average

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

  • Get 3rd Wednesday of month Basic Math
  • VALUE() of LEFT() Formulas - combined functions
  • Fixed length ID Formulas - combined functions
  • Expenses calendar, FaCal Basic Math
  • Jan8 date format AND
  • Week number to Month number DATE

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
  • BMI Calculator Basic Math
  • Sum of divide – Array formula Array formula
  • Search across sheets in function ADDRESS
  • When Excel functions are not enough Excel User tips
  • New function IFERROR, finally IFERROR
  • Excel Functions = XL f(x)s XLfxs
  • Middle name + 1st name Basic Math
  • Formula Beautifier Excel User tips

Copyright © 2026 Excel Functions.

Powered by PressBook News Dark theme