Hi, I am working on a dataset where in I have to apply some formula using Multi row to fetch the result
In the image attached,
I want to apply formula wherein, if Row 1 and Row 2 of column A are both same, then the empty field of Column B should have same data that is in Row 2 of Column B which is “SAP096543”
Any help on this?
@Tid14 One way of doing this
@Tid14 Another method attached
Hi @Raj can you please send me screenshot of the WF attached. i am not able to download it.
thanks in advance :)
You might want to consider a different approach. I'm not certain if this will be it since I don't know your data, but this method will identify all of the associated columnA records and fill in columnB without needing a multi-row tool. Also, you may end up with more than one record that would match requiring several multi-row formula tools to get everything correct. This would eliminate that need. It may need adjustments based on your actual data though.
Summarize tool config: