Thread
:
Formula Assistance for restricting the number of for analysis
View Single Post
05-02-2016, 11:28 PM
xor
Windows 10
Office 2016
Expert
Join Date: Oct 2015
Posts: 1,097
With your data in column A try this array formula:
=SUM(INDEX(A:A,LARGE(IF(ISBLANK(A1:A100),0,ROW(1:1 00)),10)):A100)
When entering the formula remember to hold down Ctrl and Shift before pressing Enter.
xor
View Public Profile
Find all posts by xor