excel formulas

Hi, I'm in need of some help that is beyond my excel skill base at this point. Below you'll see I have two sections, which represent two worksheets. What I need is a formula that will in section 1, under the IDENTIFIER Column pull from all of column A (Transaction detail) all IDENTIFIERS...

Hi All, I am trying to compare two excel workbooks using excel formula. The data in both the excel workbook is not same always. Example: Excel workbook1 has the below columns and the data Task Name Job Department Wing Shift Hours Cost Assign Wing 1...

Ok guys I have a questions that I hope you can help with. I have a pivot table that has this information among other values <tbody> Months Agent Code 4 AA1234567 4 AA2345678 5 AA3456789 28 AA4567891 29 AA5678912 1 AA6789123 </tbody> What I am trying to accomplish is write a...

Hi, Is it possible to have a data validation that includes a date and a text. For example, I want the users to have the option of only inputting a date, "continuous audit", "No physical inventory" or "No response received" in a cell. Is this possible? or is there any other way to do this, I...

I am facing problems regarding errors while entering data and other entities into excel sheets. Excel sheets accept all the values entered by default; be it a right value or a wrong one which results into inconsistencies and irregularities in the sheets. In order to cope-up with such issues we...

Hey....I'm trying to figure out the best way to make a summary sheet from an export. The software exports the date similarly to the data below: <tbody> name job cost date days bob hurst 35 3-Jan 99 bob miller 72 9-Jan 93 john race 54 13-Jan 89 steve hurst 68 18-Jan 84 john race 52...

Is it possible to have a formula that makes a cell get information from a specific position relative to itself so that even if you add rows it will still look at, for instance, the cell 4 down and two to the right? Example I want cell A9 to show the information that is in cell D14 even if I...

I have an issue with a worksheet I'm using. Currently I have two sheets in my workbook. One worksheet I use to mark with an X if an employee arrives. The other sheet date and time stamps the actual time they arrive after I mark the related cell with an X. I accomplish this today with a few...

=IF(OR(IF(MONTH(B25>B24),C$3+F24,F24),(IF(MONTH(B25=B24),F24,C$3+F24))) Basically I want a result for the or function, not true or false. However it keeps saying I don't have parenthesis in the right spot. The 2 IF functions are different but the answers for the IF function are the same. Can...

I have a pivot table with report filter field. I need to do some operations based on the value user selects in report filter field. If user selects single value (or selects <code style="margin: 0px; padding: 1px 5px; border: 0px; font-size: 13px; font-family: Consolas, Menlo, Monaco, 'Lucida...

​i want the sequence from Filename column to appear as range in the next column is there any formula to do this i need a formula to get the highlighted values from the Filename Column <tbody> Date Box.no Filename Range 1/10/2014 1000 5000132355 5000132355-5000132363 1/10/2014 1000...

Hello, I've been searching for hours for a formula that will pull the last 10 entries in a column, but these entries would have to be greater than zero. Would really appreciate your help!

Hi there!! I have a “soft copy” of an 80-page report that was downloaded from an older mainframe system. The soft copy was in a .txt format, and I imported it into Excel using fixed-width delimiters for the columns. Since the report is 80-pages, it translates to almost 2,000 rows of data in...

Hi! I have a Form to be filled and i receive the data as .txt files, hence have to convert data from txt to excel format for the ease of copying to my target form easily. Now i have managed to convert the file to excel, but certain formats are really confusing. I would be grateful if someone...

<colgroup><col width="835" style="width: 626pt; mso-width-source: userset; mso-width-alt: 30537;"> <tbody> In F2, I have entered formula IF(B2="","",IF(COUNTIF(B$2:B2,B2)=1,SUMIF($B$2:$B$7,$B2,E$2:$E7),"")) to give the sum of E2. I have dragged it down to F7 to give the sum of column...

Hello, I am reaching out to all the wonderfully helpful people on this site with another request. I have already received some excellent help with one of the formulas I needed. Here is another problem I have here: Essentially I am trying to make a smart chart with formulas to automatically fill...

Hi all, I have two workbooks, one consolidated data sheet with about a 100 names like this: Home - imghst free image hosting - View Image and I have to generate one workbook per name with the data and Chart for each name from the Source book as in the below image: Home - imghst free image...

Hi All, Had to know if the frequency array function can be applied for a text which we can by using the following formula "=SUM(IF(FREQUENCY(IF(LEN(A2:A10)>0,MATCH(A2:A10,A2:A10,0),""), IF(LEN(A2:A10)>0,MATCH(A2:A10,A2:A10,0),""))>0,1))" which gives the unique occurrences of text in column A...

Good day, I hope someone can help me. I need a formula to use on MS Excel 2007 to remove the English letters from a cell A1 and return only the numbers(if any) & Chinese characters to B1. Please refer to the able below. I would appreciate an immediate response and would be grateful fr any...

HELP-NEW USER NEED EXCEL FORMULA? The students have been labeled a1, a2 etc.. Their grades are in b, c d e etc.. In column h the percentage change between test 1 and test 2, grades are already in percentage so normally c7-b7 is the percentage Problem: in A 13 for example excel assumes a zero...