Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Needing ideas on how to do this
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Needing ideas on how to do this
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 =--- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Needing to know what formula to use | Excel Worksheet Functions | |||
Needing a formula | Excel Discussion (Misc queries) | |||
NEEDING FORMULA Please | Excel Worksheet Functions | |||
Needing Help Very Bad | Excel Worksheet Functions | |||
VBA newb needing help with an IF | Excel Programming |