kevvukeka
06-03-2014, 02:02 AM
Hi All,
I need some help with an excel formula. Below is my scenario:
Invoice Number
Claim Number
xxxxxx
xxxxxx
A
1
A
2
A
3
B
4
B
5
B
6
C
7
C
8
C
9
I need the output as below:
Invoice Numbers
Claim1
Claim 2
Claim 3
A
1
2
3
B
4
5
6
C
7
8
9
Can someone kindly suggest something as I haven't ever used array formulas.
Thanks a lot for your help.
Kindly assume the first table represents an excel sheet for the convenience of cell references.
I need some help with an excel formula. Below is my scenario:
Invoice Number
Claim Number
xxxxxx
xxxxxx
A
1
A
2
A
3
B
4
B
5
B
6
C
7
C
8
C
9
I need the output as below:
Invoice Numbers
Claim1
Claim 2
Claim 3
A
1
2
3
B
4
5
6
C
7
8
9
Can someone kindly suggest something as I haven't ever used array formulas.
Thanks a lot for your help.
Kindly assume the first table represents an excel sheet for the convenience of cell references.