Multi row formula increment by grouping

[QurrathAmeena]

Hi all,

For the following sample data I'm trying to perform following operations:

1.Group the data on basis of col1 ,col 4 and col2 and the second part of OP is updated and incremented accordingly.

2. Group the data on basis of col1 , col3 ,col5 and the first part of OP is updated and incremented accordingly

col1	col2	col3	col4	col5	op
Bottle	A	S	06-07-2016	09-06-2018	S1||A1
Bottle	A	S	06-07-2016	09-06-2019	S1||A2
Bottle	A	S	08-09-2018	18-05-2020	S2||A1
Cup	Q	A	12-15-2011	01-11-2014	A1||Q1
Cup	Q	A	12-15-2011	01-11-2015	A1||Q2
Cup	R	A	12-9-2015	08-07-2011	A1||R1

When I tried it with multi-row formula its treating each row as a new case and incrementing it accordingly, so despite my best efforts, I have been unable to complete the first part of the OP using the sample data provided above.

Could anybody help me resolve the issue ?

Thanks in advance 

[QurrathAmeena]

Hi @DataNath ,

That's exactly what I was looking for ! Thank you so much !