I have a spreadsheet which is a glorified version of the following
I want to take the lowest value from the green columns and place in the orange section to the right, excluding any errors, blanks or zero values. Then, in the red section I want excel to retrieve the supplier (name section in blue) that the lowest price corresponds to.
Any ideas please?! I tried nested if statements but run out of room (excel only allows 7 nested statements I believe) - there's quite a lot of suppliers and over 2000 rows of data.
![]()


LinkBack URL
About LinkBacks
Reply With Quote

SCAN.care@HEXUS
