how to use if condition with concatenate

[ramyahemanth]

Sir,

I have a data containing name of the students, registration no. and receipt no. The students will pay there fee in different receipt in different dates or same date (ie. 1,2 or 3 more receipt) a few students will pay in one receipt or may pay in 3 more receipt, now i want to combine the receipt no. in different cell into one single cell and i want "/" symbol between the receipt no. one after the other

example

SL. No. Name Registration no. Date Receipt No.

1 Tushar Soni 1BY11CS083 09/08/2012 27044

2 Tushar Soni 1BY11CS083 09/08/2012 27042

3 Tushar Soni 1BY11CS083 09/08/2012 27043

4 Shruthi 1BY09CS068 30/10/2012 25267

5 Shruthi 1BY09CS068 21/11/2012 25274

6 Shruthi 1BY09CS068 22/11/2012 25273

7 Shruthi 1BY09CS068 09/01/2013 25283

8 Akhil Kumar 1BY11TE005 14/08/2012 27445

9 Akhil Kumar 1BY11TE005 16/08/2012 27444

10 A Manoj 1BY12EC001 29/08/2012 27644

11 Sowmya. K.R 1BY10MCA59 14/08/2012 26406

12 Sowmya. K.R 1BY10MCA59 16/08/2012 28404

13 Sowmya. K.R 1BY10MCA59 14/09/2012 28483

 

[NARAYANK991]

Hi Ramya ,


Assuming that the data you have posted is sorted on the student name , and extends from A1 through E14 , then in F2 , you can enter the following formula :


=IF(B2<>B1,E2&"",F1&" / "&E2)


Copy this down.


Narayan

 

[Faseeh]

Hi ramyahemanth,


Cross-Posting is strictly prohibited here, It waste time of other members!! you have asked same question on this thread.


http://chandoo.org/forums/topic/vlookup-with-concatenate


So I am closing this thread.


Regards,