Below is and attachment that mdbct sent me for matching pairs to a set name for 3 numbers. For ex... the following pairs would be named "1"
00
19
28
37
46
55
05
14
23
69
78
The formula is already is already in the sheet for 3 numbers. I want this formula to be used with 4 numbers.
Last edited by Jordans121; 03-10-2010 at 05:23 PM.
I don't understand what you are trying to do? What is it you are trying to do here?
Microsoft MVP - Excel
Where there is a will there are many ways. Pick One!
Please read the Forum Rules
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Preferred Charities: Lupus Canada and Sick Kids Foundation.
Feel Free to Donate if you want to, for the assistance you received today.
Here is the link to the original thread
Copy the formula in J4 and change any reference for cell F4 to the cell you want to examine - then copy the formula to the right The formula in L21 would be:
Code:="V"&(N(NOT(ISNA(MATCH(G20,$O$4:$O$14,0))))*1+N(NOT(ISNA(MATCH(G20,$P$4:$P$14,0))))*2+N(NOT(ISNA(MATCH(G20,$Q$4:$Q$14,0))))*3+N(NOT(ISNA(
is this same formula?
Im doing front pair, outside pair, inside pair and back pair.
ok. I have it thanks a bunch mdbct!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks