↓ 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
Short Tips#0054: Formula to find closest value in an array from lower side
Excel short tips

Short Tips#0054: Formula to find closest value in an array from lower side

Pushpendu Roy Karmakar Sep 2, 2018 Tagged with IF, MAX

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#0052: Count cells of an array
Excel short tips

Short Tips#0052: Count cells of an array

Pushpendu Roy Karmakar Sep 2, 2018 Tagged with COLUMNS, ROWS

Short Tips#0051: How to make cumulative sum
Excel short tips

Short Tips#0051: How to make cumulative sum

Pushpendu Roy Karmakar Sep 2, 2018 Tagged with SUM

Short Tips#0050: Functions MODE and MODE.MULT
Excel short tips

Short Tips#0050: Functions MODE and MODE.MULT

Pushpendu Roy Karmakar Sep 2, 2018 Tagged with MODE, MODE.MULT

Short Tips#0049: Formula to separate first name and last name
Excel short tips

Short Tips#0049: Formula to separate first name and last name

Pushpendu Roy Karmakar Sep 2, 2018 Tagged with FIND, LEFT, LEN, RIGHT

Short Tips#0048: How to type in multiple sheets at one time
Excel short tips

Short Tips#0048: How to type in multiple sheets at one time

Pushpendu Roy Karmakar Sep 2, 2018 Tagged with SHORTCUTS

Short Tips#0047: How to write same value in multiple cells at once
Excel short tips

Short Tips#0047: How to write same value in multiple cells at once

Pushpendu Roy Karmakar Sep 2, 2018 Tagged with SHORTCUTS

Short Tips#0046: Some useful shortcuts
Excel short tips

Short Tips#0046: Some useful shortcuts

Pushpendu Roy Karmakar Sep 2, 2018 Tagged with SHORTCUTS

Short Tips#0045: Selection Shortcuts
Excel short tips

Short Tips#0045: Selection Shortcuts

Pushpendu Roy Karmakar Sep 2, 2018 Tagged with SHORTCUTS

Posts pagination

Previous 1 … 20 21 22 23 24 … 37 Next
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…