View Single Post
  #1   Report Post  
Demetrios13
 
Posts: n/a
Default how to display remaining rows as blanks

Hi, I would be very thankfull if anybody could help me with the following:

This is a simulation problem. According to a random generated number (using
the RAND() and the nested IF functions) the number of customers can be 10,
14, 18, 22.
I have a single worksheet of 22 customers (cell D4:D25). If # of customers
generated (in cell C4) is 10 how can I make it display only the first 10 rows
(customer 1 to 10 , D4:D13) and the remaining rows (11-22, D14:D25) to be
displayed as blanks. same goes for 14, 18 and 22 customers.

Thank you