I need your support to find the rank considering below

1. PO Number
2. Group
3. Start date

In this need to calculate a different rank for all PO separately and also Need to pick the rank based on n the date but need to consider PO and Group separately

The result need to come as showing the number in Rank (Column D) Jan 23 in Others 60 views

## 1 answer to this question.

```=LET(d,   A4:C18,
a,   INDEX(d,,1),
b,   INDEX(d,,2),
c,   INDEX(d,,3),
MAP(      SEQUENCE(ROWS(d)),
LAMBDA(   r,
SUM((a=INDEX(a,r))*(b=INDEX(b,r))*(c<=INDEX(c,r))))))
```

This will be easier to maintain if your range changes. All you need to do is expand the range d.

• 60,820 points

## How to expend the code to transfer data from one spreadsheet to another based on multiple criteria

The progress bar is unnecessary. Option Explicit Sub VTest2() ...READ MORE

## How to install a GUI on Amazon AWS EC2 or EMR with the Amazon AMI

The top-level script for installing the GUI ...READ MORE

## Excel formula to average selected cells based on certain criteria

Try: =AVERAGE(IF(X:X=A1,Z:Z)) With Ctrl+Shift+Enter. READ MORE

## Calculate Birthdate from an age using y,m,d in Excel

Hi To Calculate the date, we can ...READ MORE

## Convert Rows to Columns with values in Excel using custom format

1 I having a Excel sheet with 1 ...READ MORE

## IF - ELSE IF - ELSE Structure in Excel

In this case, you can use nested ...READ MORE