ID Q3.1_a Q3.1_b Q3.1_c Q3.1_d Q3.1_e Q3.1_f Q3.1_g
1 2 21
2 9 11 13 21
3 1 11 28
4 4 5
5 4 7 11 28
6 2 6 22

I would like to convert the above excel data to 1 or 0's.

There in 5nd row (ID=4) I will have 1 in the 4th and 5th cell, all others will have a Zero.

V1 V2 V3 V4 V5 V6 V7 V8 V9
0 0 0 1 1 0 0 0 0

I could you an IF function, but then only way I know will have to look at each cell separately, if (Q3.1_a=1 OR Q3.1_b = 1. etc)
Where I would rather lookup the range Q3.1_a:Q3.1_g

Thanks for the help.
Brendan