Thread: Excel question
View Single Post
Old 09-21-2018, 03:50 PM
|B|rad |B|rad is offline
Join Date: Jul 2009
Posts: 1,048

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.17200 seconds with 9 queries