The formula was wrong, see this new file. 2009/5/4 Fabio Lemos <flnle...@gmail.com>
> you could create a variable range name and use it in your formula... > > 2009/5/4 Satti Charvak <sat...@gmail.com> > > Prepare en excel sheet and send it back...your usage of the formula is not >> clear. >> >> On Mon, May 4, 2009 at 7:05 AM, Blank <blank.appa...@gmail.com> wrote: >> >>> >>> I am trying to get a random selection of a cell containing text, >>> basically: >>> >>> IF there is an empty cell in a column, get a random cell of data from >>> the range below it UNTIL the next empty cell. >>> >>> I have achieved this manually with the following formula: >>> >>> =INDEX(A2:A171,RANDBETWEEN(1,169)) >>> >>> The issues that I have with this are: >>> >>> 1. I have to manually select each range (tedious when I have a full >>> worksheet(s) of like data) >>> 2. I have to calculate the number of rows (ie. the 169 in the >>> example) so I don't grab from next groups range >>> >>> Does anyone know a better way to do this? >>> >>> Thanks for your assistance, >>> >>> Blank >>> >>> >>> -- >>> >>> Thanks and regards, >>> Satti Charvak >>> ____________________ >>> >>> >>> >>> > > > -- > Fabio L Lemos > > email: flnle...@gmail.com > > -- Fabio L Lemos email: flnle...@gmail.com --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
Book2.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
