Customers that still need to be listed for - Multiple Conditions

[dalecastillo1]

Hi,

I am having a hard time pulling customers that still need to be listed under column AE. Essentially, if the customer has a green checkmark, it means we are done listing on that customer and any red x's means we have not listed them yet. So I want to be able to come up with a formula that will inform me which customers still need listing (red x's) in the last column. I am only able to pull only one customer at a time as opposed to multiple.

 

[sijpie]

You say you can get one customer. By repeating the formula and using & in between you could string them together. However:
If the number of customer columns is not defined and is more than a trivial number, then doing this with standard formulas will be cumbersome.

An alternative is to build your own formula using VBA. An other alternative is to update all the cells in the final column using a macro and a click of a button.

Need help on this? Which route?

 

[bebo021999]

What kind of the green check mark and red x?
are they check boxes or object inserted?

 

[sijpie]

I'd think Asci 252 (check) and 251 (cross), or even Wingdings font. Dalecastillo, please clarify