Remove Duplicate Entries from List

[justanotheruser]

Hi all,

I've got a drop down list which is linked to a source sheet called "Mapping", and on this sheet I have selected my range for Data Validation for a Drop Down list.

However, there are certain values which are repeated, so I've used some IF, COUNTIF, ROWS and INDEX formulas to sort it out and remove duplicate entries.

In the table, below, the data is stored in Column C, the first part of my calculations is in Column A, and then the second part is in Column B - which I want to use as the source for my drop down list. The only problem that I have is that instead of blanks cells there are 0s in the cell as below. Could someone help me fix it? (cell C2 is intentionally blank)

Excel Workbook
	A	B	C
1	*	*	Entity
2	*	*	*
3	1	210	210
4	1	220	210
5	1	230	210
6	2	240	220
7	2	250	220
8	3	0	230
9	3	0	230
10	3	0	230
11	4	0	240
12	5	0	250
13	6	0	*
14	7	0	*
15	8	0	*
16	9	0	*
17	10	0	*
18	11	0	*
19	12	0	*
20	13	0	*
21	14	*	*
22	15	*	*
23	16	*	*
24	17	*	*
25	18	*	*
26	*	*	*
27	*	*	*
Mapping

Thanks in advance.

 

[snoopyhr]

see if this works for you .

Excel Workbook
	C	D	E	F	G
1	Entity	Sheet Name			Unique list
2
3	FA6_210	PL_Workwear			FA6_210
4	FA6_210	BS_Workwear			FA7_220
5	FA6_210	PL_Cleanroom			FA78_250
6	FA7_220	PL_Workwear			FA89_230
7	FA8S_220	BS_Workwear			FA8S_220
8	FA89_230	PL_Cleanroom			KK_230
9	KK_230	PL_Workwear			ZE_240
10	KK_230	BS_Workwear
11	ZE_240
12	FA78_250
Sheet1

#VALUE!

</td></tr></table></td></tr></table>