| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Looping Through Records.
Kevin this is genious - and no loops:) Thank you Diana -----Original Message----- In a third column, put the formula =IF(B2 = "Y", A2 & ", " & C3, C3) and copy it down for the entire column, where column A is the vendors, column B is the qualified and column C is the formula. The cell to display the combined result could be =LEFT(A2, LEN(A2) - 2) to get rid of the trailing comma and space Kevin Beckham -----Original Message----- Thank you in advance for your time and help. Here is the senario: I have a table with Vendor Names and Y or N next to each name. Vendor Name Qualified A N B Y C Y D N E Y I would like to concatenate all the Vendor Names that are qualified in one cell. So for this example the result would be: B, C, E I realize that I need to write a formula to loop through the data but I am not exactly sure how this is done. I think I have a phobia of loops and arrays:) . . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Delete records when certain records have duplicate column data | New Users to Excel | |||
| Looping | Excel Discussion (Misc queries) | |||
| Looping | Excel Discussion (Misc queries) | |||
| Looping | Excel Programming | |||
| Need Looping Help | Excel Programming | |||
![Diana[_6_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
