Thread: Subtract a max value from a row then copy that columns title?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
dim dim is offline
external usenet poster
  
Posts: 123
Default Subtract a max value from a row then copy that columns title?
Hi,

I've been trying this with variations of the =MAX function but cant get it
to work... :-(

I have a row of text entries as column titles in every second column, e.g:
A1, C1, E1, G1 etc

Below those text titles, I have numeric values. e.g: A2, C2, E2, G2 etc

I want to get the highest number from row 2, and then display the column
title from that row......

.......any ideas?


Reply With QuoteReply With Quote