Posted to microsoft.public.excel.worksheet.functions

Iriemon

external usenet poster

Posts: 89

Finding pairs of numbers

Is this possible? I assume this will involve some VB coding also:

Part Num Associated Part Num
123 456
789 5623
8521 6352
456 123
5478 9821
444444 AT256
5623 789

Formula in "C" that would find the mate and insert a "Pairing" number
So that the 1st and 4th rows would have a 1
and the 2nd and 7th would have a 2 etc

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
finding pairs	Len Case	Excel Worksheet Functions	5	December 18th 07 07:34 PM
How do I graph x,y pairs of numbers with Excel?	glukes	Charts and Charting in Excel	1	July 4th 05 02:55 AM
finding what numbers are in a string (Day 2)	David	Excel Worksheet Functions	0	May 26th 05 10:10 PM
finding what numbers are in a string	David	Excel Worksheet Functions	3	May 26th 05 10:10 PM
finding numbers	flat6	New Users to Excel	2	February 17th 05 10:17 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us