Hi, I am trying to skip the first row for each grouping in my data. How can I do this? Example data: NameData 1Data 2John12JohnABMike32MikeFG 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

Skip first row for each group

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

Help

Accepted answers

Luke_C

Hi @Link86

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

All comments

Luke_C

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.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703