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

Quote:
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.11231 seconds with 9 queries