Hi,
Question:
1.) If more than 1 cells have values? What will be returned? What is the order of preference? (Example: Columns A and C will both contain different values, should the formula return the value in A or in C or both separated with a comma or other separator..
2.) Is the number of columns constant? Is there possibility that a column will be added and will be included in the formula?
This will help us help you.
Regards,
Peter
Bookmarks