User Profile
ntnylns
Copper Contributor
Joined Nov 12, 2023
User Widgets
Recent Discussions
Re: maintaining a cell reference despite changing the cell location through sorting
BerlinerTourGuide If you are looking for say the second largest value of a group, there is the LARGE function. https://www.excelchamp.net/finding-the-second-largest-value-in-excel/#:~:text=%3DLARGE(A1%3AA5%2C,largest%20value%20from%20the%20array. But, the fail-safe way is to use INDIRECT, example =INDIRECT("A1"), as noted here: https://superuser.com/questions/1390320/is-there-a-way-to-absolute-the-referred-or-target-cell21KViews0likes0Comments
Recent Blog Articles
No content to show