apples

Hi guys, I am having trouble with a formula to determine the latest value on a vlookup. The following is an example: <tbody> Apples ordered 2/4/2019 Oranges backfilled 2/4/2019 Apples arrived 3/4/2019 Oranges arrived 3/4/2019 Apples backstock 4/4/2019 Oranges missing 4/4/2019...

Hi all, This may be a bit of a long shot but I am trying to create or put together a VBA Macro for package distributions that will send out multiple email notification emails at once to the approriate point of contact each with slightly different subject header based on their location and the...

Hi I have a long series of data that contains names in column A, Products in column B and quantities in column C eg: <table> <tr> <th>A</th> <th>B</th> <th>C</th> </tr> <tr> <td>John</td> <td>Apples</td> <td>7</td> </tr> <tr> <td>Steve</td> <td>Apples</td> <td>4</td> </tr>...

Hi there, I am trying to find a formula that will allow me to extract the first word after the dash - and leave out the rest of the string. Please advise. Happy - Data for Window. Result I want is Data Grumpy - Sam is the one. Result I want is Sam Happy - Apples for oranges. Result I want is...

Hello, I want to sum all "Apples" under the "Jan" Column in the following table. I want to make the formula dynamic by having the formula lookup the entire table and select the correct columns and rows rather than using "Sumifs" on a per column basis. Any help will be appreciated. The formula...

I created a drop down list and used code to allow multiple choices of certain words in one cell. I need then to have a formula that can refer to a price based on these values and add the prices together. So in B2 it may say "apples, oranges" it would then need to refer to a cell D4 that is 1 and...

Hi everyone, I have a data set like the following. Unfortunately, my data is a lot more complex than this so a simple Pivot won't let me analyse it :( <tbody> Name/Year Apples? 2016 2017 2018 John Apples Apples Oranges Emma Apples Apples Apples Dave Oranges Apples Oranges </tbody>...

For example, I have the following data set: <tbody> Name Fruit1 Fruit2 Fruit3 1 Bob Apples Oranges Pears 2 Jill Oranges Apples Bananas 3 Biff Apples Oranges Pears 4 Tad Bananas Pears Peaches 5 Peg Grapefruit Apples Pears 6 Bill Bananas Pears Oranges 7 Don Oranges Oranges Oranges...

I am trying to setup an IF statement using a VLOOKUP to find a value in a range greater than zero and return that column's header label. I have a list of names and I am trying to find the first column that has an actual dollar amount instead of blank and then return that column's header label...

Assume I have some data on Sheet1 as follows: Apples Apples Oranges Pineapples Peaches Coconuts Using the code below, the last row evaluates to 6, correctly: Public Function LRow(ByRef wks As Worksheet) As Long On Error GoTo Correction With wks...

I can do a join/transpose with one column but nothing I have tried will do a join/transpose with the condition being in two columns. Below is a sample of what I am trying to do. Thanks for any help you may give. <colgroup><col width="65" span="4" style="width: 65pt;"></colgroup><tbody>...

IF I know my workbook has a worksheet called Apples, I can refer to it as follows: With wb.Worksheets("Apples") ' Do something End With but I DON'T know for certain there's a worksheet called Apples because the user might change it. Instead I DO know there's a worksheet with a...

<tbody> W1-A 1 1 Apples W1-A 1 2 Strawberries W1-A 1 3 Raspberries </tbody> <tbody> W1-A 1 1 Apples W1-A 2 1 Pears W1-A 3 1 Bananas W1-A 1 2 Strawberries W1-A 1 3 Raspberries W1-A 3 2 Kiwi W1-A 4 1 Oranges W1-A 5 1 Clementines W1-A 6 1 Satsumas </tbody> I am trying to...

Assume I have this data over 3 columns: Apples 1 2 Oranges 3 4 Apples 5 6 I thought this would return 14, ie 1+2+5+6 =SUMIF(A1:A3,"Apples",B1:C3) but it only returns 6, ie 1+5 What is wrong? Thanks

Hi all, I'm a relative newbie to VBA, macros etc and am trying to learn a few things, was hoping you could help/guide me in the right direction. I am looking to create a macro which will copy data from one sheet and then sort into the correct sheets with the specified data. For example, i want...

I have a long list of names that I need to arrange. I need to first create a distinct list that is not case-sensitive into a different worksheet in a workbook and to have a unique identifier added to the list of names. Then, I want the identifier and the name attached to that identifier to be...

Hi all, I have a table that has multiple matching entries and i'm trying to use .find to get the right match. Here's where it get's complicated. I want it to find the first match with a specific font format. eg. Row 1 apples in font yellow 0 Row 2 Bananas in font yellow 0 Row 3 Apples in...

Hello, everyone, please for your help, for a macro that i do not know how to do. I have 15 worksheets with specific names (peaches, tomatoes, apples, etc.). In each of them all cells are made - the text in them is red. But in each worksheet, the length of the rows is different: for example: in...

<tbody> OrderNo Account Name Code Description Quantity 1 22 Ex1 APPLE1 Apples 17 2 38 Ex7 PEAR1 Pears 56 3 41 Ex2 ORANG1 Oranges 180 4 52 Ex8 LEMON1 Lemons 100 5 38 Ex7 PEAR1 Pears 250 6 22 Ex1 APPLE1 Apples 250 </tbody> <tbody> Invoice...

Thank you in advance! I have 2 columns. Weights in column 1 from 30 kg to 150 kg and then how many apples they get in column 2. The catch is each row has a new weight at 1kg heavier. Such that, Row 1 = 30 kg, Row 2 - 31 kg, but in the adjacent column they both get 1 apple. However, by the...