Forum Discussion
Solved
Calculating values based on position in family
Our school SMS exports data as follows Student - Legal Name Group 1 - Name Edge Name Fee Jon Smith Auckland Campus Peter and Sue Smith 0 Sue Smith Auckland Campus Peter and Sue S...
I had assumed that the data began in row 2. Your data begin in row 8, so you should use
=CHOOSE(MIN(COUNTIF($C$8:$C8,$C8),5),$B$1,$B$2,$B$3,$B$4,$B$5)
in D8, then fill down.
In D2:
=CHOOSE(MIN(COUNTIF($C$2:$C2,$C2),5),Fee1,Fee2,Fee3,Fee4,Fee5)
Replace Fee1 to Fee5 with the actual fee amounts.
Then fill down.
HansVogelaar Thanks for this but I am still doing something wrong.
I used
=CHOOSE(MIN(COUNTIF($C$2:$C2,$C2),5),$B$1,$B$2,$B$3,$B$4,$B$5)
And get the following
I had assumed that the data began in row 2. Your data begin in row 8, so you should use
=CHOOSE(MIN(COUNTIF($C$8:$C8,$C8),5),$B$1,$B$2,$B$3,$B$4,$B$5)
in D8, then fill down.
- lol, I can't believe I did that thanks 🙂