ben

Hi I know pivot table can bring the result but I need formula to bring unique name list in column B from list of Names in column A, please share any formula Column A John Ben John Ben Ben John Peter Peter Column B John Ben Peter

Hi, I am exporting from a database as a csv which provides the following ID,NAME,RATING <tbody> ID1 BEN 1 ID2 BEN 1 ID3 BEN 2 ID4 BEN 3 ID5 JAMES 1 ID1 SAM 1 ID4 SAM 2 ID2 DAN 1 ID9 DAN 2 ID10 DAN 2 </tbody> I need to transform this into the following <tbody> ID1 ID2 ID3...

Hi, I have a table created from some CSV data that looks like this <thead style="margin-left: 0px; margin-right: 0px; margin-top: 0px;"> Foo Bar text </thead><tbody style="margin-left: 0px; margin-right: 0px; margin-bottom: 0px;"> ham ben dave egg mark james sam cheese frank rob...

Good Morning Sir, My name is Ben I have two file one is excel sheet ( mastersheet) and other is power point. I made a chart in excel sheet according to table . I copied this excel chart and paste in the powerpoint. My question is : when I am changing the value in excel sheet table , I want...

<tbody> Description BILL BEN JOHN DAVE FRED CHEAPEST PRODUCT A £0.20 £0.33 £0.14 £0.18 £0.16 £0.14 </tbody> Hi All, I am looking for help with a formula, which I am pretty sure is quite simple for someone out there. I have a table of data and then using the =MIN(A2,A3,A4…...

I have been working on an Excel workbook for booking talks in various locations and a variety of talks. This is to replace a small database programme that only works on Windows systems (PC or laptop) and only allows me to look at 15 weeks worth of data at a time and doesn't allow me to easily...

Hi all, I have a chart Column A with bunch of names, and i want to highlight all the duplicated names, in different colors. Below example, I want to highlight Ben maybe in red and John in Green and Joe in Blue (random colors) Is it possible? using Excel 2010 Column A Ben Ben John Carlie Troy...

Hi! I have a list of drug prescriptions that I'm trying to categorize. The list includes: name of patient, drug prescribed, date of prescription, and how long the prescription lasts. Each person has multiple drug prescriptions and may even change his prescribed drug during the study period. Is...

Hi all, I am trying to put together a solution to total the all time result between all unique player combinations. I have provided examples of my data in the first table below, and what I'm trying to accomplish in the second table. First row is column letters, so the second row is actually...

Hi All, I'm not an excel expert and I have limited knowledge. I have two sheets of data. The first sheet of Data looks like this <tbody> Name CallIN Abandoned Outbound Joe 30 3 25 Joe 20 7 12 Joe 15 2 2 Ben 3 17 0 Ben 8 2 15 Mo 12 15 7 </tbody> On another sheet I...

Hi, I have multiple sheet in given workbook. Each sheet filled with Column A:E with same number of rows. I would like to combine all these sheets into one sheet and highlight the row for the column header named as "Order" with "Yes" option. Sheet1 <colgroup><col...

Hi there, I have a numbers and text in a single cell (call it A1), namely: "L-HQ-0001,Entrance Foyer" I would like to split the string so that in cell B1 it would return the following result: "L-HQ-001" Therefore, removing the text along with the comma. Any assistance would be gratefully...

Hi All, Please can you assist. I am trying to pull a number of rows and columns together based on criteria within a INDEX,MATCH formula. <tbody> A B C D E Code Name Jan-17 Feb-17 Mar-17 0 John 10 20 30 1 John 20 30 40 2 John 30 40 50 0 Ben 5 10 15 1...

Hi I need to create a cumulative pivot table chart. I've created a simple example of what I'm trying to do using the 9 rows of data below: <colgroup><col width="64" span="7" style="width: 48pt;"></colgroup><tbody> Client User Hours State Billable FY FYmonth CLAN Ben 10 Approved...

I'm trying to copy C4 thru C19 from sheet (Sign Up) to sheet (16 Man Bracket) column AC. Need it to start on row 8 then skip a row 3 times then skip 3 rows and repeat until all 16 have been pasted per example below. I used macro recorder to do this but after reading on this forum that isn't the...