Listbox search function without duplicates

[dss28]

I am enclosing my two sheets - first master data and second sheet showing a tabulated result which I want in a list box.
In the master sheet I have data in column A to R.
The columns F, G, R have same values for a one Patient ID (in column F). rest of the columns have different values for a given Patient ID

I want a listbox to show results of only columns F, G, R but in a single row without duplicates. (summary type)

search listbox data.xlsx
	A
2
MastData

search listbox data.xlsx
	J
19
ListBoxResult

can any one guide in this please.

 

[dss28]

Well, I still need a sample workbook.

I sorted it out by adding filter code to a column with serial number entry, and then copying the filtered data to another sheet which then is captured in the listbox.

 

[Akuini]

Glad you figured it out.