• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

figure out

S

soumyajit

New Member
ID NO NAME RANK

252306 HIMANKA PRAKSH NATH 18

252326 TIMIR KANTI NATH 1

252301 ATUL CHANDRA DAKUA 7

260196 JYOTSNA DAKUA 16

252351 AKTAR HUSSAIN MAZUMDER 11

252361 AMRITA SHEE 10

259250 BISWANATH WARISA 9

257444 SIBU KUMAR CHETRI 15

346814 SURAJ LIMBU 8

260101 GINZOSIAM VAIPHEI 15

453109 CHONGPI VAIPHEI 9

3086814 CHANDRA KISHOR SINGHA 14

453106 D SENI VAIPHEI 13

507000 HOITHIANDAN VAIPHEI 8

453055 THIANNGAI ZOU VAIPHEI 12

453363 B RAMTHIANGHLKIMI 17

453366 LALCHHUA NAWMI 8

453200 K LAL RAMNGHAR 14

453040 R C LALHMINGHLUA 8

453361 C MALSAW DAWNGLIANA 13

271831 BISHNU CHETRI 9

453036 PAULAWONTHANG VAIPHEI 9

453370 P C LALTHAZAMA 8


I just wanted to figer out those data what i need, using only single ID NO and the new database sorted like this;

ID NO NAME RANK

453055 THIANNGAI ZOU VAIPHEI 12

453106 D SENI VAIPHEI 13

3086814 CHANDRA KISHOR SINGHA 14

260101 GINZOSIAM VAIPHEI 15

260196 JYOTSNA DAKUA 16

252306 HIMANKA PRAKSH NATH 18

As we can see when i entered a single ID NO which is 453055 in a cell, the whole database sorted out(as above) against rank wise.is it possiable,plz help me.
 
Hi Soumyajit,


Please check the attached..


It was still not Complete.. Need some Help.. :(


Hi Friends..

Can someone help me to remove DUPLICATE from the answer.. I tried but failed.. I think its not my day.. :(


https://dl.dropbox.com/u/78831150/Excel/Figer%20Out%20%28Soumyajit%29.xlsx


Regards,

Deb
 
Hi Narayan...

Thanks .


I hv also used helper column.. but my helper column is within answer column :)


Regards

Deb
 
Hi Deb ,


Two points :


1. The inclusion of the third parameter as 0 in the MATCH function will ensure that the names are listed in the same order that they appear in , in the input data :


=IFERROR(INDEX($B$2:$B$24,MATCH(1,IF(ISNA(MATCH($B$2:$B$24,$G$1:G1,0)),--($C$2:$C$24=H2)),0)),"")


2. The IDs can be a simple INDEX / MATCH , since neither the names nor the IDs are repeated ; it is only the rankings which are repeated.


Narayan
 
Hi Narayan Sir,

Your excel data base looks like this;

ID name rank

346814 SURAJ LIMBU 8

507000 HOITHIANDAN VAIPHEI 8

453366 LALCHHUA NAWMI 8

453040 R C LALHMINGHLUA 8

453370 P C LALTHAZAMA 8

259250 BISWANATH WARISA 9

453109 CHONGPI VAIPHEI 9

271831 BISHNU CHETRI 9

453036 PAULAWONTHANG VAIPHEI 9

252361 AMRITA SHEE 10

252351 AKTAR HUSSAIN MAZUMDER 11

453055 THIANNGAI ZOU VAIPHEI 12

453106 D SENI VAIPHEI 13

453361 C MALSAW DAWNGLIANA 13

308681 CHANDRA KISHOR SINGHA 14

453200 K LAL RAMNGHAR 14

257444 SIBU KUMAR CHETRI 15

260101 GINZOSIAM VAIPHEI 15

260196 JYOTSNA DAKUA 16

453363 B RAMTHIANGHLKIMI 17

252306 HIMANKA PRAKSH NATH 18


but i wanted this just like the below mention database;

ID name rank

507000 HOITHIANDAN VAIPHEI 8

259250 BISWANATH WARISA 9

252361 AMRITA SHEE 10

252351 AKTAR HUSSAIN MAZUMDER 11

453055 THIANNGAI ZOU VAIPHEI 12

453106 D SENI VAIPHEI 13

308681 CHANDRA KISHOR SINGHA 14

257444 SIBU KUMAR CHETRI 15

260196 JYOTSNA DAKUA 16

453363 B RAMTHIANGHLKIMI 17

252306 HIMANKA PRAKSH NATH 18

Is it possible?
 
Hi Soumyajit ,


Where there are duplicate ranks , what is the criterion for deciding which name / ID should appear in the output ?


For example , there are 5 persons in rank 8 :

[pre]
Code: 
346814     SURAJ LIMBU          8
507000     HOITHIANDAN VAIPHEI  8
453366     LALCHHUA NAWMI       8
453040     R C LALHMINGHLUA     8
453370     P C LALTHAZAMA       8
How do you say that :

507000     HOITHIANDAN VAIPHEI  8
[/pre]
should appear in the output ?


Narayan
 
You must log in or register to reply here.
Back
Top