What's your expected results ??

A total of Unquie items or list all 30 answer in one cell with a count ??
Still didn't answer it.

Maybe post a sample with expected results in those cells

VBA Noob