Forum Discussion
One to Many Formula to return first instance
Hi Experts I have two tables A and B. In table A i have unique instance of the values (client names) in table b i have multiple instance of the client names and multiple instance of the business ...
Hey Anonymous
The FIRSTNONBLANK function should work nicely. It's syntax is FIRSTNONBLANK(Table[Column],1). The ",1" is important to not throw an error.
Hope this helps,
Parker
Hey Anonymous
The FIRSTNONBLANK function should work nicely. It's syntax is FIRSTNONBLANK(Table[Column],1). The ",1" is important to not throw an error.
Hope this helps,
Parker
thanks Parker