Hi to all Experts!
// problem:
I have two sheets:
- sheet#LIST (col1-ID, col2-QUANTITY, col3-PRICE)
- sheet#STOCK (col1-ID, col2-QUANTITY, col3-PRICE)
In a sheet #STOCK I manually type all data.
What I want from sheet#LIST is to display all data in a rows from
sheet#STOCK only if second column (QUANT.) is not empty.
I managed to do this with a formula:
=IF(STOCK!$B2<0,STOCK!$A2,\"\")
but,
I don't want Excel to display blank rows as a result.
I want to fill first next row with available data.
I attached file with this post to make a picture more clear.
CHEERS :)
+-------------------------------------------------------------------+
|Filename: SKIP_BLANK_ROWS.zip |
|Download:
http://www.excelforum.com/attachment.php?postid=5254 |
+-------------------------------------------------------------------+
--
shone
------------------------------------------------------------------------
shone's Profile:
http://www.excelforum.com/member.php...o&userid=35126
View this thread:
http://www.excelforum.com/showthread...hreadid=574138