Forum Discussion
Excel Formulas - Searching the address of the max ABS formula result
Hi, I have a cell that contains a formula (max absolute value) taken from a range of cells with multiple rows and columns. In another cell, I am trying to find out the value in longitudinal ...
I think it is a complicated if only use formular to fulfill. But combine with Power Automation it will be easy.
Use Formular to find the MaxAbs value to a identified cell.
PA will read the text in this cell.
Then find the location in the range you need to search with the row and column number, for example row number =4 and column number =10.
Then request PA to read the text in row 4 column1 (A4) and row 3 column 10 (J3) back to you.
Also, if you have many sheets, it also will help you to read all sheets name and check it one by one if you set a loop.
Use Formular to find the MaxAbs value to a identified cell.
PA will read the text in this cell.
Then find the location in the range you need to search with the row and column number, for example row number =4 and column number =10.
Then request PA to read the text in row 4 column1 (A4) and row 3 column 10 (J3) back to you.
Also, if you have many sheets, it also will help you to read all sheets name and check it one by one if you set a loop.