Hi all,
In the attached picture, the first column shows a word which was used as a stimulus word for a language experiment. In the rows are response words given to these stimuli. I want to extract the row for each stimulus word which has the maximum column E value. I would like Excel to return this to me in a new sheet, which would contain only one row per stimulus word. For example, the row for the stimulus word "a" would contain only "an" (and the data from each of the other 3 columns); the row for "aardvark" would contain only "animal", and the row for "abacus" would contain only "math".
Can anyone help?
Thanks
Peter
In the attached picture, the first column shows a word which was used as a stimulus word for a language experiment. In the rows are response words given to these stimuli. I want to extract the row for each stimulus word which has the maximum column E value. I would like Excel to return this to me in a new sheet, which would contain only one row per stimulus word. For example, the row for the stimulus word "a" would contain only "an" (and the data from each of the other 3 columns); the row for "aardvark" would contain only "animal", and the row for "abacus" would contain only "math".
Can anyone help?
Thanks
Peter