Please feel free to reply with a question in the body of the message. Also
provide example data and desired results.
You might want to provide some justification for calculating across columns
rather than across rows. Any calculations across columns suggests an
unnormalized table structure.
I have 52 weeks of sales per item number. As they come out of our master
files each week is in a separate column. I need to find the maximum amount
of sales out of these 52 fields.
Have you considered using Excel? It works great on these spreadsheet style
operations!
I do have a function which will accept multiple values as a parameter array,
and identify the maximum value from among those values. If you would like me
to send you the function, let me know.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
