Choosing a random text value from a list

0 votes

I have an Excel spreadsheet like this:

Checkbox Value
FALSE Value1
TRUE Value2
TRUE Value3
FALSE Value4

I want to create a list with FALSE values and choose a random text value from that list. For choosing random text value I tried using CHOOSE(RANDBETWEEN()) I tried to use IF(NOT(Checkbox), Value, "") but it gives empty cells, and I do not want that.

Apr 3 in Others by Kithuzzz
• 38,010 points
52 views

1 answer to this question.

0 votes

Try this:

=CHOOSEROWS(FILTER(B2:B100,A2:A100=FALSE),RANDBETWEEN(1,COUNTIFS(A2:A100,FALSE)))

enter image description here

answered Apr 3 by narikkadan
• 63,000 points

Related Questions In Others

0 votes
1 answer

How to retrieve the value of a text field in Flutter App?

Hi@akhtar, In your TextField, you can call one ...READ MORE

answered Sep 3, 2020 in Others by MD
• 95,440 points
1,274 views
0 votes
1 answer

How to select random value from iOS picker wheel using Selenium

Two ways to do this : Randomise the UIAPickerWheel[1] index ...READ MORE

answered Sep 21, 2022 in Others by rajatha
• 7,480 points
444 views
0 votes
1 answer

Excel delete row if column contains value from to-remove-list

Given sheet 2: ColumnA ------- apple orange You can flag the rows ...READ MORE

answered Nov 6, 2022 in Others by narikkadan
• 63,000 points
655 views
0 votes
1 answer

How to remove values from drop-down if value deleted from validation list

Try this code: Private Sub Worksheet_Change(ByVal Target As ...READ MORE

answered Dec 11, 2022 in Others by narikkadan
• 63,000 points
136 views
0 votes
1 answer

Calculate Monthly Highest Selling Product - MS Excel

Use a Pivot Table to summarize the ...READ MORE

answered Nov 12, 2022 in Others by narikkadan
• 63,000 points
340 views
0 votes
1 answer

Google Spreadsheet/ Excel - how to find matching values in column A, having necessary values in column M

Try this: =COUNTIF($M$2:$M$5;A2) If the product is present in ...READ MORE

answered Feb 10 in Others by narikkadan
• 63,000 points
98 views
0 votes
1 answer

Calculate Birthdate from an age using y,m,d in Excel

Hello, yes u can find your birthdate using ...READ MORE

answered Feb 16, 2022 in Others by Edureka
• 13,630 points
364 views
0 votes
1 answer

Calculate Birthdate from an age using y,m,d in Excel

Hi To Calculate the date, we can ...READ MORE

answered Feb 16, 2022 in Others by Edureka
• 13,630 points
678 views
0 votes
1 answer

Paste a value from a drop-down list

Check if there is an existing sheet ...READ MORE

answered Jan 14 in Others by narikkadan
• 63,000 points
137 views
0 votes
1 answer

Multiple find and replace in MS Word from a list in MS Excel

If I understand you correctly, you want ...READ MORE

answered Oct 28, 2022 in Others by narikkadan
• 63,000 points
193 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP