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])
Excelent! It worked perfectly.