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
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
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
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 ..
This was really helpful, thank you!
Really helpful, thanks.
Clever! Thanks for the help.
Thank you
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
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
i have different 150 words in different cells and i want to select 15 from them how can i do this?
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
@@ExcelKida can I do this in google sheets?
Yes you can. Google Sheet too has RANDBETWEEN function
tq