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:
[TABLE="width: 302"]
<tbody>[TR]
[TD]COLUMN A[/TD]
[TD]COLUMN B[/TD]
[/TR]
[TR]
[TD]APPLE[/TD]
[TD]Anna[/TD]
[/TR]
[TR]
[TD]BANNANA[/TD]
[TD]Bella[/TD]
[/TR]
[TR]
[TD]APPLE[/TD]
[TD]Connie[/TD]
[/TR]
[TR]
[TD]BANNANA[/TD]
[TD]Alea[/TD]
[/TR]
[TR]
[TD]BANNANA[/TD]
[TD]KJ[/TD]
[/TR]
[TR]
[TD]BANNANA[/TD]
[TD]Mon[/TD]
[/TR]
[TR]
[TD]BANNANA[/TD]
[TD]David[/TD]
[/TR]
[TR]
[TD]BANNANA[/TD]
[TD]Louie[/TD]
[/TR]
[TR]
[TD]PINEAPPLE[/TD]
[TD]Russel[/TD]
[/TR]
[TR]
[TD]ORANGE[/TD]
[TD]Angelo[/TD]
[/TR]
</tbody>[/TABLE]
Then I have a dropdown list in Sheet2 C2 with values as below:
[TABLE="width: 78"]
<tbody>[TR]
[TD]APPLE[/TD]
[/TR]
[TR]
[TD]BANNANA[/TD]
[/TR]
[TR]
[TD]PINEAPPLE[/TD]
[/TR]
[TR]
[TD]ORANGE[/TD]
[/TR]
</tbody>[/TABLE]
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:
[TABLE="width: 302"]
<tbody>[TR]
[TD]COLUMN A[/TD]
[TD]COLUMN B[/TD]
[/TR]
[TR]
[TD]APPLE[/TD]
[TD]Anna[/TD]
[/TR]
[TR]
[TD]BANNANA[/TD]
[TD]Bella[/TD]
[/TR]
[TR]
[TD]APPLE[/TD]
[TD]Connie[/TD]
[/TR]
[TR]
[TD]BANNANA[/TD]
[TD]Alea[/TD]
[/TR]
[TR]
[TD]BANNANA[/TD]
[TD]KJ[/TD]
[/TR]
[TR]
[TD]BANNANA[/TD]
[TD]Mon[/TD]
[/TR]
[TR]
[TD]BANNANA[/TD]
[TD]David[/TD]
[/TR]
[TR]
[TD]BANNANA[/TD]
[TD]Louie[/TD]
[/TR]
[TR]
[TD]PINEAPPLE[/TD]
[TD]Russel[/TD]
[/TR]
[TR]
[TD]ORANGE[/TD]
[TD]Angelo[/TD]
[/TR]
</tbody>[/TABLE]
Then I have a dropdown list in Sheet2 C2 with values as below:
[TABLE="width: 78"]
<tbody>[TR]
[TD]APPLE[/TD]
[/TR]
[TR]
[TD]BANNANA[/TD]
[/TR]
[TR]
[TD]PINEAPPLE[/TD]
[/TR]
[TR]
[TD]ORANGE[/TD]
[/TR]
</tbody>[/TABLE]
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