austinandrei
Board Regular
- Joined
- Jun 7, 2014
- Messages
- 117
Hi,
I need help in Excel formula, maybe an Array formula but not macro.
I have 2 sheets in my Workbook.
Sheet1:
<tbody>
</tbody>Then I have a dropdown list in Sheet2 C2 with values as below:
<tbody>
</tbody>What I need is when I choose APPLE in Sheet2!C2, all the list of names meeting this criteria will be list down in Sheet 2 starting from Cell A1. So it is like Filtering Column A of Sheet1 then copying all values into Column A of Sheet2.
austin
I need help in Excel formula, maybe an Array formula but not macro.
I have 2 sheets in my Workbook.
Sheet1:
COLUMN A | COLUMN B |
APPLE | Anna |
BANNANA | Bella |
APPLE | Connie |
BANNANA | Alea |
BANNANA | KJ |
BANNANA | Mon |
BANNANA | David |
BANNANA | Louie |
PINEAPPLE | Russel |
ORANGE | Angelo |
<tbody>
</tbody>
APPLE |
BANNANA |
PINEAPPLE |
ORANGE |
<tbody>
</tbody>
austin