I am trying to create a method to compare pricing on 2 products from 4 sources.
Here is what I'm thinking but am not sure if the thinking is right here is
how I'm thinking of proceeding:

1. The label of the 4 columns changes so I need to try to determine the
value of each column before comparing highest price.
2. I want to copy the 10 values and paste them into a result table.
3. Compare a value in each of the 4 tables and paste the highest value in
the result table.

I am trying to produce this output table daily thus I think I need to add
some functions into the work sheet?

Any ideas?

Thank you in advance

John wrote:
I am trying to create a method to compare pricing on 2 products from 4 sources.
Here is what I'm thinking but am not sure if the thinking is right here is
how I'm thinking of proceeding:
1. The label of the 4 columns changes so I need to try to determine the
value of each column before comparing highest price.
2. I want to copy the 10 values and paste them into a result table.
3. Compare a value in each of the 4 tables and paste the highest value in
the result table.
I am trying to produce this output table daily thus I think I need to add
some functions into the work sheet?

.. 2 products from 4 sources .. the 10 values ..

Seems like you need only multiple =MAX(range) functions.


----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! 100,000 Newsgroups
---= East/West-Coast Server Farms - Total Privacy via Encryption =---