Multi condition formula in a particular cell.

[sachinsg]

Hi Team,

I am having problem in updating a formula. Below are the snapshots. Cell E5 and E6 are null. and I need the formula as per snapshot 1 and 2.

Thank you.

[danilang · Accepted solution]

Hi @sachinsg 

I don't think you're asking this in the right place.  We can tell you how to get the results you're looking for in Alteryx(like the attached workflow that uses a Multi-row tool).  For Excel help, you'd be better off somewhere like MR Excel forums.  

Dan

[sachinsg]

Hi @danilang 

I am Sorry. This is my first post so I was not sure. Thanks for your help and it worked with little modification for last cell. I used multi row field twice and it worked.