Forum Discussion
callred
Sep 13, 2022Copper Contributor
Need Help With Excel Formula Adding Rows
I'm creating a calculator that will assist me figuring out student graduation dates. However, I'm struggling to find a formula that will count the number of rows based on the data from the table and ...
SergeiBaklan
Sep 13, 2022Diamond Contributor
You may find position of final term in term list, position of the current term and subtract one from another. Something like
=MATCH( <ref on cell with final term> , < terms list >, 0 ) -
MATCH( <ref on cell with current term> , < terms list >, 0 )