Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Question regarding VLookup and if it can check two columns of data | Excel Worksheet Functions | |||
Match Data for 4 Columns | Excel Discussion (Misc queries) | |||
Match data in 2 columns and return data from 3rd column | Excel Worksheet Functions | |||
match columns and associated data | Excel Discussion (Misc queries) | |||
MATCH UP DATA IN COLUMNS | Excel Worksheet Functions |