-
To whom may be able to assist. I am currently working on defining a function/automated process for generating sample intervals from a data set of intervals created from a drill hole. The data that has been captured is the 'rock type' and can stretch over 0.1-10's of metres. When sampling...
-
I am working with drug data, and the data entry conventions are ... unconventional. Multiple spacing, single spacing, hyphens, slashes ... I've got it all. My problem is that I can identify a small handful of patterns that follow the data I want to extract (drug strength), but nothing unique that...
-
Hi All: Looking for some help on this: Here is what I put in for the formulate but I get this error in my AS INITIAL OFFER BOX: #VALUE! Here is what I have for the formula to start with so far but it is not working (once I got it working, then I was planning on addition other ranges): =IF(AT1<3499...
-
I currently have a formula (Below) that checks tolerances and determains if the number passes a criteria where V$2 is 0 and W$2 is 4. I would like to add an "If Blank" return True/Blank(havent decided yet) statement but cannot find a place to put it where it will work. =IF(OR((AND(V7*0.95<...
-
I have 3 sheets in my excel document. The first one is the main form and the other 2 are summaries that need to be populated and distributed the correct person depending if one value on Sheet1 begins with a letter between A-O or P-Z. What I need on each summary sheet is this sequence: On Sheet 2 in Cell...