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])

1 Like

Excelent! :ok_hand: It worked perfectly.