Would it be possible to do this.
I have a spreadsheet with 4 columns
Column
A – Postcode
B – Reference Number
C – Name
D – G or H not both (these letters either G or H are not in every cell in column D)
What I would like is to find the following:
only rows where
1 There is a duplicated Postcode entry in column A and
2 At least one of these duplicate postcode entries has a reference number in column B and
3 At least one of these duplicate postcode entries has the letter G or H in column D
So I need any duplicate postcodes where there is a reference number and an entry in column D but it doesn’t have to be the same postcode.
e.g 5 duplicate postcodes found in column A, one of them has a reference in column B and one has an enrty in column D.
Hope someone can help me.
I have a spreadsheet with 4 columns
Column
A – Postcode
B – Reference Number
C – Name
D – G or H not both (these letters either G or H are not in every cell in column D)
What I would like is to find the following:
only rows where
1 There is a duplicated Postcode entry in column A and
2 At least one of these duplicate postcode entries has a reference number in column B and
3 At least one of these duplicate postcode entries has the letter G or H in column D
So I need any duplicate postcodes where there is a reference number and an entry in column D but it doesn’t have to be the same postcode.
e.g 5 duplicate postcodes found in column A, one of them has a reference in column B and one has an enrty in column D.
Hope someone can help me.