Thread: Excel question
View Single Post
Old 09-21-2018, 04:21 PM
Sredni Vashtar's Avatar
Sredni Vashtar Sredni Vashtar is online now
Join Date: Mar 2010
Favorite beer: pilseners
Posts: 8,196
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.
L’humour est la politesse du désespoir
Reply With Quote
Page generated in 0.17297 seconds with 9 queries