Separating numbers according to their value

[Ian1976]

Morning folks

I have 2 tables, 1 with serial numbers in and the other with the hours that the item has been used for like this...

[TABLE="width: 500"]
<tbody>[TR]
[TD]526314[/TD]
[TD]632541[/TD]
[/TR]
[TR]
[TD]145236[/TD]
[TD]634152[/TD]
[/TR]
[TR]
[TD]854796[/TD]
[TD]964785[/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="width: 500"]
<tbody>[TR]
[TD]343[/TD]
[TD]-794[/TD]
[/TR]
[TR]
[TD]-27[/TD]
[TD]-355[/TD]
[/TR]
[TR]
[TD]256[/TD]
[TD]1530[/TD]
[/TR]
</tbody>[/TABLE]

Is it possible to generate a formula that if the hours are between certain figures it puts the serial numbers of the item in a list or separate box/field? like this.... Thanks [TABLE="width: 500"]
<tbody>[TR]
[TD]<0[/TD]
[TD]0-750[/TD]
[TD]>751[/TD]
[/TR]
[TR]
[TD]632541, 145236, 634152[/TD]
[TD]526314, 854796[/TD]
[TD]964785[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Peter_SSs]

If you have the TEXTJOIN function in your version of Excel, then try these.
They are array formulas so should be entered without the {} but confirmed with Ctrl+Shift+Enter, not just Enter. If confirmed correctly, Excel will insert the {}.

Excel Workbook
	A	B	C
1	526314	632541
2	145236	634152
3	854796	964785
4
5	343	-794
6	-27	-355
7	256	1530
8
9		0-750	>751
10	632541, 145236, 634152	526314, 854796	964785
List Numbers

 

[Ian1976]

Thanks, thats worked a treat!

 

[Peter_SSs]

Thanks, thats worked a treat!

You're welcome. Thanks for the confirmation.