I know this is an Excel board and I'm sorry but I hoping that someone can still help.
Any ideas how I can right a query that will just select all values in a table apart from the lowest and highest 5% of values for a certain field.
For example, suppose the table contained salary details, how could I ignore the lowest paid 5% and the highest paid 5%.
Thanks in advance.
Any ideas how I can right a query that will just select all values in a table apart from the lowest and highest 5% of values for a certain field.
For example, suppose the table contained salary details, how could I ignore the lowest paid 5% and the highest paid 5%.
Thanks in advance.