Thread: Forumla in excel that totals and displays name
View Single Post
 
Old 11-15-2018, 06:27 PM
jeffreybrown jeffreybrown is offline Windows Vista Office 2007
Expert
  
Join Date: Apr 2016
Posts: 673
jeffreybrown has a spectacular aura aboutjeffreybrown has a spectacular aura about
Default
On tab total in A3...

=IFERROR(INDEX(Sheet1!$A$2:$A$38,SMALL(IF(Sheet1!$ H$2:$H$38>3,ROW(Sheet1!$A$2:$A$38)-ROW(Sheet1!$A$2)+1),ROWS($A$2:A2))),"")

IMPORTANT
  • This is an array formula
  • Enter the formula >> press F2 then >> CTRL + SHIFT + ENTER
  • If entered correctly, the formula will be enclosed in {brackets}
  • Do not enter the {brackets} manually

On tab total in B3...

=IF(A3<>"",VLOOKUP(A3,Sheet1!$A$2:$H$4,8,0),"")

Highlight A3:B3 and drag down as you need
Reply With Quote