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...

526314	632541
145236	634152
854796	964785

<tbody>
</tbody>

343	-794
-27	-355
256	1530

<tbody>
</tbody>

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

<0	0-750	>751
632541, 145236, 634152	526314, 854796	964785

<tbody>
</tbody>

 

[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.