G
Guest
I asked this question, but I would like to clarify. I have a range of data
as shown:
a b
1 jan 5
2 feb 6
3 mar 7
4 jan 8
5 mar 10
6 jan 3
On a different sheet, I would like to extract all the data that is the same
in 'a' and its corresponding value in 'b', and I would like them all
together. No blanks in between. I would like on a different sheet to see
all the 'jan' in the first three cells on the sheet with the values from 'b'
beside them. Or, if it were 'feb' that I wanted, I would only see one cell,
etc.
Thanks,
as shown:
a b
1 jan 5
2 feb 6
3 mar 7
4 jan 8
5 mar 10
6 jan 3
On a different sheet, I would like to extract all the data that is the same
in 'a' and its corresponding value in 'b', and I would like them all
together. No blanks in between. I would like on a different sheet to see
all the 'jan' in the first three cells on the sheet with the values from 'b'
beside them. Or, if it were 'feb' that I wanted, I would only see one cell,
etc.
Thanks,