pears

<tbody> A B C D E F Dropbox1 Dropbox2 Select 0 peaches fresh pears Frozen </tbody> This is driving me nuts got my whole workbook figured out and I m stuck on this 1 thing. Its simple and I am just not seeing it any help please? I...

If in, for example, column A you want to paste the data in the next blank row even if it isn't at the end of the data set as shown below - how would this be done via VBA? Apples "Blank" Pears Pears Pears Pears "Blank" Thanks.

Hello, all. I don't seem to be able to find this specific variant of a value-matching formula. I'm trying to output the list in column "ValueIsPresentInA-B-C", where it checks all of the other columns for values that must be present in each each of the others and then populates the column. The...

Hi, can anyone help with with this problem. I have a list of data where I've done a conditional format to identify duplicate email addresses. I've tagged each email address relevant to the user's interest. So imagine you had a user who had three interests and another with 2 and another with 1...

I need to count for which store and how many this store has the lowest price for each product? For example result - Shop1=0, Shop2=1, Shop3=2 Prod. Shop Price Apple Shop1 5 Apple Shop2 3 Apple Shop3 4 Pears Shop1 8 Pears Shop2 7 Pears...

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 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>...

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"...

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...

<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...

Hello all, I have this code so far, for concatenating values in a range: Function Concatenatecells(ConcatArea As Range) As String For Each n In ConcatArea: nn = IIf(n = "", nn & "", nn & n & ","): Next Concatenatecells = Left(nn, Len(nn) - 1) End Function Assuming I have this data: How...

Please can someone help to come up with formula that would count cells with text if condition is "time"? The "count" column is where the formula that would count the number of fruits once the "start and end" time were met. Example: the first count in "count" column is 2 - this is because "apple...

Hello there, I know you can remove duplicates with the 'Remove Duplicates' tab, however is there a way to do it formula wise, including an if statement? For instance, in the dataset below, I need the unique values for each fruit. So, for instance, the unique values for Oranges would be 1, 2...

Hi Mr Excel, I like using SUMPRODUCT but SUMPRODUCT doesn't like blanks in my tables. It returns #VALUE ! when there's a blank. Is there a quick and easy way get around this, for example using the example below. Apologies for the cumbersome table posting... but cell D6 has a blank which causes...

I have this database with numerous different codes for the same listing: All Fruit............Fruit Code Apples..............AP1 Pears................PE1 Peaches............PC1 Bananas...........BA1 Pears...............PE3 Strawberries.....ST1 Apples.............AP3 Bananas...........BA4...

Good evening all! I was wondering if anyone could possible offer a solution/guidance to a problem I'm having. I have 2 tables of data on 2 worksheets. I have 2 criteria that I wish to search, and for all matches, concatenate the values. Unfortunately I cannot use VBA, UDFs or addins for this...

Could use some help – I tried to simplify this down to explain I am using powerpivot and have three different types of fruits. I have set up measures to total the fruit, but I need to create a calculated column that determines what % of the quantity of each fruit is on each line The bolded...

Hi All, I'm trying to display a data series as a heatmap, but one which changes the size of the boxes depending on the size of the data. E.g. Apples 25% Pears 10% Oranges 20% Bananas 20% Grapes 25% So the above data, if each one was supposed to be 20%, then Apples/Grapes would be Yellow (as...

Hi, How can I sum up each column based on the criteria inputted? What I've used is this but obviously not the most practical. =SUMIF(B2:B25,K2,C2:C25)+SUMIF(D2:D25,K2,E2:E25)+SUMIF(F2:F25,K2,G2:G25)+SUMIF(H2:H25,K2,I2:I25) How can I simplify this? <colgroup><col width="64" span="11"...

I have some rows of data with a bunch of duplicate text strings, like this (each fruit is in a separate cell): Company ABC Apples Oranges Lemons Lemons Lemons Pears Company DEF Orange Lemons Pears Pears Pears Pears Pears Cucumbers Company XYZ Apples Apples Apples Pears Pears Lemons...