using Large when the cell has more than 15 digits

[Moxioron]

Hello.

I am trying to use Large to obtain the second largest number in a column with a condition. Since the total digits of numbers in that column = 16, I am getting #NUM! because I had to format the column as text in order for the numbers to display correctly.

Is there a way in Excel to keep the number in tact and format it as a number when it is greater than 15 digits so you can use formulas that are specific to values? Thanks.

=LARGE(FILTER($Q$4:$Q$100000,$B$4:$B$100000=$B4),2)

 

[Fluff]

What version of Excel are you using? Your profile shows 2019 which doesn't have the filter function.