bananas

I am trying to compare numerical amounts on different sheets/tabs for common criteria, for example sales of an item on two months to determine the difference. I have a vlookup for this, but would prefer an index match The sheets would be as follows sheet 1 row 1 row 2 apples...

I have cells that have multiple lines of data that is seperated by a return. Is there any way to break these returns into their own cells? EXAMPLE: CURRENT <tbody> A1 APPLES BANANAS GRAPES A2 ORANGES MANGOS </tbody> <tbody> A1 APPLES A2 BANANAS A3 GRAPES A4...

Hello. I have the following table: Line1: Product | Minutes1 | Minutes2 | KAPPA Line2: Oranges | Africa | | 2 | 1 | 15 Line3: Oranges | Africa | 3 | 1 | 15 Line4: Oranges | Africa | 2 | 1 | 15 Line5: Oranges | S. America | 3 | 1 | 15 Line6: Oranges | S. America | 5 | 1 | 15 Line7: Oranges | S...

Hi, I have the sheet bellow: <tbody> Product Value Indication Apple 50 TRUE Apple 50 Cherries 20 Cherries 20 Bananas 45 TRUE Bananas 45 Bananas 45 </tbody> And I want the following result: <tbody> Product Value Indication Apple 50 TRUE Apple 50 TRUE Cherries 20...

Hi, I have multiple tabs on a worksheet, and I want each individual tab to be saved in a location depending on the name of the tab. The actual name of the file would be the tab name, plus the contents of cell A1. So for example, if the tab is called "Bananas" and has "1234" in cell A1, 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, 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...

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

Hi, I am trying to get all the values from rows with VLOOKUP. I have data which has seller name in merged cell and Product is in differrent rows.For Example: Adam seller has Bananas,Oranges And Lemons... <tbody> Seller Product Adam Bananas Oranges Lemons Robert Apricotes Lemons...

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, I have built a very basic sheet to monitor sales at an event we are running, almost a bit like a till system. We are scanning barcodes which will represent products and then a final barcode to "end the transaction" which can also count the number of transactions. What I'm trying to...

Really needing some assistance:- I have a workbook with multiple sheets but what I am wantingto do is have all columns of one sheet automatically populate onto anothersheet if a certain word shows up in one of the columns. For example: - If the word April shows up in column D I want all...

Hi I need to copy stuff from one worksheet to another according to the value of another cell. E.g. Row A says: Apples, Oranges, Bananas Row B says: 10, 5, 7 I now need to copy Apples 10x, Oranges 5x, Bananas 7x in Row A on another worksheet. Any ideas how I could accomplish that?

Is there a way to sort contents of a cell in alphabetical order? Each value that need to be sorted is seperated by , (comma space). EXAMPLE IN COLUMN E: RICE, CHEERIES, BANANAS, CUCUMBERS, BREAD WANTED RESULTS IN COLUMN E: BANANAS, BREAD, CHERRIES, CUCUMBERS, RICE

Hi, I have a large number of duplicate rows that I would like to merge/consolidate into blocks of 10 and rename the product. Here is some sample data: Customer, product, qty <tbody> Customer 1 Banana 1 Customer 1 Banana 1 Customer 1 Apple 1 Customer 2 Banana 1 Customer 1 Banana 1...

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

Hello there, I'm new to this forum so Hello to all. when adding a new set of data to a dynamic table the Graph goes bananas despite the fact that the graphs is rigged up with defined names and I am not understanding why this is. the example is very simple - three columns ( a=date; b=qty Yes...

Hello there, I'm new to this forum so Hello to all. when adding a new set of data to a dynamic table the Graph goes bananas despite the fact that the graphs is rigged up with defined names and I am not understanding why this is. the example is very simple - three columns ( a=date; b=qty Yes...

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

Hello, I have a the below table with x's (only mine is 100x300). <tbody> Adam John Fred Frank Apples x x x Pears x Bananas x x x Grapes x x Oranges x </tbody> I spend an hour+ each day copying and pasting into the below format by copying sheet...