Hi,
I have the following data where I need to return whether I am on the maximum row based on multiple criteria
I will have the formula in the formula column for each row in the example below with a TRUE or FALSE.
In the example below, I should see TRUE in Rows 2 and 15.
Basically for each unique identifier, I need to find the most recent start date and then for these most recent start dates, I need to find the row with the largest step.
I understand array formulas, but I cannot seem to get this to work - specifically for a subset of data.
RowId Identifier Start Date Step Formula
1 73643769 FALSE
2 73643769 2015-12-09 5 TRUE
3 73643769 2015-12-09 0 FALSE
4 73643769 2015-10-06 5 FALSE
5 73643769 2015-10-06 0 FALSE
6 73643769 2015-02-07 8 FALSE
7 73643769 2015-02-07 8 FALSE
8 73643769 2015-02-07 0 FALSE
9 73643769 2015-02-07 0 FALSE
10 73643769 8 FALSE
11 73643769 8 FALSE
12 73643769 8 FALSE
13 73643769 8 FALSE
14 12345678 2015-02-04 5 FALSE
15 12345678 2015-02-04 8 TRUE
16 12345678 2015-02-02 0 FALSE
17 12345678 8 FALSE
18 12345678 8 FALSE
I have the following data where I need to return whether I am on the maximum row based on multiple criteria
I will have the formula in the formula column for each row in the example below with a TRUE or FALSE.
In the example below, I should see TRUE in Rows 2 and 15.
Basically for each unique identifier, I need to find the most recent start date and then for these most recent start dates, I need to find the row with the largest step.
I understand array formulas, but I cannot seem to get this to work - specifically for a subset of data.
RowId Identifier Start Date Step Formula
1 73643769 FALSE
2 73643769 2015-12-09 5 TRUE
3 73643769 2015-12-09 0 FALSE
4 73643769 2015-10-06 5 FALSE
5 73643769 2015-10-06 0 FALSE
6 73643769 2015-02-07 8 FALSE
7 73643769 2015-02-07 8 FALSE
8 73643769 2015-02-07 0 FALSE
9 73643769 2015-02-07 0 FALSE
10 73643769 8 FALSE
11 73643769 8 FALSE
12 73643769 8 FALSE
13 73643769 8 FALSE
14 12345678 2015-02-04 5 FALSE
15 12345678 2015-02-04 8 TRUE
16 12345678 2015-02-02 0 FALSE
17 12345678 8 FALSE
18 12345678 8 FALSE