Thread
:
Randomly selecting a cell weighted on percentage
View Single Post
#
5
Posted to microsoft.public.excel.programming
Max
external usenet poster
Posts: 9,221
Randomly selecting a cell weighted on percentage
Errata (wrong source sheetname used earlier):
In A2 should be:
=IF(COLUMN()COUNT($1:$1),"",INDEX(Sheet1!1:1,MATC H(SMALL($1:$1,COLUMN()),$1:$1,0)))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
Reply With Quote
Max
View Public Profile
Find all posts by Max