Yes Steve I got the file, thanks
Reviewing it now...
Ok I can do that with formulas. The result will be in the same row as the word in A. For example the 27 combinations of "research" in A1 will be listed horizontally in row 1 from column C to column AC.
Let me know if this works for you
Ok here is the file with the formulas in the yellow cells. I also produced a second list on Sheet2 with 'fixed' results in case you want to copy the list to another spreadsheet
Hope this is ok. Please check it and let me know if it needs any tweaking or if you have any questions
Ok Steve here is the file with the switched results
The formulas are there in the yellow cells. Just click on any yellow cell and you will see the formula in the Formula Bar on top
Hope this helps
Steve, there could be various interpretations to what you are trying to do. Could you tell me what the desired results should be for cells C2, D2 and C3 in the file that I sent you. That way I'll know exactly what is needed
Not,"etc" . I wanted you to open my file and give me the desired results in these specific cells
Ok I think I understand now what you are saying. Here is the corrected file
Hope it is ok now
You're welcome. Glad to help
Ok here you go
No problem :)