Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula to use when number of rows changes dynamically | Excel Worksheet Functions | |||
Counting rows of blanks across certain columns | New Users to Excel | |||
Hiding Rows if the linked rows are blank | Excel Discussion (Misc queries) | |||
Row selections by row # OR by even/odd rows in another spreadsheet | Excel Discussion (Misc queries) | |||
Display selected rows from one worksheet to another | Excel Worksheet Functions |