Iluvexcel123
New Member
- Joined
- Dec 1, 2015
- Messages
- 16
Hello,
I'm trying to asking Excel to search all values in a particular column for a specific number, and if that number is found, produce the result in the corresponding row in a separate column. I hope the formatting of the example below is clear enough to show the desired results. Thanks for your help!
Note 1: The results will display on a different worksheet.
Note 2: I don't want any blank cells before the first value found (blank cells at the end of the list are okay)
Raw Data: DESIRED RESULTS:
[TABLE="width: 621"]
<tbody>[TR]
[TD]House Number[/TD]
[TD]Characteristics[/TD]
[TD][/TD]
[TD]House 1[/TD]
[TD]House 2[/TD]
[TD]House 3[/TD]
[TD]House 4[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]1 garage[/TD]
[TD][/TD]
[TD]1 garage[/TD]
[TD]3 bedrooms[/TD]
[TD]2 garages[/TD]
[TD]6 windows[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]2 full bath[/TD]
[TD][/TD]
[TD]2 full bath[/TD]
[TD]1 basement[/TD]
[TD]3 full bath[/TD]
[TD]4 bedrooms[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]1 half bath[/TD]
[TD][/TD]
[TD]1 half bath[/TD]
[TD][/TD]
[TD]1 half bath[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]3 bedrooms[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]5 bedrooms[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]1 basement[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]2 garages[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]3 full bath[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]1 half bath[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]5 bedrooms[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]6 windows[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]4 bedrooms[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
I'm trying to asking Excel to search all values in a particular column for a specific number, and if that number is found, produce the result in the corresponding row in a separate column. I hope the formatting of the example below is clear enough to show the desired results. Thanks for your help!
Note 1: The results will display on a different worksheet.
Note 2: I don't want any blank cells before the first value found (blank cells at the end of the list are okay)
Raw Data: DESIRED RESULTS:
[TABLE="width: 621"]
<tbody>[TR]
[TD]House Number[/TD]
[TD]Characteristics[/TD]
[TD][/TD]
[TD]House 1[/TD]
[TD]House 2[/TD]
[TD]House 3[/TD]
[TD]House 4[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]1 garage[/TD]
[TD][/TD]
[TD]1 garage[/TD]
[TD]3 bedrooms[/TD]
[TD]2 garages[/TD]
[TD]6 windows[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]2 full bath[/TD]
[TD][/TD]
[TD]2 full bath[/TD]
[TD]1 basement[/TD]
[TD]3 full bath[/TD]
[TD]4 bedrooms[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]1 half bath[/TD]
[TD][/TD]
[TD]1 half bath[/TD]
[TD][/TD]
[TD]1 half bath[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]3 bedrooms[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]5 bedrooms[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]1 basement[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]2 garages[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]3 full bath[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]1 half bath[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]5 bedrooms[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]6 windows[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]4 bedrooms[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Last edited: