I am trying to get the highest value from an excel column. I know the following options exist
- Apply filter and sort in descending order and get the first value. but this would mean I need to convert the content in to a proper Table with a Table name to use the sort package.
- Execute the sorting using a macro.
Both the above are not possible in this case because, I will get this excel in a mail, and would like to automate from there upon downloading. So, I cant convert it to a Table with Table name in excel or have a macro in it without manually working on it, which I would like to avoid.
Is there a way to get it done from within Automation anywhere itself?