I suggest you replace your repeating fields with a a portal to a related table where each repetition has been replaced by a separate, related record. That should make exporting your data to excel a much simpler process.
"IF any repitition of the field 'weartype'==shaving, enter 1. IF no, enter 0."
A calculation field ( with the box "Do not evaluate if all referenced fields are empty" unflagged ) and calc:
ValueCount ( FilterValues ( List ( WearType ) ; "shaving" ) )
will do it.