Thread: Excel question
View Single Post
Old 09-21-2018, 05:21 PM
Sredni Vashtar's Avatar
Sredni Vashtar Sredni Vashtar is offline
Join Date: Mar 2010
Favorite beer: pilseners
Posts: 7,183
Blog Entries: 1

Originally Posted by |B|rad View Post
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)
I agree with this...

I assume the OP wants a way that's less janky than a vlookup a random azz word.
But sometimes that's just how the data rolls.
Sredni Vashtar went forth,
His thoughts were red thoughts and his teeth were white.
His enemies called for peace, but he brought them death.
Sredni Vashtar the Beautiful.
Reply With Quote
Page generated in 0.08433 seconds with 9 queries