d2jsp
Log InRegister
d2jsp Forums > Off-Topic > Computers & IT > Asking Excel Question For Buddy, Any1 Know? > How To Do Easy Code In Excel?
Add Reply New Topic New Poll
Member
Posts: 15,942
Joined: Aug 11 2007
Gold: 8,221.76
Sep 3 2016 09:41am
"I'm playing around with an Excel spreadsheet and I cannot figure out something that I know is possible.

I want to be able to use a drop down on the left of my excel sheet that if I select "No" the equations below will not use that row of data
Yes 55 122
Yes 56 215
Yes 60 186
No 12 92
Yes 15 116
Range> 48 123


Yes 55 122
Yes 56 215
Yes 60 186
No 12 92
Yes 15 116
Range> 45 99


I've googled seemingly everything but cannot come up with an answer."
Member
Posts: 73,508
Joined: Aug 14 2007
Gold: 1,940.52
Sep 3 2016 09:50am
pivot table... lol
or a bunch of ifs
if you explain I'll try to help ya

This post was edited by Penguins0690 on Sep 3 2016 10:05am
Member
Posts: 15,942
Joined: Aug 11 2007
Gold: 8,221.76
Sep 3 2016 10:19am
Quote (Penguins0690 @ Sep 3 2016 11:50am)
pivot table... lol
or a bunch of ifs
if you explain I'll try to help ya


its for a buddy on another forum who asked. im not sure of the details
let me see if i can ask him

This post was edited by noob_whacker on Sep 3 2016 10:19am
Go Back To Computers & IT Topic List
Add Reply New Topic New Poll