apple

Maybe a hard to explain title, an example: A list of products, with a value per year: <tbody> A B C 1 Product 2018 2019 2 Apple 10 3 Pear 8 9 4 Melon 12 5 Orange 4 5 6 Lemon 2 7 Coconut 11 12 </tbody> I'm searching for a solution to have a Data...

Hi all, I have several worksheets containing data that I would like to exploit, example columns setup as per below. Worksheet 1 URN LLDRG Date1 111 apple 1/1/2018 123 pear 1/1/2018 222 apple 1/1/2018 Worksheet 2 URN Date2 111 4/2/2018 111 12/2/2018 111...

Hi there, I have some major limitations of not being able to run macros from Excel and was wondering if it was possible to use a formula for the below instead? From: https://www.extendoffice.com/documents/excel/3418-excel-concatenate-unique-values.html <code class="vb keyword"...

Hi, Does anyone know how to save the active sheet in PDF on a Mac ? I have set my print area, would like to save on Desktop, and if possible, have the name of the PDF as the value in C2. I'd like this to be a button macro. Thank you so much in advance! Manon

<tbody> Input Apple Ref No Item 1 Item 2 1 Apple Banana Output Banana 2 Berries Coconut Watermelon 3 Watermelon Apple Berries 4 Banana Coconut Lettuce 5 Berries Apple 6 Lettuce Cucumber 7 Apple Lettuce </tbody>

RE: https://www.mrexcel.com/forum/excel-questions/1021341-vba-merge-duplicate-rows-sum-values-certain-column.html Tried the code here but doesn't seem to work well for my case. Example: <tbody> Room Quantity Description Small -- 2101 Small 1 Apple Small 1 Orange Small 2 Pear...

So I have a table of records. Each row is a record that contains 5 columns of items. I created these records manually, but now i need to identify any records (rows) that contain the same values across the 5 columns. See below: the first and third records are duplicates because they contain...

I have the following data: <colgroup><col width="64" span="5" style="width:48pt"> </colgroup><tbody> Jan Feb Mar Apr Apple 1 2 3 4 Orange 4 3 2 1 Banana 2 2 2 2 Apple 3 4 5 6 Orange 5 4 3 2 Banana 3 3...

Hello everyone, WIll try to explain this as best as I can Starting at A1 Row 1 is conditional row for the code <tbody> John 22 Apple John Apple Mark Cup John Cup Mark Apple Steve Pen Mark etc etc etc etc etc etc </tbody> What I wish for is in other sheet rows from column A...

How to Vlookup for the last matching value from another excel worksheet.Suppose,my table looks like this : column1 column2 column3 Apple 1 Mango 2 Banana 3 Orange 6 Peach 9 Apple 5 Another Excel Worksheet from which Vlookup has to be...

Dear all Could you help me with this issue please? I would like to sum only the transaction that does not contain "APPLE" Ex : <colgroup><col><col span="3"><col></colgroup><tbody> Num Name Debit Credit 1 APPLE 1000 sum only Num 2 and 3 1 ABC 100 due to 1 contain "APPLE" 1 001 900...

Hi, Looking for some help! Data set up as follows... Table 1 (sales data) <colgroup><col><col span="3"><col></colgroup><tbody> ID Product DC Month Sales Apple1 Apple 1 1 1500 Pear1 Pear 1 1 50 Orange1 Orange 1 1 30 Apple1 Apple 1 2 1200 Pear1 Pear 1 2 25 Orange1 Orange 1 2 60...

Hello Gurus, Seeking your expert help in writing a Macro. Am a newbie. I have a below table: <colgroup><col><col><col><col><col><col span="6"></colgroup><tbody> Sold On Mon Tues Wed Thu Fri Sat Sun Item 1 Apple 10 20 30 40 50 60 70 2 Banana 11 12 13 14...

Hi, I have a large spreadsheet with 2 columns A and B <colgroup><col style="width:48pt" width="64" span="2"> </colgroup><tbody> Name1 Apple Name1 Apple Name1 Apple Name2 Apple Name2 Apple Name2 Peach Name3 Pear...

I have an issue with COUNTIFS with multiple criteria. Example: Column A has 4 John Doe’s Column B has 4 fruits: Apple, Apple, Strawberry, Watermelon Column C is my Formula: If I just include 1 countifs it works =COUNTIFS($A$2:$A$5,D2,$B$2:$B$5,E2) returns 2 Apples found <tbody> Name Fruit...

Hello Everyone, I have a userform in which i made two combo box, below are the name's ComFruits_Change() ComVeg_Change() Both combo box having informations like below: Private Sub UserForm_Initialize() ComFruits.AddItem "Apple 1" ComFruits.AddItem "Apple 2 "...

I am looking to see if anyone might have a macro for data that has blank rows inserted between data? For example beginning with this: <tbody> Column_A Column_B Column_C Column_D Colum_E Row_1 ALPHA APPLE ABC Row_2 BETA ORANGE DEF Row_3 GAMMA KIWI GHI Row_4 DELTA COCONUT JKL...

Dear Excel community, Currently I have a column that looks like this, <colgroup><col width="64" style="width:48pt"> </colgroup><tbody> Mango Apple Orange Pear </tbody> Is there a VBA that can help populate the blank cells...

I am having a table with 2000 rows and trying to do a COUNTIFS to find how many combinations i have for the below example. With one criteria it is coming properly but when i add the next criteria it is not working. also i cannot type "Apple" i need to reference the cell since i have around...

Good day Need your help as i can not figure which excel formula to apply! I have large database with different customer and Product respective of their code and name, i need to find price(repeated ones) <tbody> Customer code Product name Product code Price customer name 001 Apple 1008 2.00...