Displaying Multiple items in Excel

[batrasunil81]

Hi,

I have a sheet1 in excel with the details of student and his subjects.

Name Subject
A HR
B Marketing
A Finance
A International Business

In sheet 2, I have the name of the student. I want to display all the subject of his in one go. For instance, if I enter the name "A" in sheet 2, it shows all the subject ("HR", "Finance", "International Business").

Facing trouble with this. Could anyone help on this.

Regards,

[broro183]

hi,

If you are happy using VBA code, there's a useful User Defined Function (UDF) known as mvlookup which can do what you want - a few useful links are below.
If you would rather only use formulae it can still be done (with the results in separate cells) but I don't have any examples with me at this computer - can you please let us know if you want a formula only solution?


http://www.vbaexpress.com/forum/showthread.php?t=4495
(this may be the best one for you as it talks about all the results in a single cell separated by commas or spanning multiple cells)

http://www.ozgrid.com/forum/showthread.php?t=43442

http://www.mrexcel.com/forum/showthread.php?t=57706


You could also have a look at the pages listed on the below Google search:
http://www.google.co.nz/search?num=1...function&meta=


If you are not used to macros but would like to try the UDF approach, have a look at Dave's page:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

hth
Rob

[batrasunil81]

hi, have attached the sheet for your reference. I am not comfortable with macros hence, not using the response provided.

Please have a look at it.

Regards,

[batrasunil81]

hi, have attached the sheet for your reference. I am not comfortable with macros hence, not using the response provided.

Please have a look at it.

Regards,