Spinbutton to select values from list

[Jagat Pavasia]

hi ,
I have number in cell from C6 to C2500. something like 255, 240.50, 266.67, 312.25, 20.10 etc.

I had insert spin tool from developer and i want to spin only this number in my A1 cell.

so what i do ?




this is image of my worksheet

https://ibb.co/3r9pQCJ

 

[Yongle]

With numbers in range C6:C2500

Formula in A1
=IFERROR(IF(B1*C1=0,"",C1),"")

Formula in C1
=IFERROR(INDEX($C$6:$C$2500,MATCH(0,INDEX(COUNTIF($E$5:OFFSET($E$5,B1-1,0),$C$6:$C$2500),0,0),0)),"")

Spin Button format control settings
- Link cell is B1
- Minimum value = 0
- maximum value = 2495 - incremental change = 1


In picture below you can see in column E what happens every Spin (click)
Shaded cells in column C are dupllicte values (which are ignored)
Row 10 is what happens on Spin 5Excel 2016 (Windows) 32 bit

	A​	B​	C​	D​	E​	F​
1​	12​	5​	12​
2​
3​
4​
5​			Data	Click​	Value in A1​
6​			11​	_01​	11​
7​			13​	_02​	13​
8​			16​	_03​	16​
9​			20​	_04​	20​
10​			12​	_05​	12​	5th click
11​			15​	_06​	15​
12​			15​	_07​	14​
13​			15​	_08​	10​
14​			13​	_09​	98​
15​			15​	_10​	96​
16​			12​	_11​	94​
17​			12​	_12​	93​
18​			16​	_13​	91​
19​			16​	_14​	95​
20​			15​	_15​	90​
21​			14​	_16​	99​
22​			16​	_17​	92​
23​			10​	_18​	97​
24​			14​	_19​	123​
25​			12​	_20​	161​

Sheet: Sheet3