Hi Guys,
I am a geologist from Australia, and almost a complete newbie on Excel.
I am just trying to create a filter function that will allow me to manipulate data based on both different row and column values.
The spreadsheet example I have attached shows the drillhole number (Hole_ID), from (Depth_From) and to (Depth_To) depths and metal values (Au_ppm and Cu_ppm).
What I want to create is a filter that says:
IF D2>D3 AND F2>5000
I want to be able to apply this filter to the entire spreadsheet and display the filtered results. I tried to put in the formula numerous times but I always seem to have the syntax incorrect.
This filter would tell me which drillholes finished in certain copper values (and probably should be drilled deeper).
On my example spreadsheet there should be two holes that finish in copper mineralisation greater than 5000ppm, these are BEN1081 and BEN1082. And I would like to be able to display these filtered results.
I am unsure if it is best to use filter function or another function to achieve these results?
Thanks very much for any help guys.
Bookmarks