is it possible with a formula

[soumyajit]

I have a database in column A.it's call "chain list" & it's just look like this;


> 08382657-SAMARENDRA DUTTA [15] -8-262  

- - -- -- - > 08398900 - RUPAK BHOWMIK [ 14 ] -8-262  

- - -- - -- - -- - > 08294964 - CHITTA RANJAN DEBBARMA [ 8 ] -8-262  

- - -- -- - > 08408726 - HIMA CHAKRABORTY(MUKHERJEE) [ 14 ] -8-262  

- - -- - -- - -- - > 08625223 - DIP CHARAN DEY [ 12 ] -8-262  

- - -- - -- - -- - > 08625220 - BIPUL DEB [ 12 ] -8-236  

- - -- - -- - -- - -- - - > 08256245 - BABUL BISWAS [ 10 ] -8-236  

- - -- - -- - -- - > 08268839 - AMAL ACHARJEE [ 12 ] -9-256  

- - -- - -- - -- - > 08287230 - HARI SANKAR MUKHERJEE [ 8 ] -8-688  

- - -- - -- - -- - > 08268834 - MADHU SUDAN DEBNATH [ 8 ] -8-262  

- - -- - -- - -- - > 08319791 - GOPAL CHANDRA DEBNATH [ 12 ] -8-262  

- - -- - -- - -- - -- - - > 08329413 - MAMATA DEBNATH [ 10 ] -8-259  

- - -- - -- - -- - > 08291395 - SUDHIR DEBNATH [ 7 ] -8-262  

- - -- - -- - -- - > 08329903 - NITISH CHANDRA NATH [ 7 ] -8-262  

- - -- - -- - -- - > 083294140 - SATI DE (NAG) [ 9 ] -8-262  

- - -- - -- - -- - > 08549144 - RABINDRA DAS [ 8 ] -8-262  

- - -- -- - > 08532503 - RAKHI PAUL [ 11 ] -8-262  

- - -- - -- - -- - > 08443290 - SUPARNA MAJUMDER (DEBNATH) [ 8 ] -8-262  

- - -- - -- - -- - > 08283250 - KAJAL DEB [ 10 ] -8-259  

- - -- - -- - -- - > 08509942 - AJOY DEB [ 10 ] -8-262  

- - -- - -- - -- - > 08401281 - APARNA SINGHA ROY [ 10 ] -8-688  

- - -- - -- - -- - > 08398747 - NANDA DULAL PAUL [ 10 ] -8-688  

- - -- - -- - -- - -- - - > 08398815 - GITA RANI DAS [ 10 ] -8-688  

- - -- - -- - -- - -- - - > 08398397 - HARI PADA PAUL [ 10 ] -8-688  

- - -- - -- - -- - > 08299554 - MOHAN LAL SHIL [ 9 ] -8-688


as we can see there are names(MOHAN LAL SHIL),code nos(08299554)& ranks([ 9 ])etc in this above shown database and also lots of up & downs.


In this database i just wanted to find out who's senior is who,for example the "08299554 - MOHAN LAL SHIL [ 9 ] -8-688" senior is "08532503 - RAKHI PAUL [ 11 ] -8-262" & the "08532503 - RAKHI PAUL [ 11 ] -8-262" senior is "08382657-SAMARENDRA DUTTA [15] -8-262"


is it possible when i entered a code no in B1 cell the senior based data automatically shown in column C like bellow;


B1 C

08299554 08299554 - MOHAN LAL SHIL [ 9 ] -8-688

08532503 - RAKHI PAUL [ 11 ] -8-262

08382657-SAMARENDRA DUTTA [15] -8-262


plz help me.

 

[Hui]

Can you post a sample file

Refer: http://chandoo.org/forums/topic/posting-a-sample-workbook


Also what rule/ field defines the relationships between people?

 

[Faseeh]

Hi soumyajit,


Please see this file:


http://dl.dropbox.com/u/60644346/Empolyee%20Snr%20%26%20Jnr.%20List.xlsx


Faseeh