Skip first row for each group

[Link86]

Hi,

I am trying to skip the first row for each grouping in my data. How can I do this?

Example data:

Name	Data 1	Data 2
John	1	2
John	A	B
Mike	3	2
Mike	F	G

I want the formula to return A B for John and FG for Mike. It won't always be letters and numbers so a regex wont work.

Thank you

[Luke_C · Accepted solution]

Hi @Link86 

The sample tool can help here. You can set it to skip the 1st record and group by Name. See below configuration.

[Link86]

Can this be done with a multi field formula tool?

[Luke_C]

A multi-field formula tool would just apply a formula across multiple columns, so I don't think that achieves what you're looking for. You could probably use a multi-row formula tool to flag the first row for each name followed by a filter tool, but that seems like extra work compared to the sample tool.

[Link86]

Awesome, thank you.