Thread: Excel question
View Single Post
  #6  
Old 09-21-2018, 04:50 PM
|B|rad |B|rad is offline
Member
CAS
 
Join Date: Jul 2009
Posts: 1,030
Default

Why cant you just combine the two columns you've suggested already?

column C = IF(A2="Total","",B2/VLOOKUP("Total", $A2:$B$1000**, 2, FALSE))

or who cares about 100%'s next to totals?:
column C = B2/VLOOKUP("Total", $A2:$B$1000**, 2, FALSE)
Reply With Quote
 
Page generated in 0.17856 seconds with 9 queries