Random Sampling of Rows in Excel

[@dwarakid3663]

Excellent video ...thnxz so much ..i had to select random 50 from a data set of 3200 rows for analysis and your video helped me do that !! gr8 ..

[@awantisambarey5039]

This was really helpful, thank you!

[@reeyasingh54]

Really helpful, thanks.

[@jliebss_]

Clever! Thanks for the help.

[@sujesh.818]

Thank you

[@danishjain7445]

Hi how to Add All Transactions (DayBook) & Account books like sales register, Purchase register in excel from tally using power query ? It would be fantastic thing if this can be done. Please guide

[@ExcelKida]

DayBook cannot be added, as it is tree type of data, whereas Excel supports only tabular data
This approach suffers a limitation of static columns (column names are manually added via Power Query script). Sales/Purchase register report have dynamic columns

[@prempatel1501]

i have different 150 words in different cells and i want to select 15 from them how can i do this?

[@ExcelKida]

Solution: 150 / 15 = 10
Apply RANDBETWEEN(1,10) function in each row. Then just filter number 1, you will be left with 14 to 16 rows randomly selected in filter

[@prempatel1501]

@@ExcelKida can I do this in google sheets?

[@ExcelKida]

Yes you can. Google Sheet too has RANDBETWEEN function

[@MP-mp2fr]

tq