kelly mort
Well-known Member
- Joined
- Apr 10, 2017
- Messages
- 2,169
- Office Version
- 2016
- Platform
- Windows
I have a table that I have names in column A then inside column G are numbers.
Column A is in range A17:A25 then G is also G17:G25.
So in cell A16, I want to get all names that have values greater than 10 in column G.
These names should be separated by comma. And if only one exists then no comma.
Also if none exists, we blank A16.
I am stacked .
I need help.
Thanks
Column A is in range A17:A25 then G is also G17:G25.
So in cell A16, I want to get all names that have values greater than 10 in column G.
These names should be separated by comma. And if only one exists then no comma.
Also if none exists, we blank A16.
I am stacked .
I need help.
Thanks