Hi! I have an array that contains values not text. I am trying to locate a formula(s) that will allow me to recognize the first column of each row that is not blank or is >0 and return the cell contents at the top of that column. HLookup won't get me there but it is the concept of what I want. Any help wouyld be appreciated.
Bookmarks