Hi
I would like to know if it is possible for an "IF Function" to return different results in one cell only seperated by a comma?
I have a number of tests in column A.
In the top of column B, C & D I have three different test categories.
The trick is then, that I'm going to mark an "X" next to a test number, underneath the category it belongs to.
Then I want another cell to show the test name, depending on where the "X" has been placed. AND if there are multiple "Xs" I want that cell to show all the names seperated by a comma or semicolon.
Is this possible without to much programming?
Thanks for your time.
Bookmarks