formula & filter

My data set looks like this once I get it into pivot Customer Sell From Sell TO Item A UK UK pen Germany pen France pencil B US UK pen Germany pen C UK US...

Given the following snippet of a database: <tbody> sample # XDAT Horiz dy # max dy 1446 211 201.2 98 1447 211 202.2 68 1448 211 203.0 50 1614 200 135 40 1615 200 136 45 1616 200 130 35 </tbody> I would like to automatically fill in the "#" and "max dy" columns as...

I'd like to populate a cell with data based on the current month. If have this, which requires me to manually add the start and end dates =SUMIFS(B21:B34,A21:A34,">=2016-02-01",A21:A34,"<=2016-02-29") I have my dates in column A21 - A34 and my data in B21:B34 the datres are expressed as...

I want to give sum of working time at Time Period from Date N1 to Date O1. formula writes in N2 Cell. This is Formula : =SUMIFS($J:$J,$L:$L,1,$B:$B,B3,$F:$F,$N$1,$F:$F,$O$1) what is problem answer is zero <tbody> <colgroup><col span="2"><col><col><col><col><col><col><col><col><col><col><col...

Hi I have information in one sheet. I want to filter them with formula 3 times. 1. with Card No. 2. With Month 3. With Week and the last, I have personal report for one month or Week <tbody> Row No. Card No. Card&Row No. First Name Last Name Date Week Day Input Time Output Time Presence Time...

Hello guys! need some help By following this post http://www.mrexcel.com/forum/excel-questions/767607-extract-list-values-filtered-criteria-sub-arrays-tutorial-help.html I was able to extract date from one sheet to another based on 1 criteria. What I want to do now is extract data from two...

HI GUYS I AM NEW TO THIS FORUM I AM BALDY STUCK IN MAKING FORMULA IN EXCEL 2007. CAN ANY BODY TELL ME ? THIS IS THE SAMPLE DATA BELOW. I WANT TO COUNT THE " MEDIUM CELL VALUES" BASED ON " DISTRICT COLUMN VALUES" FOR EXAMPLE: IT WILL GAVE ME THE FINAL RESULT AS. DISTRICT--> JAMSHORO HAD...

Hello All, I am currently a dental student and we need to know a lot about Oral Pathology. What I want to create is a spreadsheet that can be used for differential diagnosis. What I mean by this is that I want to create a spreadsheet with a set of findings such as "inflammation"...

Hello I am working on a project that involves me sorting clients into various different groups based on parameters regarding what types of accounts they hold. I sorted the list down to the people who have two accounts and now I want to sort the original client info sheet down to this same...

I have a table that kind of looks like the one below. Over the top is departments and the rows are different items each department may need. The "X" indicates that department is in need of that items. Sales Marketing Finance Etc. Paper...

Hi everyone This one has been bugging me as I can't seem to get the right formula. I have access to an Excel table where an employee absences are recorded as 0% (or blank) for present all day, 100% for absent all day and degrees of in between for partial days. Don't have access to the hours...

Any better 'way' to write the below formula: =IF(AGG2=100,"i",IF(AGG2=200,"j",IF(AGC2=100,"p",IF(AGC2=-100,"q",IFERROR(CHOOSE(B2,"J","K","L","M"),0))))) Thanks in adv.

Hello, Can someone help structure a formula that would grab specific data. The index/match combined with offset does not seem to work, as the rows of data can vary, so its hard to use offset to target the data I need. Before and After examples are below: After (what I am trying to...

Hello, I'm trying to use excel to write a logical statement that will identfy a relationship within a set of data and determine a net resuelt from that data. Table 1: <TBODY> Date</SPAN> ID Number </SPAN> Rating</SPAN> Prize</SPAN> 8/2/2011</SPAN> 95</SPAN> 1</SPAN> ?</SPAN>...

Hi - I have a column which has names of businesses but some of them have the zip code attached to them. For example most cells are just ABC Company 123 Company Def Company But some are ABC Company90210 123 Company10011 Def Company20007 In all the cells that have zip codes, they are always 5...

I have a spreadsheet / database that has daily cash payment details. When payments are netted there is a common reference for the netted payments. When I filter and/or do a pivot table to sum the netted payments I am getting false results. Each payment is whole value to the cents. Meaning.01...

Hi, In Cell A1 i have some values like "Shoulder (cm) : XS: 37cm S: 38cm M: 39cm L: 40cm XL: 41cm XXL: 42cm..." i want to convert only cm values to inches and rest of the values would be same e.g. 37cm to 14.56in formula would be 1cm x 0.393701 so 37cm x 0.393701=14.5669. Please Help.

I have a spreadsheet with about 5000 postal codes. I don't need this many because I'm using this to create a map showing approximate delivery locations. So I would like to remove the postal codes which have the same first 3 characters. For example, here is a sample list: A0A 2J0 A0A 2M0 A0A...

I have a list of football results <tbody> Stoke 0 1 Aston Villa 1 0 West Brom 2 2 Sunderland 2 2 West Ham 0 1 Tottenham 1 0 Arsenal 2 1 Crystal Palace 1 2 Man Utd 1 2 Swansea 2 1 Leicester 2 2 These results continue and the team...

I have 2 excel sheets, both are csv files. I imported one from Outlook with names, emails and telephone no's, the other was from access with names and addresses. I want to merge them. The problem is there are some of the same names in both but not all. I want to be able to match the info of...