Check columns for data match...
How about a formula:
=IF(E2,$E$1,"")&IF(F2,$F$1,"")&IF(G2,$G$1,"")&IF(H 2,$H$1,"")
&IF(I2,$I$1,"")&IF(J2,$J$1,"")
(all one cell)
or if you want spaces between values:
=TRIM(IF(E2,$E$1,"")&" "&IF(F2,$F$1,"")&" "&IF(G2,$G$1,"")&" "&IF(H2,$H$1,"")
&" "&IF(I2,$I$1,"")&" "&IF(J2,$J$1,""))
(still all one cell)
Paulc wrote:
Using XL 2000
I have a worksheet which contains 10 columns A:J and over 500 lines.
The data in each cell in the Column range E:J contains either a TRUE or FALSE.
Row 1 contains header labels for each column.
Im looking for a routine to loop through each column, per line and where a
TRUE exists in that column, and ( where more than one TRUE is found)
concatenate the label name in to column K of the same row being checked.
Hope this makes sense.
Ideas appreciated. Thanks, Paul
--
Dave Peterson
|