hai all
I have an excel file with some suppliers for different items with their quoted prices. Actually I have projected a sample file but the real one had a large data. I have to find out number of least quoted items per supplier.
Kindly help me out. Thanks in advance.
regards
shankar sb
Last edited by AliGW; 01-25-2018 at 02:24 AM. Reason: E-mail removed.
Nobody is going to contact you via E-mail. So that you do not get spammed, I have removed your E-mail address from your post.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
May be something like this
In F2 type
and copy down.=MIN(C2:E2)
Teach me Excel VBA
thank you very much for your valuable reply. I have tried and I got the least value in the row. One more thing I required is, that low value quoted supplier name to be comes to the next column. Can it be possible ?
regards
Last edited by AliGW; 01-31-2018 at 02:30 AM. Reason: Unnecessary quotation removed.
Try this =INDEX($C$1:$E$1,MATCH(F2,C2:E2,0))
and copy down
Last edited by AliGW; 01-31-2018 at 02:30 AM. Reason: Unnecessary quotation removed.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks