Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

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 sector they are in, which is the same for each client...

 

I want to return the results of which business sector they are in - into table A and get only one instance....

 

Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    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

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    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

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      thanks Parker