Skip to Content
0
Former Member
Jun 04, 2013 at 06:49 PM

Display Countries According to Revenue Input

21 Views

Hello Everyone,

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 😊

Attachments

Untitled.png (1.2 kB)
Untitled.png (3.7 kB)