View Single Post
 
Old 08-04-2015, 07:37 AM
tinfanide tinfanide is offline Windows 7 64bit Office 2010 32bit
Expert
 
Join Date: Aug 2011
Posts: 312
tinfanide is on a distinguished road
Default

Quote:
Originally Posted by gebobs View Post
OK...I was able to kludge together a formula that does it and is sortable. See attached.
Yes. While using MATCH to get the absolute row numbers, I was thinking of how to reference using those row numbers with Table. Your use of ADDRESS and INDIRECT is really insightful.

Many thanks for your help!
Reply With Quote