List array using one table

Can anyone help me find a formula to get column 3 using only one table

Hi @Adalberto_Santos_de_los_Santos - can you tell me more about Column 3. Is what you want to populate in there based on Column 1 and 2 and if so what is the pattern?

I’m trying to control and manage a Sheep Production Inventory.
Maybe this will help. I’m trying to find the brothers of each lamb

That makes so much more sense. Try this formula - thisTable.Filter(thisRow.[Column 2]=[Column 2])

https://cl.ly/0l2x3G3Y3N0o/Image%202018-07-24%20at%202.39.23%20PM.png

1 Like

Excelent! :ok_hand: It worked perfectly.
Thanks