I need something that will allow me to look through an excel row of 45 cells. Each cell either has a 1 or an 0 in it. Lets say the column headers are the numbers 1-45. I have i need something that will allow me to create 45 new cells with the same column headers and under each header it needs to put a 1 if there is a 1 in any of the other cells from the previous columns and a 0 if there is not any other 1's in those other cells. Also it would have to put a 0 if there is not a 1 in the cell that your doing the query in.