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.
This is what I'm trying to show -
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).
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
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

Thanks