Hi in the excel sheet appended below, I am trying to randomly select a 7 cell range column wise from an array B1:M30 - (e.g.- B2:B9 ;F11:F18 etc ) and want to average the values for the output. So far, I have only managed to randomly select one cell.
Q: How do you randomly select a range from a big array column wise and average the values.
This is part of an analysis and is crucial. I have a deadline tomorrow am literally begging for help.
Thanks,
Rahul
[email protected]
Bookmarks