I need to know how to find out the 'coordinates' of calculated values in a 'custom' coordinate system. I found an equation to find the 1st highest number in a set of data and I would like a formula/macro/etc to also give the corresponding coordinates of the 'axes' of the table. (Numbers 1 through 80 as shown in the picture)
Any thoughts?
http://img16.imageshack.us/my.php?im...lculateoz9.jpg
Last edited by semperfi360; 02-13-2009 at 12:17 PM.
Could be one way to go.
Not sure how familiar you are with VBA, if you want a breakdown of it, lemme know.
mew!
=IF(AND(OR(BLONDE,BRUNETTE,REDHEAD),OR(MY PLACE,HER PLACE),ME),BOW-CHICKA-BOW-WOW,ANOTHER NIGHT ON THE INTERNET)
I having trouble adapting it to my data...
See attached formulas in H2 ,I2 Value to look for in j2
note both formulas are array entered with ctrl shift enter
adjust ranges to suit
Excellent! I just got it working thanks very much for your help!Originally Posted by martindwilson
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks