We use a spreadsheet to assemble vendor quotes.
Depending on the number of price breaks desired, we need to add a lead-time column for that quote, and illustrate the longest lead time for that part from a variety of non consecutive columns.
The summary, would have a formula such as: =MAX(B3,E3,H3,K3) to provide the longest lead-time for the part. That vendors prices would be in columns C,D,G,H,I,J etc.
Problem arises, if we add a vendor to the group, the MAX formula will not include any new fields without manually adding a cell reference from the new group to the MAX formula.
The MAX cell references can be spaced x number of columns apart, and can be anywhere from 2-10, but always the same on any particular spreadsheet.
So, how to have our MAX formula automatically include the new columns added or deleted from the spreadsheet?
TIA for any ideas.
Pete
Bookmarks