LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 10
Default matching entire rows




I 'm in dire need of a solution to this problem, I need to match sheet1 to
sheet 2 by entire rows and show the non matching rows on sheet3. Any help
with this would be greatly appreciated. I've been working this for a week
and cannot come up with a solution.

Sheet1
Sheet2 Sheet3
1
A
Alfa
1.0001

1
A
Alfa
1.0021

1
A
Alfa
1.0001

2
B
Bravo
2.0001

2
B
Bravo
2.0001

99
booboo
RALPH
99.0001

3
C
Charlie
3.0001

3
C
Charlie
3.0001

1
A
Alfa
1.0021

4
D
Delta
4.0001

4
D
Delta
4.0001

55
OHNO
BOB
55.0001

5
E
Echo
5.0001

5
E
Echo
5.0001






6
F
Foxtrot
6.0001

6
F
Foxtrot
6.0001






7
G
Golf
7.0001

7
G
Golf
7.0001






8
H
Hotel
8.0001

8
H
Hotel
8.0001






9
I
India
9.0001

9
I
India
9.0001






10
J
Juliet
10.0001

10
J
Juliet
10.0001






11
K
Kilo
11.0001

55
OHNO
BOB
55.0001






12
L
Lima
12.0001

11
K
Kilo
11.0001






13
M
Mike
13.0001

12
L
Lima
12.0001






14
N
November
14.0001

13
M
Mike
13.0001






15
O
Oscar
15.0001

14
N
November
14.0001






16
P
Papa
16.0001

15
O
Oscar
15.0001






17
Q
Quebec
17.0001

16
P
Papa
16.0001






18
R
Romeo
18.0001

17
Q
Quebec
17.0001






19
S
Sierra
19.0001

18
R
Romeo
18.0001






20
T
Tango
20.0001

19
S
Sierra
19.0001






21
U
Uniform
21.0001

20
T
Tango
20.0001






22
V
Victor
22.0001

21
U
Uniform
21.0001






23
W
Whiskey
23.0001

22
V
Victor
22.0001






24
X
XRay
24.0001

23
W
Whiskey
23.0001






25
Y
Yankee
25.0001

24
X
XRay
24.0001






26
Z
Zulu
26.0001

25
Y
Yankee
25.0001






99
booboo
RALPH
99.0001

26
Z
Zulu
26.0001








 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Matching Rows Blissfully Ignorant Excel Discussion (Misc queries) 2 July 25th 08 09:33 PM
Column Matching - Bring the entire row. vrk1 Excel Discussion (Misc queries) 4 May 6th 08 08:10 PM
Return position for each matching value in entire workbook? Squidman Excel Worksheet Functions 1 September 15th 06 11:36 PM
Inserting Entire Rows TP[_4_] Excel Programming 1 June 25th 04 03:17 PM
Deleting entire rows Ed C[_3_] Excel Programming 2 June 18th 04 02:14 PM


All times are GMT +1. The time now is 10:09 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"