Join Dennis Taylor for an in-depth discussion in this video ADDRESS, ROW, and COLUMN functions, part of Excel Tips Weekly.
- [Voiceover] Excel has three functions related to…cell location: Address, Row, and Column.…And they're unusual, and you probably…won't need them very often, but occasionally…they can come in handy.…I'm looking at this list here, I certainly could…sort the list by Comp., but I want to keep it…in the current order.…I'm curious as to what the highest compensation amount is,…so I'll simply type, for example, in cell K2, =max,…meaning maximum or highest value, and rather than…highlighting the cells in column H, I'll simply…click column H and Enter.…And by the way, if you click column H, probably you're…seeing the same number down on the status bar,…provided you have these entries available.…
If you don't, you can right-click in in the status bar…and make sure these entries right here are checked.…You may not always want to keep these checked.…It just depends upon what you're interested in and…how you're using the status bar.…Nevertheless, when you highlight data,…and that includes clicking a column,…you're likely to see that entry down there.…
Note: Because this is an ongoing series, viewers will not receive a certificate of completion.
Skill Level Appropriate for all
Q: Why can't I earn a Certificate of Completion for this course?
A: We publish a new tutorial or tutorials for this course on a regular basis. We are unable to offer a Certificate of Completion because it is an ever-evolving course that is not designed to be completed. Check back often for new movies.
Excel Tips - New This Week
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.