bananas

  1. C

    using index match to compare numbers on different sheets based on a common criteria

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

    Move to new cell.

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

    Address formula

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

    formula to fill column based on group condition

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

    Save tabs in new worksheets depending on name of tabs

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

    extracting data from table

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

    Identifying duplicate values and then returning a combined value if duplicates exist

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

    Not sure if this type of search and display is possible...

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

    VLOOKUP values with merged cells

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

    FindFormat Help.

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

    Sum to a certain cell

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

    Copying columns specified by a given set of conditions or criteria

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

    VBA Paste according to value in cell

    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?
  14. N

    Sort Contents Of Cell

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

    Excel VBA consolidate duplicate rows in to "blocks"

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

    SUMPRODUCT - ignoring blanks in the table

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

    Dynamic Graph going bananas after adding data

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

    Dynamic Graph going bananas after adding data

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

    Returning Multiple Data from VLookUp?

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

    Spending an hour+ a day copying and pasting

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

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top