I am trying to create a dynamic column in excel that will serve as an index for a graph.
I have a list of 4000 items that have been registered over the past 10 years.
I'd like to keep the list intact, but create a new list in a column that meets criteria.
Easy so far, but I'd like there to be no gaps between criteria meeting cells and I'd like to use formulas to get it done. Not VBA.
[TABLE="width: 100"]
<tbody>[TR]
[TD]ID[/TD]
[TD]Use[/TD]
[TD]Age[/TD]
[TD]List[/TD]
[/TR]
[TR]
[TD]A100[/TD]
[TD]Valid[/TD]
[TD]60[/TD]
[TD]A103[/TD]
[/TR]
[TR]
[TD]A101[/TD]
[TD]Valid[/TD]
[TD]45[/TD]
[TD]A104[/TD]
[/TR]
[TR]
[TD]A102[/TD]
[TD]Invalid[/TD]
[TD]28[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A103[/TD]
[TD]Valid[/TD]
[TD]25[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A104[/TD]
[TD]Valid[/TD]
[TD]21[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Based on the example above, if the Use column = Valid AND if the Age column is less than 30 the List column will populate the ID associated with the item meeting criteria. A103 and A104 in the example above.
Any thoughts?
Jimmy
I have a list of 4000 items that have been registered over the past 10 years.
I'd like to keep the list intact, but create a new list in a column that meets criteria.
Easy so far, but I'd like there to be no gaps between criteria meeting cells and I'd like to use formulas to get it done. Not VBA.
[TABLE="width: 100"]
<tbody>[TR]
[TD]ID[/TD]
[TD]Use[/TD]
[TD]Age[/TD]
[TD]List[/TD]
[/TR]
[TR]
[TD]A100[/TD]
[TD]Valid[/TD]
[TD]60[/TD]
[TD]A103[/TD]
[/TR]
[TR]
[TD]A101[/TD]
[TD]Valid[/TD]
[TD]45[/TD]
[TD]A104[/TD]
[/TR]
[TR]
[TD]A102[/TD]
[TD]Invalid[/TD]
[TD]28[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A103[/TD]
[TD]Valid[/TD]
[TD]25[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A104[/TD]
[TD]Valid[/TD]
[TD]21[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Based on the example above, if the Use column = Valid AND if the Age column is less than 30 the List column will populate the ID associated with the item meeting criteria. A103 and A104 in the example above.
Any thoughts?
Jimmy