joe

Table 1: <tbody> 1 A B C 2 Apples Oranges 3 Joe </tbody> Table 2: <tbody> 1 A B C D 2 Apples Oranges Apples 3 Joe 5 4 3 </tbody> I would like to be able to pull the sum of an array of columns if the two criteria (name and "apples" as the example) both match. So sum if Table...

Basically I have a column of employee's names and then a row of other criteria. On a second sheet, I have the column of employee's names again, plus a column which would contain the same criteria, and a third column with a number. If the name matches and then the two other criteria match, I...

Hello, Does anyone know why autocomplete doesn't work if the name you are looking for is more than 102 cells away. I put Joe in cell A1. Then I put Jim in cells A2:A102. When I try typing Joe again, it auto completes. However, if I put Jim in cells A2:A103 and try to put Joe in cell...

I have a date range with names in column A and column G will count how many times this person is signed up for a class between column B to column F. Taking into account how many classes the person is taking, I need to return their names in a list that many times Data Range <tbody> A B C D...

Hello, I have Code that finds and replaces values in a comma delimited string from a list on a separate sheet Ex cell value = aa,bb ,cc ,dd , ee Replace values aa bb = bob cc = joe dd ee = frank I get cell value = aa, bob, joe, dd, frank Code works fine but is slow if I have large dataset...

I have a number of members that I need to exclude from a particular query. What I did was to have a string of Not Like Statements in the criteria section of the query to exclude these members from the query. Is there another way to do this in access? This is the what I presently have and it...

I am working on a very large genealogy project. I need to be able to extract date, first name of person and parents name. the data will appear like this (Very consistent spaces) in A2: January 2 Joey Joseph Schmoe (Joe & Josephine). I would like 3 separate cells. B2:"January 2", C2:"Joey", D2...

The question is of reverse concatenation in Excel VBA. I currently have this: <tbody> Joe, Jon Joe, Pam, Carl Joe, Jon, Jeremy </tbody> And need to reverse concatenate so I can then have each individual name in its own row and cell as follows: <tbody> Joe Jon Joe Pam Carl...

Hi Board, It's been so long since I've done this I've forgotten how! <tbody> A B C D E Owner First Name Surname Name Owner Anne Joe Bloggs Joe Joseph Bloggs ANother </tbody> For ease I have put this data on one table, however, the data is split across two tables in two sheets. So...

Hello all.. thanks for the help on this one, it has me stumped. I'd like to do lookup where, based upon a cell, it checks a range of cells to see if they are equal to their corresponding cell, and if they are equal then it accounts for the 'multiplier effect'. Probably best shown in an...

Hi, I have a list that is broken down by Transaction, but I need to change the orientation of it so the list is by the product (even if there are duplicate items) with all of the corresponding information from that specific transaction. Since I'm not great at explaining I'll just get right...

I have a set of data with Departments, Names, Dates of Expense, and Expense Amount. Currently the data is set with the Department and Name in Columns A and B // Jan - Dec as the heading // Expense Amounts in each cross section: Department // Name // Jan // Feb // Mar Accounting // Bob // 5...

I'm looking for a formula to place in column C that will look for the value of A1 in column A, and then return the first non-null value in column B. Google seems to indicate that an INDEX/MATCH formula would be the way to go, but I can't seem to get it right as I admittedly haven't worked with...

Hi Guys, Need help building a graph, here is my sample Data NAME | Region Joe | WEST Joe | WEST Joe | EAST Bill | EAST Bill | EUROPE Bill | Mid-West now I want a Graph that would show the total number on the Y axis and...

Hello, I have values in row 1 that includes various blank cells throughout. I am needing to write a macro that fills blank cells with the value in the nonblank cell to the left. An example is shown below: <tbody> Joe Justin John </tbody> <tbody> In this...

Good morning everyone, I'm struggling with a vlookup today and I can't understand why it isn't working! I have two tabs the first tab looks like this: <tbody> A B C D 01/01/2017 02/01/2017 03/01/2017 From =IFERROR(VLOOKUP(B2,'journey details'!$D$2:$D$4,3),"") To...

Good Afternoon All, I generally have been able to learn a lot from this forum and get all my questions answered just from reading other threads. However I am stuck and wanted to see if the community can help me out! Here's a quick and dirty example of my worksheet: Columns A - E contains...

Can someone please let me know what the best formula to use for this example. I have data from A1:D5 that comes in from another work sheet that's usually in no particular order Joe Mary Bob Steve Lucy If I wanted to have in F1:J5 it to be sorted in a order I've selected. Say I always need it...

i have 4 columns containing data a is employee number example 123132 b is employee name example joe blogs c is a number so example 123132 Joe Bloggs 1.00 213233 Peter Jones 1.00 213167 Sea Young 1.00 heres the challenge if the column c says 3.00 i want this to create in total 2...

Hi, trying to organize data and can't figure out what function to use in this scenario or perhaps I'm using the wrong formula? If pivot table, it always sums does not keep value even if I try and change the format in the pivot table? Data Ex: Plan A. Plan B. Plan C John 13...