Quote:
Originally Posted by gebobs
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!