sam

Hi, Bit of a complicated one to explain, but I would appreciate any help if possible? <tbody> Name 22 (Days in Month 1) 23 (Days in Month 2) Sam 5 2 James 12 14 Bob 20 17 Sam 18 20 Bob 2 14 </tbody> I need to be able to compare the names in Column A, find all the matches (if any)...

Hi All, First time on this forum and was hoping to get some help. I am trying to do a text to column but in vertical format instead of having it split horizontally. For example, My data now looks something like this. <tbody> Name Attributes Tom Male, Teen, Tall, Glasses, Black hair Henry...

Hi, say I have the following table: <tbody> Date Customer Orders 2-Jan Jennifer 2 15-Jan Robert 3 16-Jan Sam 1 17-Jan Hassan 6 18-Jan Jennifer 3 19-Jan Robert 2 22-Jan Sam 10 24-Jan Hassan 2 25-Jan Hassan 4 </tbody> It is possible to get Pivot Table data WITH VBA WITHOUT...

Hi all, I have a challenge that I cannot quite figure out... <tbody> COLA COLB COLC Ray 100,000 Mary Ray 50,000 John Sam 80,000 Sam 60,000 </tbody> I would like to have a sumproduct or sumif formula that can add up the total amount for each person. Where there are two names on a...

Hello, please i need you assistance to automaticaly filter data in a specific table based on the customer name and copy the filtered data related to this customer to another worksheet using VBA example: i need to automaticaly filter the projects by the name of the project owner and autocopy...

I'm struggling with what I think should be a simple function. Hoping someone can help. I want to use a Sumif focusing on the name. i.e. =SUMIF(B2:B29,"Brett",H2:H29). This equals 57.2 But I only want to smallest 3 numbers. i.e. =SUM(SMALL(H2:H29,{1,2,3})). This equals 1.64 So I thought I...

Hi Im a bit stuck on this one, i need to split a string based on a lowercase hitting an uppercase for example: Data Sam JonesPaul SmithEvan Angus WalshJon Smith Output Sam Jones;Paul Smith;Evan Angus Walsh;Jon Smith I have the data in column D and there will be 50000 + rows

<tbody> A B C D 1 SAM $1500 0.3% SMALL 2 TERRY $400 1.3% MEDIUM 3 JONES $1300 4.5% SMALL 4 ERIK $200 2.2% MICRO 5 SAM </tbody> I'm trying to make a formula that would copy information from earlier entries if they exists. So in this case, as soon as I've typed in SAM in A5...

Been trying to figure this out for a while and nothing seems to be working. I am trying to create a holiday tracker that counts weekdays in a week by week from a too and from date. The set up is as follows <tbody> Name Start Date End Date 16th Apr 23rd Apr 30th April John Smith 16th Apr 18...

Hi, i have two formulas =INDEX(Raw!A:A,COUNTA(Raw!A:A)+ROW(Raw!A:A)-ROW(),1) and =filter(Raw!B:B,Raw!$B:$B<>"Completed (Repairs completed, Available and safe to use)") is there a way that i can combine both formulas in one? thanks Sam

Hello All, I have a table with a list of names in column A and % in column B. I would like to know the average % of Sam. Then like wise with john. A John - 40% Sam - 50% Sam - 30% Sam - 10% John - 25% I'm sure this is a simple formula but I cant seem to get it right. Can you help?

Hey, I want to create a data validation list that only contain unique values. exp i have the below list on A2:A7 SAM Raviya juily Sam Albert Raviya So now i want to create a data validation list at H8 That count sam only once and same as raviya. Can any one help me out with...

Hi, I am using Excel 2003 on Windows 7. I have data like the below table, where there is a name in each of Columns B,C,D,E,F and I have concatenated columns B,C,D,E,F into column A. I included this data into a pivot table and what I am getting is 2 rows of data in the pivot table. 1 for...

Hello I need some help with either a formula or VBA macro to solve a conversion issue in a packaging table for tile. (Sample below) The challenge ahead of me is to convert all sales data to the same unit of measure so I can rank the number of pieces sold. the issue that makes this complicated...

I have 2 worksheets I need to combine - I need the data from the 2nd sheet that matches the first sheet to be put in the Post-test Q1, etc. So Sam from the second sheet would be ignored, Bob's data from 2nd sheet would be put into 1st sheet in appropriate place. Trying to match pre and post test...

Every day I get a file from another department like the layout in Sheet 1. I need a way to auto populate Sheet 2 which has the names as headers horizontally instead of vertically. Currently I am doing this manually. I've tried using Index/Match without success so I was maybe looking for...

Hi, My data are A B C D E 1 Type Person Product Total Status 2 AB Peter A 700 1 3 AN Sam B 800 2 4 AB John J 700 3 5 SG Luck A 400 1 6 AN Jam B...