Help needed..

  • Thread starter Thread starter sameer27p
  • Start date Start date
S

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)
 
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?
 
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
 
Back
Top