-
Date functions in Excel make it is possible to perform date calculations, like addition or subtraction, resulting in automated or semi-automated worksheets. When you mix date functions with conditional formatting, you can create spreadsheets that display date alerts automatically when a deadline is near...
-
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 use Excel 2007 and want to capture the last 8 digits of an accounting code located in cell A1. I put this formula =RIGHT(A1,8) in cell A2. According to the formula help information, my entry is correct. However, when I hit enter, the formula remains in cell A2. No results appear. Both cells A1 and...
-
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<...
-
Hi. I need help with a type of counting problem. I have a huge excel data file with over 50,000 data entry points. It is forex data. I have a list of several banks. And their trade dates, and a bunch of other information columns that are cost, volume, what currency traded in, and more complicated diagnostic...
-
Hello again! Wondering if its possible with the same example to actually count the distinct values in the given column I'm aware that I can get distinct count (including text) by saying: =SUM(IF(FREQUENCY(IF(LEN(H3:H11243)>0,MATCH(H3:H11243,H3:H11243,0),""), IF(LEN(H3:H11243)>0,MATCH...
-
Hello, Would highly like if you could shed some light on how I can accomplish this. My sheet has three segments. The first being a selection for the users (the user can choose which category they want to view the reports for): Selection # Category Include? 1 Electricals Yes 2 Paper Yes 3 Food Yes 4 Beverages...
-
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...