With a pivot table.
I showed 2 examples.
With a pivot table.
I showed 2 examples.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Not exactly. I uploaded a better picture of what I am looking to do. I have values in A2, and they are kind of all over the place, I am looking to check the contents of A to a list (So for example in column A I would have Microsoft Office 2007, Microsoft Office Powerpoint) and then in my list in say Column F I would have (SAP, Microsoft Office, Adobe). So in maybe column C, it would return Microsoft Office for those entries. I don't want to replace anything, just create a new column for a "short name"
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks