I have two lists one in column A and the other in column B. The first is of aircraft types and the second is of their reg. There are multiple entries of the same aircraft type and also of the Regs.
eg:
Column A Column B
737 G-AAAA
737 G-AAAA
747 G-BBBB
737 G-ABAB
777 G-DDDD
A380 G-EEEE
737 G-AAAA
I am typing to create a macro which would create the following summary:
Types: Number of different aircraft of type:
737 2
747 1
777 1
A380 1
I can get a macro to make the sorted unique list for aircraft types, but i stumped a to how to get it to count the unique IDs for each aircraft!
Any help would be much appreciated
(i hope i have explained it clearly)
Thanks,
OSB
eg:
Column A Column B
737 G-AAAA
737 G-AAAA
747 G-BBBB
737 G-ABAB
777 G-DDDD
A380 G-EEEE
737 G-AAAA
I am typing to create a macro which would create the following summary:
Types: Number of different aircraft of type:
737 2
747 1
777 1
A380 1
I can get a macro to make the sorted unique list for aircraft types, but i stumped a to how to get it to count the unique IDs for each aircraft!
Any help would be much appreciated
(i hope i have explained it clearly)
Thanks,
OSB