Previous Topic Next Topic

Filter rows in one sheet

Solved/Closed
gd - 29 Mar 2011 à 03:36
RWomanizer Posts 365 Registration date Monday 7 February 2011 Status Contributor Last seen 30 September 2013 - 29 Mar 2011 à 07:54
Hello,

I have large amounts of data in one work sheet(say it as Sheet1) and another worksheet(sheet2) has few records(100) which are also present in Sheet1.I am looking to seperate this few records in the Sheet1 from the rest.

Thanks in advance for your valuable suggestions and solutions.

2 responses

Réponse 1 / 2
RWomanizer Posts 365 Registration date Monday 7 February 2011 Status Contributor Last seen 30 September 2013 120
29 Mar 2011 à 06:13
use vlookup as

in columnE of sheet1 put the formula as

=VLOOKUP(A:A,Sheet2!A:A,1,FALSE)

for matching value you got the same no. and for unmatch you got #N/A

now filter the match value and copy to a new sheet,
gd
29 Mar 2011 à 07:01
Thank you very much.It works fine
RWomanizer Posts 365 Registration date Monday 7 February 2011 Status Contributor Last seen 30 September 2013 120
29 Mar 2011 à 07:54
its my pleasure to help you.
Réponse 2 / 2
RWomanizer Posts 365 Registration date Monday 7 February 2011 Status Contributor Last seen 30 September 2013 120
29 Mar 2011 à 04:52
use vlookup with reference to some unique values in both sheets,

kindly explain how the data looks like than we can help you more effectively.

put some part of data of both sheet
gd
29 Mar 2011 à 05:04
The data looks as
Sheet1
ColA-----ColB------ColC------ColD
1---------china-----90000----C9
2--------US---------10000----U10
3--------UK--------200000---U20
4-------Afric-------234---------A23
5-------asia--------456--------A45
Sheet2
ColA
3
5
result should be as
ColA--------ColB-----ColC-----ColD
3----------UK----------200000--U20
5---------asia---------456--------A45
The remaining 3 rows ie for 1,2,4 should be kept in another sheet or seperate from other two columns

Thank You for looking into it

Similar discussions

Copying data from one Excel sheet to another.
Remedial -
Kav -

30 responses