I ran into a problem that I couldn't solve. Suppose we have a table:
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 20 | SHOP | PSU NAME | POWER | W/USD | LINK | PRICE |
| 21 | abc | abc | number | number | link | number |
| 22 | abc | abc | number | number | link | number |
| 23 | abc | abc | number | number | link | number |
| 24 | abc | abc | number | number | link | number |
And I would like to find MAX value in range D21:D24 and then get link (cell next to this max value) and display it in other cell. Finding MAX value of D column is easy, but I don't know how to "move" to other cell after that.
Best Answer
By 'but I don't know how to "move" to other cell after that.' I mean, that I don't know how to get cell's adrress.