Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
AlexM
 
Posts: n/a
Default Looking up data




Baically, I have a worksheet with names of consultants in the first
column, and then question numbers at the top of the following columns.
Each question could have an answer of 1 - 4, grading the responses
given for service. 1 is excellent.

How do I find out how many 'excellents' a particular consultant has
received for a particular question? I have looked at Vlookup,
Getpivotdata and others, with no joy.


--
AlexM
------------------------------------------------------------------------
AlexM's Profile: http://www.excelforum.com/member.php...o&userid=34833
View this thread: http://www.excelforum.com/showthread...hreadid=545829

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pull data from another sheet based on certain criteria steve_sr2 Excel Discussion (Misc queries) 1 February 23rd 06 10:08 AM
Importing Data Jillian Excel Worksheet Functions 9 December 23rd 05 12:45 PM
Help PLEASE! Not sure what answer is: Match? Index? Other? baz Excel Worksheet Functions 7 September 3rd 05 03:47 PM
Saving data in a worksheet within a workbook Homeuser Excel Discussion (Misc queries) 2 August 21st 05 10:49 PM
Line Graph Data Recognition Nat Charts and Charting in Excel 2 April 30th 05 02:07 PM


All times are GMT +1. The time now is 04:27 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"