From the course: Excel Tips Weekly

Unlock this course with a free trial

Join today to access over 22,400 courses taught by industry experts.

ADDRESS, ROW, and COLUMN functions

ADDRESS, ROW, and COLUMN functions - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

ADDRESS, ROW, and COLUMN functions

- [Instructor] Excel has three functions 2 related to cell location: address, row and column. 3 And they're unusual, and you probably won't need them 4 very often, but occasionally they can come in handy. 5 I'm looking at this list here. 6 I certainly could sort the list by comp, 7 but I want to keep it in the current order. 8 I'm curious as to what the highest compensation amount is. 9 So I'll simply type, for example, in cell K2 equal max, 10 meaning maximum or highest value. 11 And rather than highlighting the sales in column H, 12 I'll simply click column H and enter. 13 And by the way, if you click column H, probably, 14 you're seeing the same number down on the status bar, 15 provided you have these entries available. 16 If you don't, you can right click on the status bar 17 and make sure these entries right here are checked. 18 You may not always want to keep these checked. 19 Just depends upon what you're interested in, 20…

Contents