tom

<tbody> Name Expense Harry 10 Danny 30 Micheal 160 Harry 28 Tom 22 Harry 32 </tbody> I need to get total expenses of Harry. Plese help

I have this and I need to get the first and last name out so I can use them for a vlookup please help Richard XXXXXX 1993446666 Tom XXXXXXX 1993444444 I am using this =RIGHT(G7,SEARCH("",G7,10)) but I need to use the name now

Hi, That title is probably not clear.... sorry in advance. I hope this will clear it up. I have Column B with 30 rows of Data and a Unique ID in Column "C" yes for example. This column is shorter in length than on Sheet 2 and contains a unique identifier in column 2. Sheet 1 Column B...

There are two columns in the data table, one includes the date and another one includes name like the one shown below. There is also a data table, which is a list of date. I would like to pick a name, let's say Tom, and count the no. of dates corresponding to Tom in the dates listed in the data...

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, I have in column D a list of employees names and last names: Mark Jones Tom Smith Robert Brown Lewis I need to split the names and last names and create two columns: <tbody> Names Last names Mark Jones Tom Smith Robert Brown Lewis </tbody> Can someone please help me...

Hello, I need help summing a range based on criteria. I've tried sumifs and sumproducts, but I can't get it right. The goal is to sum a range based on: Retailer, Brand, and the time period between two dates. The formula will go into cell B10 and reference a table on a different worksheet...

I'm trying to figure out a way for a User to select the names of workers that are in the office, then have VBA place those names in cells based on the value of another cell. I would like for the User to click a button on a form, that launches another form (let's call it...

I have a sheet with the following columns:- A B C D firstname lastname fullname active Col A & B are manual entry and C joins Col A & B together. Col D is a Yes / No column. I have CF on Col C to flag any duplicate full names which is easy enough but I want Col...

I have a data table of dates, first names, surnames and salary. I need to be able to lookup the salary on or before a given date. I need to do this multiple times so do not want to use the Control Shift Enter array construct. Any suggestions for a single line formula that can deal with the data...

I am having trouble getting my conditional formatting to work. I am trying to highlight the first occurrence of value in a range of D19:I137. I tried condition formatting duplicate value and it changed all occurrences to the same color. I also tried entering a formula but still can't get it...

I have The following in a table in Cell A1:B6 I have the Car (Audi BMW) listed in cell C1 and D1. And need to obtain all the names under each car. eg tom and tim would be under BMW. Need this in a VBA code please <tbody> NAme Car phil Audi andy Audi jack Audi tom BMW tim BMW </tbody>

Hi I have a spreadsheet with a set of criteria in it. I have called it table 1 I have a second set of data I will call Table 2. I would like to be able to insert the appropriate value in the PRICE column in table 2 based on the criteria listed in table 1 and matching it to a set of values...

I'm in need of some assistance with a task I'm trying to complete. I have a sheet called "Client Summary", where I'm trying to pull in data from several other sheets where the "Client ID" matches on each sheet. Depending upon the sheet I'm hitting, it could be a 1:1 or 1:many search. Here are...

This is a Qn pertaining to <tbody> <colgroup><col style="width:48pt" width="64" span="8"> </colgroup><tbody> A B C D E F G 1 2001 2001 2002 2002 2002CY-Q1 2 Sales Profit Sales Profit Sales...

Can I upper case every first letter in a word in Cell A2 with vba. For example Tom Hanks 3456 Elm St.

I would like a range that includes the number of rows +1 a cell value states. I've tried various versions of the code below. 'Range("C2", Range("C" & Range("MonitorTotal")+1).Value).Copy As you can see I want the range from C2 to C and the value from the named cell "MonitorTotal" +1. Thanks...

I'm a reasonably new user of Pivot Tables, but appear to have stumped other experts at work with this problem. I have the following sample data in the first three columns and the Pivot Table to the right of it as follows...

Hi, I am trying to convert a table in the following way. Is there a way to realise this using a make table query? <colgroup><col width="64" style="width: 48pt;" span="7"> <tbody> Name WK1 WK2 WK3 WK4 WK5 WK6 Tom 100 100 100 100 100 100 Bill 25 25...

Hello, I've inherited a leave calendar and am having trouble figuring out how it functions. Am I able to link it here via dropbox and have someone have a look at it? Regards Tom