ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   return a list (https://www.excelbanter.com/excel-worksheet-functions/68048-return-list.html)

goodmike

return a list
 

I have a list of 550 employees, six performance measures, some if(and)
statements and want to return a list of names that exceed a given
performance score. what's the easiest way to have excel return a list
of resultd for a formula?? goodmike


--
goodmike
------------------------------------------------------------------------
goodmike's Profile: http://www.excelforum.com/member.php...o&userid=30936
View this thread: http://www.excelforum.com/showthread...hreadid=506082


Anne Troy

return a list
 
Use Autofilter.
http://www.officearticles.com/excel/...soft_excel.htm
************
Hope it helps!
Anne Troy
www.OfficeArticles.com

"goodmike" wrote in
message ...

I have a list of 550 employees, six performance measures, some if(and)
statements and want to return a list of names that exceed a given
performance score. what's the easiest way to have excel return a list
of resultd for a formula?? goodmike


--
goodmike
------------------------------------------------------------------------
goodmike's Profile:
http://www.excelforum.com/member.php...o&userid=30936
View this thread: http://www.excelforum.com/showthread...hreadid=506082





All times are GMT +1. The time now is 01:24 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com