Microsoft Office Forums - View Single Post - [Solved] Excel table: refer to a particular row?

tinfanide · 08-04-2015, 10:42 PM

Quote:

Originally Posted by gebobs

OK...I was able to kludge together a formula that does it and is sortable. See attached.

By the way, I'd like to ask

Code:

' no error
=COUNTBLANK(INDIRECT("Sheet2!"&ADDRESS(MATCH(A2,Table2[Name],0)+1,2)&":"&ADDRESS(MATCH(A2,Table2[Name],0)+1,4)))

' return #REF
=COUNTBLANK(INDIRECT("Sheet2!"&ADDRESS(MATCH(A2,Table2[Name],0)+1,2)&":"&"Sheet2!"&ADDRESS(MATCH(A2,Table2[Name],0)+1,4)))

' Sheet2!B2:D2 (1st formula's result)
' Sheet2!B2:Sheet2!D2 (2nd formula's result)
' They should be the same (as a range)