Find 2nd or 3rd Max/Latest Date in Excel using a Formula | MiTutorials

preview_player
Показать описание
Get 2nd or 3rd Max/Latest Date in Excel using a Formula | MiTutorials

Get Second or Third Max Date in Excel for a particular category in Excel using Formula

Find Second or Third Latest Date in Excel

Formula Used : =LARGE((($A$2:$A$9)*(--($B$2:$B$9=B2))),3)
  1. MITutorials
  2. Microsoft
  3. MS
  4. Excel
  5. Spreadsheet
  6. Help
Рекомендации по теме
Find 2nd or 0:04:44

Find 2nd or 3rd Max/Latest Date in Excel using a Formula | MiTutorials

Lec-70: Find Nth(1st,2nd,3rd....N) 0:12:54

Lec-70: Find Nth(1st,2nd,3rd....N) Highest Salary in SQL | Imp for Competitive & Placement exam

SQL Find 2nd 0:07:17

SQL Find 2nd 3rd 4th 5th Nth Highest Salary Query

Excel Find 0:03:39

Excel Find Earliest Date and Latest Date

SQL Query to 0:05:46

SQL Query to find 2nd or 3rd highest salary of employee || SQL Query Interview Question

8| SQL Tutorial| 0:08:23

8| SQL Tutorial| How to find second, third highest salary using SQL queries

SQL Most Asked 0:07:31

SQL Most Asked Interview Question Find 2nd 3rd 4th 5th Nth Maximum & Minimum Salary Query

Find nth highest 0:12:49

Find nth highest salary in sql server | sql query to find 2nd, 3rd highest salary

How to find 0:04:10

How to find second highest salary in SQL

MS Excel: Max 0:00:55

MS Excel: Max Vs Large function | Finding Maximum, 2nd Maximum, 3rd and Kth Maximum Value

#SQL Interview Question 0:06:22

#SQL Interview Question -Second highest salary using dense rank analytical function || 3rd highest

Find 2nd Highest 0:06:28

Find 2nd Highest salary in SQL | Find 3rd Highest Salary in SQL | Find Nth Highest Salary in SQL

How to find 0:06:31

How to find 1st, 2nd, 3rd and nth maximum salary using CTE in Ms SQL

Query To Find 0:05:07

Query To Find Nth Highest Salary In SQL | SQL Interview Question

SQL Query to 0:05:14

SQL Query to Find Nth Highest Salary Using Dense Rank Function

Without using Array 0:03:17

Without using Array : Find First Max, Second Max and Third Max from N Nos in C

find 1st , 0:00:39

find 1st , 2nd and 3 max number from Array of Integer

How to find 0:06:39

How to find 2nd or nth highest salary in SQL using Rank and Dense_Rank function | Techie Creators

How to Find 0:03:00

How to Find 3rd Max Salary in SQL

SQL Query to 0:07:30

SQL Query to find 2nd highest, 3rd highest and Nth highest salary using Sub Queries

SQL Query to 0:05:57

SQL Query to find Nth highest salary in Oracle using ROW_NUMBER function?

Query to find 0:05:18

Query to find Nth highest salary in SQL | Most asked SQL interview Question

Write the SQL 0:06:27

Write the SQL statement to find the 2nd & 3rd maximum salary of an employee

How to find 0:01:57

How to find the Nth highest salary ? using DENSE_RANK( )

Комментарии
Автор

Super helpful, searched all over the place, exactly what I was looking for. Thanks!!!

MitDesa
Автор

Wow. This is what exactly I was looking for

florinemartis
Автор

Can you provide the same formula but with 2 criteria's?

NicolaDereham
Автор

HI. Take in mind this really doesn't work because if for example you put the 4th most recent date in your example, the formula will throw 6/01/17 again because it is in the 4th position of the column. In other words, it won't recognize repeated dates. So this will only work if there are no repeated dates.

santiagoschlesinger