Hijrofoyle
New Member
- Joined
- Oct 7, 2002
- Messages
- 35
Hey, bit of a mouthfull but i'm a little desperate:
I've got Sir's reply to work and in the box it will display an address for the data that i'm looking for (say it's J12904) now i want to use another cell to show the data that is in J12904, without actually typing in J12904, i'd rather refer to the cell that told me where the max data is.
For example Sir said that i had to use the formula:
=ADDRESS(MAX(IF(J14:J29804=MAX(J14:J29804),ROW(J14:J29804))),COLUMN(J14:J29804),4)
and it would return the address of the Maximum value in that column. Now say i typed the above formula into Cell J30,000, and I it displays J1200 as the answer, and in cell J1200 the number is, say 9. Now i want cell J31,000 to display the data contained in J1200, without typing in =J1200. But when i use =J30,000, it returns J1200, instead of 9 like i want, any ideas?
I've got Sir's reply to work and in the box it will display an address for the data that i'm looking for (say it's J12904) now i want to use another cell to show the data that is in J12904, without actually typing in J12904, i'd rather refer to the cell that told me where the max data is.
For example Sir said that i had to use the formula:
=ADDRESS(MAX(IF(J14:J29804=MAX(J14:J29804),ROW(J14:J29804))),COLUMN(J14:J29804),4)
and it would return the address of the Maximum value in that column. Now say i typed the above formula into Cell J30,000, and I it displays J1200 as the answer, and in cell J1200 the number is, say 9. Now i want cell J31,000 to display the data contained in J1200, without typing in =J1200. But when i use =J30,000, it returns J1200, instead of 9 like i want, any ideas?