Ask Experts Questions for FREE Help !
Ask

excel conditional enable range disable range

Asked Nov 10, 2011, 10:56 PM — 5 Answers
i am trying to enable disable rows and exclude cells that are empty from the random counter code example:

Enable Rank Random Officer Name Output1
yes 23 0.440135354 4216 Leonardo Vela 1 steven ford
yes 7 0.74673831 4217 Donald Pudlowski 2 leonardo vela
13 0.659526727 4218 3 donald pudlowski
yes 24 0.424849358 4219 Steven Ford 4

this code is similar for each case
code : =RANK(C2,$C$2:$C$5) =RAND() =VLOOKUP(G2,B2:E5,4,0)

i need to modify if row three is not enabled in the output and automatically gets position last or after the enabled data

Search this Thread
Share |
5 Answers
JBeaucaire's Avatar
JBeaucaire Posts: 5,377, Reputation: 5036
Software Expert
  
#2

Nov 11, 2011, 07:37 AM


Can you post an actual workbook showing your current setup, then add a second sheet showing your desired results and explain them in the workbook in context?

Click GO ADVANCED and use the paperclip icon to post up a copy of your workbook.
Helpful
pcmann2004's Avatar
pcmann2004 Posts: 3, Reputation: 10
Junior Member
  
#3

Nov 11, 2011, 09:07 AM
Here's the Spreadsheet
Attached Files
File Type: xls askmehelpdesk.xls (29.0 KB, 33 views)
Helpful
JBeaucaire's Avatar
JBeaucaire Posts: 5,377, Reputation: 5036
Software Expert
  
#4

Nov 11, 2011, 12:26 PM


Here's how I would do that...
Attached Files
File Type: xls DutyRoster.xls (35.0 KB, 33 views)
Helpful  (1)
pcmann2004's Avatar
pcmann2004 Posts: 3, Reputation: 10
Junior Member
  
#5

Nov 12, 2011, 10:09 PM
WOW thats amazing, i will put this into my sheet and see if it works in my situation, can you define what you have done so i can understand the code better
Helpful
JBeaucaire's Avatar
JBeaucaire Posts: 5,377, Reputation: 5036
Software Expert
  
#6

Nov 15, 2011, 06:38 AM


Column C formula will only insert a randomized number if column A says "yes".

Column B will only rank that row if there is a "yes".

Column G will only show a number if it is less than the maximum number currently showing in column B.

Column H will only do a VLOOKUP() to match the Ranks and pull the name from column E if there is a visible number in column G.
Helpful
Not your question? Ask your question View similar questions
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search

Add your answer here.

Remove Text Formatting
 

Undo
Redo
  
Decrease Size
Increase Size
Bold
Italic
Underline
Align Left
Align Center
Align Right
Ordered List
Unordered List
Decrease Indent
Increase Indent
Insert Email Link
Wrap [QUOTE] tags around selected text
Wrap [CODE] tags around selected text
Wrap [HTML] tags around selected text
Wrap [PHP] tags around selected text
Wrap [YOUTUBE] tags around selected text
Notification Type:



Check out some similar questions!

Can I switch from electric range to gas range [ 5 Answers ]

I have an electric range but I need to buy a new one. I heard that cooking on a gas range is so much better. My husband pulled the range away from the wall and there is a little pipe sticking out of the wall. Is that for a gas stove? Thank you!

What are your long-range and short-range career goals and objectives, and how are you [ 1 Answers ]

Hello, What are your long-range and short-range career goals and objectives, and how are you preparing to achieve them?

Disable or Enable cell in Excel [ 1 Answers ]

How we disable or enable particular cell, sheet in excel

Changing from a gas range to an electric smooth top range [ 1 Answers ]

What are the requirement for switching from cooking with a gas stove to cooking with and electric stove

View more Spreadsheets questions Search