|
|
#2
01-22-2021, 12:07 AM
|
|||
|
|||
Why make this so difficult?
A list of all goods/fruits has an additional bonus, as you can use data validation to ensure no typos mess up with your data. (I leave it to you to figure out what to do when there are several goods with same count - currently Bananas and Oranges must share order numbers 6 and 7, instead 7 they both have initially. What about when you have such a pair/trio/whatever somewhere at top 3 positions?) 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Help using Index match for below | Maneesh Joshi | Excel | 2 | 11-29-2018 06:23 AM |
| Excel - Index and Match Function ,First Second and Third Match | paulzy95 | Excel | 10 | 09-29-2016 10:46 PM |
| index / match Formula | dmcg9760 | Excel Programming | 1 | 11-08-2015 03:16 PM |
| Index match vba | grexcelman | Excel | 0 | 03-05-2015 10:55 PM |
 Vlookup, offset, match & countif
|
jujuwillis | Excel | 2 | 10-15-2011 11:06 AM |
Windows 8 
Office 2016
Threaded Mode