Forum Discussion
Solved
Sum only once when multiple selection contained in csv column value
I have a table of schools and attendance figures The school names are in in CSV format I would like to sum the attendance figures only once per selected school The school selection is dynamic and...
Raw data for sessons data
| Session | Schools | Pupils |
| 1 | A | 10 |
| 2 | A,B | 11 |
| 3 | A,B,C | 12 |
| 4 | B | 13 |
| 5 | A,C | 14 |
Hi Ashish
Unfortunately your down load is blocked for me i wonder if you could paste in some of your workings, that would be great to see.
Thanks
Hi,
File attached.