LinkBack URL
About LinkBacks
Try
E4=OFFSET($A$3,MATCH($B$1,$A$4:$A$27,0),3,COUNTIFS($A$4:A4,$B$1)-10,)+IF(ISERROR(E3),0,E3)
Formula:
=OFFSET($A$3,MATCH($B$1,$A$4:$A$27,0),3,COUNTIFS($A$4:A4,$B$1)-10,)+IF(ISERROR(E3),0,E3)
Try
E4=OFFSET($A$3,MATCH($B$1,$A$4:$A$27,0),3,COUNTIFS($A$4:A4,$B$1)-10,)+IF(ISERROR(E3),0,E3)
Formula:=OFFSET($A$3,MATCH($B$1,$A$4:$A$27,0),3,COUNTIFS($A$4:A4,$B$1)-10,)+IF(ISERROR(E3),0,E3)
Last edited by shukla.ankur281190; 10-08-2015 at 06:41 AM.
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks