excellahuntress
New Member
- Joined
- Oct 31, 2020
- Messages
- 7
- Office Version
- 365
- Platform
- Windows
How can I extract matching word and numbers between cells in the same column? The current cell will only need to compare with the cell below it and not have to search the entire column.
Example:
A
1. 100 Red apples
2. 100 big red apples
3. A pack of 100 red apples
4. 300 yellow bananas
5. A batch of yellow bananas
So comparing A1 and A2 should result "100 red apples"
Comparing A2 and A3 should show "100 red apples"
Comparing A3 and A4 should put out nothing since there were no matches.
Comparing A4 and A5 should show "yellow bananas"
Example:
A
1. 100 Red apples
2. 100 big red apples
3. A pack of 100 red apples
4. 300 yellow bananas
5. A batch of yellow bananas
So comparing A1 and A2 should result "100 red apples"
Comparing A2 and A3 should show "100 red apples"
Comparing A3 and A4 should put out nothing since there were no matches.
Comparing A4 and A5 should show "yellow bananas"