Previous Topic Next Topic

Need Help in Excel

Closed
Mani - Jun 7, 2009 at 03:44 PM
mubashir aziz Posts 190 Registration date Sunday April 12, 2009 Status Member Last seen February 16, 2010 - Jun 7, 2009 at 11:54 PM
Hello,

I have two excel sheets with around 8000 columns in one sheets and 2000 columns in second sheet. All the columns of second sheets are taken from the first sheet. I have to create third excel sheet which should have missing numbers of second sheets.
Is there any formulae to do this fastly ???
Related:

1 response

Answer 1 / 1
mubashir aziz Posts 190 Registration date Sunday April 12, 2009 Status Member Last seen February 16, 2010 165
Jun 7, 2009 at 11:54 PM
Suppose you have data in Column A in Sheet 1 & Sheet 2 then use this formula in Sheet3 Cell A1 and drag it down .... ........



=IF(ISERROR(VLOOKUP(Sheet1!A1,Sheet2!A:A,1,FALSE)),Sheet1!A1,"")


0

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response
Removing " false" value in "IF"
JIN -
share -

10 responses