LinkBack URL
About LinkBacks
kai. 
Try
=SMALL(IF(([Test_book.xlsx]Sheet1!$E$3:$E$341="Pre-Approvals")+([Test_book.xlsx]Sheet1!$E$3:$E$341="In-Approvals"),ROW([Test_book.xlsx]Sheet1!$E$3:$E$341)),ROW(1:1))-2
Try
=SMALL(IF(([Test_book.xlsx]Sheet1!$E$3:$E$341="Pre-Approvals")+([Test_book.xlsx]Sheet1!$E$3:$E$341="In-Approvals"),ROW([Test_book.xlsx]Sheet1!$E$3:$E$341)),ROW(1:1))-2
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks