Hello,
Currently I am using "SOLVER" to iterate values (using a formula{Column G}) in a cell of a column (col G) to match it with the corresponding cell in the next column (col H). But I have numerous rows that I have to match and could not find a way to copy it for multiple rows. In other words, I have to iterate so that G2=H2, G3=H3, .... and so on. I need to get it done urgently. Any help is much appreciated. The excel file is attached.
Thanks
P_RO_100yr Calc.xlsx
Bookmarks