Get the last row index of particular duplicate value

Help Studio
1

I am trying to get the last row index of col1=“data” and col2=“computer”.
image

2

you can make use of Index property of “For each row” activity
test2.xaml (8.0 KB)

image

3

Thank you for reply.
But I want last row index of all duplicates values because I have to put the sum of all duplicates values in it.

image

4

Excel:
test.xlsx (9.5 KB)
Solution:
test2.xaml (15.7 KB)

example 1:
input
image

output (sheet2)
image

Example 2
input
image
output (Sheet2)
image

5

@Shivani_Sarkale
Welcome to the Forum

Have a look here

WE can do with a LINQ or classical AS mentioned in First approach

6

Thank you. @jack.chan
Its Working now.

1 Like
7

Thank you @ppr

8

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.