Pull list from an existing column

[malibukid71]

Hello everyone,
I'm pretty sure I've seen this done before but it was long ago. I have a report that generates version numbers that I get every day that is saved as a CSV file (ex.1). I also have made an excel spreadsheet that shows numbers and percentages on these versions (ex.2). Right now I have the version # in ex.2 manually typed in but i would like to do a formula that will generated the version numbers for me. I'm wanting to do this so if a new version comes into the mix I don't have to manually up date the formula will add it automatically. Any ideas? I'm using Excel 2019.

ex.1

ex.2

 

[ExceLoki]

try this
-------------

Book1
	A	B
1	Version#	unique version#
2	2248	2248
3	2248	2275
4	2275	2283
5	2283	2247
6	2247	2213
7	2213
8	2275
9	2247
10	2283
Sheet1

Cell Formulas
Range	Formula
B2:B10	B2	=IFERROR(INDEX($A$2:$A$10, MATCH(0,COUNTIF($B$1:B1, $A$2:$A$10), 0)),"")