Hello all,
I have an Excel problem that I can't figure out. I think it involves a few steps, and actually I'm not sure if Excel is able to do it... hopefully someone on here can help me, or at least tell me if it's possible!
I have a sheet with data, below is a smaller version:
<tbody>
</tbody>
I need to find the Max Au value in each hole - for example the max Au for 2018PJAC001 will be 663. I then need to find the Depth From value that corresponds to the Max Au value - in this case the answer is 12.
Things to note:
- The real sheet has over 4000 rows of data, and there are 331 holes, so there could be values in the Au column that are the same (I don't think a MATCH formula will work....)
-I've used a pivot table to find the max value in each hole, but can't return the corresponding Depth From value that the answer came from...
This is the first step of my problem. I will post the next part if this part can be solved!
Fingers crossed it's possible
Thanks
Ntbok
I have an Excel problem that I can't figure out. I think it involves a few steps, and actually I'm not sure if Excel is able to do it... hopefully someone on here can help me, or at least tell me if it's possible!
I have a sheet with data, below is a smaller version:
Hole ID | Depth from | Depth to | Au | As |
2018PJAC001 | 0 | 4 | 17 | 5 |
2018PJAC001 | 4 | 8 | 5 | 10 |
2018PJAC001 | 8 | 12 | 12 | 20 |
2018PJAC001 | 12 | 16 | 663 | 50 |
2018PJAC001 | 16 | 20 | 96 | 100 |
2018PJAC002 | 0 | 4 | 20 | 50 |
2018PJAC002 | 4 | 8 | 3 | 75 |
2018PJAC002 | 8 | 12 | 8 | 10 |
2018PJAC002 | 12 | 16 | 12 | 15 |
2018PJAC002 | 16 | 20 | 1 | 25 |
2018PJAC003 | 0 | 4 | 0 | 40 |
2018PJAC003 | 4 | 8 | 0 | 50 |
2018PJAC003 | 8 | 12 | 5 | 10 |
2018PJAC003 | 12 | 16 | 1 | 0 |
2018PJAC003 | 16 | 20 | 87 | 5 |
2018PJAC003 | 20 | 24 | 5 | 50 |
2018PJAC003 | 24 | 28 | 6 | 50 |
2018PJAC003 | 28 | 32 | 16 | 40 |
2018PJAC004 | 0 | 4 | 13 | 80 |
2018PJAC004 | 4 | 8 | 227 | 50 |
2018PJAC004 | 8 | 12 | 145 | 10 |
2018PJAC005 | 0 | 4 | 63 | 10 |
2018PJAC005 | 4 | 8 | 12 | 0 |
2018PJAC005 | 8 | 12 | 11 | 0 |
2018PJAC005 | 12 | 16 | 25 | 0 |
2018PJAC005 | 16 | 20 | 62 | 165 |
2018PJAC005 | 20 | 24 | 21 | 180 |
2018PJAC005 | 24 | 28 | 47 | 50 |
2018PJAC005 | 28 | 32 | 6 | 40 |
2018PJAC005 | 32 | 36 | 5 | 60 |
2018PJAC005 | 36 | 40 | 9 | 10 |
<tbody>
</tbody>
I need to find the Max Au value in each hole - for example the max Au for 2018PJAC001 will be 663. I then need to find the Depth From value that corresponds to the Max Au value - in this case the answer is 12.
Things to note:
- The real sheet has over 4000 rows of data, and there are 331 holes, so there could be values in the Au column that are the same (I don't think a MATCH formula will work....)
-I've used a pivot table to find the max value in each hole, but can't return the corresponding Depth From value that the answer came from...
This is the first step of my problem. I will post the next part if this part can be solved!
Fingers crossed it's possible
Thanks
Ntbok