Filter rows in one sheet
Solved/Closed
gd
-
Mar 29, 2011 at 03:36 AM
RWomanizer
RWomanizer
- Posts
- 365
- Registration date
- Monday February 7, 2011
- Status
- Contributor
- Last seen
- September 30, 2013
Related:
- Filter rows in one sheet
- Excel if cell contains text then copy row to another sheet ✓ - Forum - Excel
- Excel copy row to another sheet based on cell value without macro ✓ - Forum - Excel
- Copy rows to other sheets based on value in column ✓ - Forum - Excel
- Google sheets move row to another sheet based on cell value ✓ - Forum - Excel
- Excel copy rows from one sheet to another based on criteria - Forum - Excel
2 replies
RWomanizer
Mar 29, 2011 at 06:13 AM
- Posts
- 365
- Registration date
- Monday February 7, 2011
- Status
- Contributor
- Last seen
- September 30, 2013
Mar 29, 2011 at 06:13 AM
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,
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,
RWomanizer
Mar 29, 2011 at 04:52 AM
- Posts
- 365
- Registration date
- Monday February 7, 2011
- Status
- Contributor
- Last seen
- September 30, 2013
Mar 29, 2011 at 04:52 AM
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
kindly explain how the data looks like than we can help you more effectively.
put some part of data of both sheet
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
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
Mar 29, 2011 at 07:01 AM
Mar 29, 2011 at 07:54 AM