Example: [Newsgroup Microsoft.Public.Excel.Programming 8-Mar-2009 22:14] Well, I have a list of data from an experiment I did which includes subjects, different stimuli and reaction time to the stimuli (the stimuli comes in numbers). Each subject had a number of stimuli, and he had to repeat the same thing 10 times. for example: subject A had 100 stimuli, from which 10 stimuli where number 1, another 10 where number 2 and so on... The list of the data is a big array that includes the following:
Column A - the subject's name (in a coded form), Column B is the stimulous number, and Column C is the reaction time to the stimulous. I'm searching for a formula (i don't care if the solution is in a form of a formula or VBA), that would return the median of the reaction time to a certain stimuli for a specific subject. Something in the form of 'if Subject = A' and 'Stimuli = 1" then return the median of the reaction times.