mycelium
02-21-2018, 01:57 AM
Hello,
I have a Sheet that contains the title of many books.
I would like to create a grouping engine that automatically groups the books based on the words that appear in the title.
For example:
Book 1 : Little Princess of Fantasy
Book 2 : Little Birds of the Moon
Book 3 : Little Ducks on the Moon
Book 4 : Foxes in the Moon
Book 5 : Foxes and Cows
Book 6 : Foxes and Little Birds
Book 7 : Cleaning with Little Foxes
Book 8 : Enchanted Foxes
Group 1 : "Foxes" Appeared 5 times (and shows all the book titles)
Group 2 : "Little" Appeared 4 times (and shows all the book titles)
Group 3 : "Moon" Appear 3 times (and shows all the book titles)
Group 4 : "Birds" Appear 2 times (and shows all the book titles)
May I know how can I do this in Excel or in Access? Thank You.
I have a Sheet that contains the title of many books.
I would like to create a grouping engine that automatically groups the books based on the words that appear in the title.
For example:
Book 1 : Little Princess of Fantasy
Book 2 : Little Birds of the Moon
Book 3 : Little Ducks on the Moon
Book 4 : Foxes in the Moon
Book 5 : Foxes and Cows
Book 6 : Foxes and Little Birds
Book 7 : Cleaning with Little Foxes
Book 8 : Enchanted Foxes
Group 1 : "Foxes" Appeared 5 times (and shows all the book titles)
Group 2 : "Little" Appeared 4 times (and shows all the book titles)
Group 3 : "Moon" Appear 3 times (and shows all the book titles)
Group 4 : "Birds" Appear 2 times (and shows all the book titles)
May I know how can I do this in Excel or in Access? Thank You.