Pick the value after last comma

[Sshasnk]

Hi I have a dataset where I have check if the last value meets below criteria I have to put it in a new column

Input:

F1

1.00,ABC,456,74589EXB9

1.67,0.00

1.45,EUR

,,,,

1.23,567,987521EX0

516,AEV,1.23

Condition:

1. Last value should not be in decimal

2. last value is length should be greater than 3

4. If all above condition I have to copy the id and paste it below till I get a new ID

Output:

F1	ID
1.00,ABC,456,74589EXB9	74589EXB9
1.67,0.00	74589EXB9
1.45,EUR	74589EXB9
,,,,	74589EXB9
1.23,567,987521EX0	987521EX0
516,AEV,1.23	987521EX0

So first row meet the condition, So pasted in the ID column till I get a new ID from F1 column

[echuong1]

You can use Regex to parse out the part of the string you'd like, and then a multi-row formula to "drag down" the values to fill in those that are missing or contain decimals.

See attached for example.