Help needed..

[sameer27p]

I wish to delete the empty rows after finding the common items.Ca
anyone tell me how to delete the blank rows,so that the common item
begin from row 1 itself ?


=IF(ISNA(VLOOKUP(RawMatlIssued!A$2:A$638,PlannedInventoryTransactions!A$2:A$30,1,FALSE)),"",VLOOKUP(RawMatlIssued!A$2:A$638,PlannedInventoryTransactions!A$2:A$30,1,FALSE)

 

[Frank Kabel]

Hi
you may use 'Data - filter - autofilter' and delete the filtered rows
manually. For a macro solution see:
http://www.cpearson.com/excel/deleting.htm#DeleteBlankRows

 

[Aladin Akyurek]

An efficient formula setup is also possible... Since the formula that you
use compares the longer list, RawMatlIssued!A$2:A$638, with a smaller list,
PlannedInventoryTransactions!A$2:A$30, there will possibly be duplicates. Do
you want the duplicates appear in the list which must be trimmed off blanks?

 

[sameer27p]

Thanks for that... I really appreciate your help...

I had another question.I have a column named ItemNos..this colum
contains item numbers.Now,after every item number ,i need to inser
three rows containing the text value 'Actual','Forecast' AND 'Variance
in the same column..this shud however go until the range of the ite
nos..since sometimes the report spools 15 rows while at other times i
may spool 15000 rows...

Item Number
A
F
V
Item Number
A
F
V