We have predefined list of countries and their revenue. I am looking for a functionality where a user gives a random number of his choice in a input box. then the excel has to pick the countries that are less than the revenue given and write them to seperate cells, then a spreadsheet table has been setup to show the resultant countries to the user. Here I have included few screenshots.
Pre-Defined Revenue values:
So according to this, 43270 is revenue given by user and the excel has to write, Germany Spain and Norway to seperate cells.
Any inputs are greatly appreciated. Thanks in advance 😊