Hello - I am looking to extract the (red) circled value from this excel (as well as a folder containing similar files). Because this is not in tubular form I am having trouble creating data tables and subsequently filtering/lookup/etc. For each of the files, the common words in the row that I would like to extract the value from is ‘distribution’ and ‘owner*’. The value that i would like to extract in that row will be the only numeric amount in that row. Does anyone have any ideas of what activities I can use?
Use Find/Replace Value activity to find Distribution to Ownership Cash Account value in your excel sheet.
This will return you a Cell where this value is. From this range extract the Row number and iterate the columns one by one till you find non empty cell.
Thank you all. I ended up requesting the vendor send me the data in a tubular format so that I could easily pull the data. I appreciate all of your help!
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.