I have a spread sheet containing laboratory test results. Using the MAX command I select the maximum value from a range of cells. I now need tob automatically select other data from cells in the same row as the selected max value.
ie If cell C300 contains the maximum value I need to automatically select data from cell G300, input both value into a table and use the values to calculate a result. This is done for 10 sets of data within the sprfeadsheet.
How do I find the cell reference for the determined maximum value so I can select other data from the same row?
Any ideas please
Bookmarks