Analyse dates within a group in a dataset

[h12]

Hi all

Below is the table for the analysis:

• There can be various numbers of 'people' (rows) within in each group (can range up to 200 rows per group)
• I want to be able to analyse per row within each group

Ask:

Within each group, I want to say

1. Oldest date column - identify the oldest date in each group and create a new column Oldest date
2. Analyse within each group if the search date is older than the oldest date column (e.g. 3 Nov is older than 17 Nov so an older date was found from within the group)
3. Where there is no individual search date,result should be cannot find search

Group	ID	Rank in each group	Invidual Search	Oldest date in the group	Result
A	ABC	1	17/11/2020	03/11/2020	Older date was found
A	CDE	2	17/11/2020	03/11/2020	Older date was found
A	EFG	3	03/11/2020	03/11/2020	No older date was found
B	HIJ	1			Cannot Find Search
B	ERT	2	27/10/2020	27/10/2020
C	FYU	1	02/07/2020	02/07/2020	No older date was found
C	SDV	2	21/01/2021	02/07/2020	Older date was found
C	BJY	3	21/10/2020	02/07/2020	Older date was found
C	GJY	4		02/07/2020	Cannot Find Search

[messi007]

@h12,

Please see below 

Attached the workflow,

Regards

[h12]

Thank you! You know where the search date is null , I would like the last column to say no search date, I think currently it brings through a date (row 4 in your screenshot)

[atcodedog05 · Accepted solution]

Hi @h12 

Here is my take on the usecase

Workflow:

Hope this helps : )

[h12]

Thank you! This is helpful. Is there anything that can be done with that blank cell?

[atcodedog05]

Hi @h12 

If you tell us the logic behind it we can help out.

[messi007 · Accepted solution]

@h12,

Here you go 

Attached the new version of the workflow

[h12]

Thank you both!

[atcodedog05]

Happy to help : ) @h12 
.

PS: you are allowed to mark multiple posts as solutions.

Cheers and have a nice day!