Carl_London
New Member
- Joined
- Feb 28, 2023
- Messages
- 19
- Office Version
- 2016
- Platform
- Windows
Hi!
I have a worksheet that needs to look like this:
Row 1 is the header row
Column C should show Good and format Green if it the first entry where the combination of Column A and B is disinct (is that the correct word?)
Column C should show Duplicate for any subsequent entries where the combination of Column A and B has already appeared higher
Column C should remain blank and not count where either or both of Column A or B are blank, I may need add additional rows
Cell C13 should count and display the total number of entries
Cell C14 should count and display the number of good entries
Cell C15 should count and display the number of duplicate entries
I am getting myself of a muddle, any help for this newbie would be very very welcome.
Thanks for any help!
Carl
I have a worksheet that needs to look like this:
Row 1 is the header row
Column C should show Good and format Green if it the first entry where the combination of Column A and B is disinct (is that the correct word?)
Column C should show Duplicate for any subsequent entries where the combination of Column A and B has already appeared higher
Column C should remain blank and not count where either or both of Column A or B are blank, I may need add additional rows
Cell C13 should count and display the total number of entries
Cell C14 should count and display the number of good entries
Cell C15 should count and display the number of duplicate entries
I am getting myself of a muddle, any help for this newbie would be very very welcome.
Thanks for any help!
Carl