Microsoft Microsoft excel 2007 full vers...

Hi guys, thought I had the right code for this but turns out it creates random number from numbers it should not be using. Sheet 1 is used and it works like I need.

Sheet 2

Column A - list of numbers 1 - 42 starting on row 3.

Column D - =COUNTIF(Sheet1!J3,">60") This works and if the number is >60 it puts a 1 in column D

Column C - =IF(D3,"1")*(Sheet1!A3). If column D is 1 on that row, it just takes the same number from Shee1!A3 and puts it here in Column C.Column E - the problem. Currently use code;

=INDEX($C$3:$C$44,RANDBETWEEN(1,ROWS($A$3:$A$44 )),1)It works but also generates random numbers from Column C that have a 0? When Column D,R3 etc is a 1, I want it to generate a random number in Column E3, but using ONLY the numbers 1-42 that has a 1 in Column D.

I have tried using =INDEX($A$3:$A$44,RANDBETWEEN(1,ROWS($A$3:$A$44 )),1) but kinda get the same results.

Ask Your Question

Weekly Poll

Do you think net neutrality will be repealed?

Discuss in The Lounge

Poll History