Hi There
I have a data set with multiple columns where I need to count the unique fields in a seperate tab based on multiple criteria.
<tbody>
</tbody>
1 - I want to only take the first 6 characters from PNR column
2 - I want to summarise how many unique times column A (PNR) + column D (MAX ID) appear together
3 - I also want to summarise point 2 plus month of booking date
I can do it by copying to a diff sheet, removing duplicates and then using countif formulas but in case I wanted to just read from the raw data tab without copying/removing, is there any formula I can use?
Many thanks
Melimob
I have a data set with multiple columns where I need to count the unique fields in a seperate tab based on multiple criteria.
PNR | Booking Date | Booking Agent | MAX Booking Agent ID |
AAVBHD01 | 10/09/2018 | AO | 99355 |
AAWTZK01 | 05/09/2018 | BM | 86788 |
ABDYNH01 | 10/09/2018 | GM | 23023 |
ABGRLL01 | 05/09/2018 | SW | 25238 |
ADVQJQ01 | 04/09/2018 | AO | 99355 |
AENSSR01 | 10/09/2018 | JP | 14647 |
AFFGNM01 | 05/09/2018 | PB | 28180 |
AGJTEJ01 | 04/09/2018 | SD | 23509 |
AGJTEJ01 | 04/09/2018 | SD | 23509 |
<tbody>
</tbody>
1 - I want to only take the first 6 characters from PNR column
2 - I want to summarise how many unique times column A (PNR) + column D (MAX ID) appear together
3 - I also want to summarise point 2 plus month of booking date
I can do it by copying to a diff sheet, removing duplicates and then using countif formulas but in case I wanted to just read from the raw data tab without copying/removing, is there any formula I can use?
Many thanks
Melimob
Last edited: