↓ Skip to Main Content
Excelabcd

Main Navigation

  • Excel functions
    • Excel Functions
    • Exercise
      • COUNT Functions Exercise
      • SUM Functions Exercise
      • LOOKUP Functions Exercise
  • Excel Features
    • Protect Workbook
    • Hyperlink
    • Text to Columns
    • Freeze Panes
    • Conditional Formatting
    • Charts
    • PivotTable
    • Filter
    • Data Validation
    • Format Cells
  • Excel++
    • Shortcuts
    • 100+ formulas
    • Short Tips
    • Free Sample Excel Data
    • Excel Templates
      • Calculator Templates
      • Misc Templates
  • VBA
    • What is VBA?
    • Learn VBA step by step
    • Posts related VBA
  • Blog
  • Buy Resources
    • Buy Ebook
    • Buy Premium Templates
  • Excel Courses
    • Basic Excel Course
Excelabcd

Off Canvas Menu

  • Excel functions
    • Excel Functions
    • Exercise
      • COUNT Functions Exercise
      • SUM Functions Exercise
      • LOOKUP Functions Exercise
  • Excel Features
    • Protect Workbook
    • Hyperlink
    • Text to Columns
    • Freeze Panes
    • Conditional Formatting
    • Charts
    • PivotTable
    • Filter
    • Data Validation
    • Format Cells
  • Excel++
    • Shortcuts
    • 100+ formulas
    • Short Tips
    • Free Sample Excel Data
    • Excel Templates
      • Calculator Templates
      • Misc Templates
  • VBA
    • What is VBA?
    • Learn VBA step by step
    • Posts related VBA
  • Blog
  • Buy Resources
    • Buy Ebook
    • Buy Premium Templates
  • Excel Courses
    • Basic Excel Course

Tag: SMALL

Lesson#259: Using SMALL Function with IF Condition in Excel (Based on Groups)
Excel Funtions

Lesson#259: Using SMALL Function with IF Condition in Excel (Based on Groups)

Pushpendu Roy Karmakar Sep 5, 2025 Tagged with IF, SMALL

Excel is a powerful tool when it comes to analyzing datasets. Often, we need to extract the smallest value from a list, but not from the entire dataset—rather from a specific group of numbers that we define. This is where …

Lesson#259: Using SMALL Function with IF Condition in Excel (Based on Groups) Read more →

Short Tips#0053: Formulas by combining VLOOKUP, SMALL, LARGE
Excel short tips

Short Tips#0053: Formulas by combining VLOOKUP, SMALL, LARGE

Pushpendu Roy Karmakar Sep 2, 2018 Tagged with LARGE, SMALL, VLOOKUP

Short Tips#0033: Get Kth smallest value with SMALL function
Excel short tips

Short Tips#0033: Get Kth smallest value with SMALL function

Pushpendu Roy Karmakar Aug 8, 2018 Tagged with SMALL

Lesson#69: LARGE and SMALL function in Excel | Get the Kth largest or Kth Smallest
Excel Funtions

Lesson#69: LARGE and SMALL function in Excel | Get the Kth largest or Kth Smallest

Pushpendu Roy Karmakar Apr 22, 2018 Tagged with INDEX, LARGE, MATCH, SMALL

When you want to get the smallest or the largest number from an array then it’s just using the function MAX and MIN. But if you want to get the Kth largest or Kth smallest then there are more two …

Lesson#69: LARGE and SMALL function in Excel | Get the Kth largest or Kth Smallest Read more →

Microsoft365 for Business

AND CALCULATOR CHART CONDITIONAL FORMATTING COUNT COUNTBLANK COUNTIF COUNTIFS DATA VALIDATION DATE DAY FILTER FIND FORMAT CELLS HOUR IF IFERROR INDEX LEFT LEN MATCH MAX MID MIN MINUTE MOD MONTH NOT NOW PIVOTTABLE PROTECT SHEET recover RIGHT ROUND SECOND SHORTCUTS SUBSTITUTE SUM SUMIF SUMIFS TEXT TEXT TO COLUMNS TODAY VLOOKUP YEAR

Microsoft365 for Business

AND CALCULATOR CHART CONDITIONAL FORMATTING COUNT COUNTBLANK COUNTIF COUNTIFS DATA VALIDATION DATE DAY FILTER FIND FORMAT CELLS HOUR IF IFERROR INDEX LEFT LEN MATCH MAX MID MIN MINUTE MOD MONTH NOT NOW PIVOTTABLE PROTECT SHEET recover RIGHT ROUND SECOND SHORTCUTS SUBSTITUTE SUM SUMIF SUMIFS TEXT TEXT TO COLUMNS TODAY VLOOKUP YEAR

Footer Menu

  • Home
  • About
  • Contact
  • Privacy Policy

Footer Menu

  • Home
  • About
  • Contact
  • Privacy Policy
Copyright © 2026 Excelabcd | Powered by Responsive Theme
Copyright © 2026 Excelabcd | Powered by Responsive Theme
Loading…