Conditional Formatting and Match Cells to remove data in below cells

[desibouy]

Hi,

I'm trying to show 1 value 'Top Row = Yes' if Column B is the Repeatable. For example Line 3 to 6. IF It's not repeatable then it will still be Top ROW. I will use Conditional Formatting to show me items which are not duplicates.

TEST FILE MARCH.xlsx
	A	B	C	D	E
1	Unique Internal ID	Product Family ID	SIMPLE PRODUCT?	SKU	Name
2	8731	8731	SIMPLE	KEMKEM001/PK	Osto EZ Vent
3	4302	4298		503407/BX	CenterPointLock Stoma Cap
4	4301	4298		503404/BX	CenterPointLock Stoma Cap
5	4300	4298		503403/BX	CenterPointLock Stoma Cap
6	4299	4298		503402/BX	CenterPointLock Stoma Cap
7	5301	5299	SIMPLE	007-3186/BX	Stoma Cap
8	89646	89642		007-401922/BX	Sur-Fit Natura Dose Kit
9	89643	89642		51401924/BX	Sur-Fit Natura Dose Kit
10	88049	88045		007-7815/BX	Adapt Barrier Rings
11	88048	88045		007-7806/BX	Adapt Barrier Rings
12	88047	88045		007-100798/BX	Adapt Barrier Rings
13	88046	88045		007-100798/EA	Adapt Barrier Rings
14	85952	85950	SIMPLE	007-102518/BX	Adapt CeraRing Barrier Ring
15	85248	85246		007-101100/BX	New Image Skin Barrier
16	85247	85246		5019303/BX	New Image Skin Barrier
17	84739	4048		503731/BX	CenterPointLock Skin Barrier
18	84738	4048		007-3730/BX	CenterPointLock Skin Barrier
19	84571	84565		5089603/BX	Adapt CeraRing Barrier Rings
20	84570	84565		5089602/BX	Adapt CeraRing Barrier Rings
21	84569	84565		5089601/BX	Adapt CeraRing Barrier Rings
22	84568	84565		5089540/BX	Adapt CeraRing Barrier Rings
23	84567	84565		5089530/BX	Adapt CeraRing Barrier Rings
24	84566	84565		5089520/BX	Adapt CeraRing Barrier Rings
25	39369	39369	SIMPLE	RRSNS31004/BX	Skin Barrier Ring
26	38716	38714		RRSNS684U4/BX	Conforming Skin Barrier Ring
27	38715	38714		RRSNS684U2/BX	Conforming Skin Barrier Ring
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B:B	Cell Value	duplicates	text	NO

This is what I'm trying to show -

Unique Internal ID	Product Family ID	SIMPLE PRODUCT?	TOP ROW	SKU
8731	8731	SIMPLE	TRUE	KEMKEM001/PK
4302	4298		TRUE	503407/BX
4301	4298			503404/BX
4300	4298			503403/BX
4299	4298			503402/BX
5301	5299	SIMPLE	TRUE	007-3186/BX
89646	89642		TRUE	007-401922/BX
89643	89642			51401924/BX
88049	88045		TRUE	007-7815/BX
88048	88045			007-7806/BX
88047	88045			007-100798/BX
88046	88045			007-100798/EA
85952	85950	SIMPLE	TRUE	007-102518/BX
85248	85246		TRUE	007-101100/BX
85247	85246			5019303/BX
84739	4048		TRUE	503731/BX
84738	4048			007-3730/BX
84571	84565		TRUE	5089603/BX
84570	84565			5089602/BX
84569	84565			5089601/BX
84568	84565			5089540/BX
84567	84565			5089530/BX
84566	84565			5089520/BX
39369	39369	SIMPLE	TRUE	RRSNS31004/BX
38716	38714		TRUE	RRSNS684U4/BX
38715	38714			RRSNS684U2/BX

IF the TOP ROW is True, then I want the TITLE to display empty for the remaining cells underneath, for example - (THIS WILL apply to other fields in the spreadsheet for example (Description, and Images. Because everything is a duplicate I can safely delete it as the TOP ROW has the information).

TOP ROW	SKU	Name
TRUE	KEMKEM001/PK	Osto EZ Vent
TRUE	503407/BX	CenterPointLock Stoma Cap
	503404/BX
	503403/BX
	503402/BX
TRUE	007-3186/BX	Stoma Cap
TRUE	007-401922/BX	Sur-Fit Natura Dose Kit
	51401924/BX
TRUE	007-7815/BX	Adapt Barrier Rings
	007-7806/BX
	007-100798/BX
	007-100798/EA
TRUE	007-102518/BX	Adapt CeraRing Barrier Ring
TRUE	007-101100/BX	New Image Skin Barrier
	5019303/BX
TRUE	503731/BX	CenterPointLock Skin Barrier
	007-3730/BX
TRUE	5089603/BX	Adapt CeraRing Barrier Rings
	5089602/BX
	5089601/BX
	5089540/BX
	5089530/BX
	5089520/BX
TRUE	RRSNS31004/BX	Skin Barrier Ring
TRUE	RRSNS684U4/BX	Conforming Skin Barrier Ring
	RRSNS684U2/BX

Novice Excel User please can anyone guide me. Sorry couldn't delete my other thread based on this (Reason for creating a new thread: Old thread maybe too complex to understand, and couldn't amend).

Thanks

 

[Fluff]

I've tested it and it seems right

In that case I would use it.