Hi I am confused as to which function would be best suited for the following situation. I have tried using vlookup, indirect, index, match and max with no success. I havent used excel since college in 2005. I have a feeling this is a fairly simple funtion but I have exhausted my brain digging through step by step books and watching you tube videos. I feel that if I had a good starting point with some tips that I could disect myself I would have a much better understanding of what is required and where.
My immediate goal is have row B3:B13 automatically display the coresponding row categories for the greatest values column. I can use the max function just fine to locate the greatest number.... I dont know how to properly forward the numeric value to read as the text.
Thanks,
Brad
<colgroup><col style="width: 60pt; margin-left: 40px; mso-width-source: userset; mso-width-alt: 2925;" width="80"> <col style="width: 132pt; margin-left: 40px; mso-width-source: userset; mso-width-alt: 6436;" width="176"> <col style="width: 153pt; margin-left: 40px; mso-width-source: userset; mso-width-alt: 7460;" width="204"> <col style="width: 128pt; margin-left: 40px; mso-width-source: userset; mso-width-alt: 6253;" width="171"> <col style="width: 95pt; margin-left: 40px; mso-width-source: userset; mso-width-alt: 4608;" width="126"> <col style="width: 80pt; margin-left: 40px; mso-width-source: userset; mso-width-alt: 3876;" width="106"> <col style="width: 68pt; margin-left: 40px; mso-width-source: userset; mso-width-alt: 3291;" width="90"> <col style="width: 72pt; margin-left: 40px; mso-width-source: userset; mso-width-alt: 3510;" width="96"> <col style="width: 76pt; margin-left: 40px; mso-width-source: userset; mso-width-alt: 3693;" width="101"> <col style="width: 143pt; margin-left: 40px; mso-width-source: userset; mso-width-alt: 6985;" width="191"> <tbody>
</tbody>
My immediate goal is have row B3:B13 automatically display the coresponding row categories for the greatest values column. I can use the max function just fine to locate the greatest number.... I dont know how to properly forward the numeric value to read as the text.
Thanks,
Brad
| | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Week Totals |
1 | damaged blue seal on rack | 0 | 1 | 2 | 0 | 0 | 0 | 4 | 7 |
2 | damaged worm | 0 | 1 | 1 | 0 | 0 | 10 | 0 | 12 |
3 | Dropped Gear or Component | 1 | 2 | 2 | 4 | 1 | 1 | 0 | 11 |
4 | High Pressure Smashed Poppet | 5 | 9 | 4 | 6 | 1 | 0 | 0 | 25 |
5 | incorrect assembly | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 3 |
6 | misc unknown | 0 | 0 | 2 | 0 | 2 | 0 | 6 | 10 |
7 | missing sector plug | 1 | 1 | 6 | 0 | 1 | 4 | 4 | 17 |
8 | missing shipping components | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 4 |
9 | preload set incorrectly | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 2 |
10 | Stranded gear | 0 | 0 | 2 | 0 | 0 | 0 | 7 | 9 |
11 | Stripped Threads | 1 | 1 | 1 | 5 | 0 | 4 | 0 | 12 |
12 | Total Avoidable Rejects/Day: | 11 | 17 | 23 | 16 | 5 | 19 | 21 | 112 |
13 | Main Issue: | High Pressure Smashed Poppets | Dropped Gear or Component | Missing Sector Plug | Stripped Threads | misc unknown | damaged worm | stripped threads | High-pressure/Smashed Poppet |
<colgroup><col style="width: 60pt; margin-left: 40px; mso-width-source: userset; mso-width-alt: 2925;" width="80"> <col style="width: 132pt; margin-left: 40px; mso-width-source: userset; mso-width-alt: 6436;" width="176"> <col style="width: 153pt; margin-left: 40px; mso-width-source: userset; mso-width-alt: 7460;" width="204"> <col style="width: 128pt; margin-left: 40px; mso-width-source: userset; mso-width-alt: 6253;" width="171"> <col style="width: 95pt; margin-left: 40px; mso-width-source: userset; mso-width-alt: 4608;" width="126"> <col style="width: 80pt; margin-left: 40px; mso-width-source: userset; mso-width-alt: 3876;" width="106"> <col style="width: 68pt; margin-left: 40px; mso-width-source: userset; mso-width-alt: 3291;" width="90"> <col style="width: 72pt; margin-left: 40px; mso-width-source: userset; mso-width-alt: 3510;" width="96"> <col style="width: 76pt; margin-left: 40px; mso-width-source: userset; mso-width-alt: 3693;" width="101"> <col style="width: 143pt; margin-left: 40px; mso-width-source: userset; mso-width-alt: 6985;" width="191"> <tbody>
</tbody>