So this is the question
I have three columns
1. Names
2. Practical_Ranges
3. theoretical_Ranges
Names and Practical Ranges can be considered as pairs.
I can simplify it like this
Capture.JPG
So as you can see Names can be repeat but not ranges.
My result should be like this
Capture2.JPG
can you help?
in D1
=COUNTIF(C$1:C$7,B1)
and copy down to D10
The following are Array formulas, use Ctrl-Shift-Enter
in E1
=IFERROR(INDEX($A$1:$B$10,SMALL((IF(D$1:D$10<>0,ROW(INDIRECT("1:"&ROWS($A$1:$A$10))))),ROW(A1)),1),"")
in F1
=IFERROR(INDEX($A$1:$B$10,SMALL((IF(D$1:D$10<>0,ROW(INDIRECT("1:"&ROWS($A$1:$A$10))))),ROW(A1)),2),"")
and copy down to E10:F10
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
what happend with name 2 and range 2 ?
Kind regards
Leo
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks