Returning a column and row location

Closed
Robert - Jun 2, 2011 at 02:56 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 2, 2011 at 05:53 PM
Hello,


I Have a 2 tables that are identical (3 column by 11 rows) that have unsorted data.
I set up a formula to take an inputed row number and return the max of the columns.

How would I use that output to locate data from the other table that is in the same location.

And if the number from the first table search is located in more than one column return the maximum from the secound column.

Thanks for your Help.



1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jun 2, 2011 at 05:53 PM
Could you please upload a sample EXCEL file WITH sample data, macro, formula , conditional formatting etc on some shared site like http://docs.google.com, http://wikisend.com/ , http://www.editgrid.com etc
AND post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book, could you re-explain your problem too.


Note: your data need not be to be real data but a good representative of how data looks like
0