grape

  1. TheRogue

    Dynamic List from Table

    I have a table which lists types of soda & the quantities on hand. I'm trying to create a dynamic list that would put each one on a new row (skipping zero quantities). It would list each, the # of time specified & then move on to the next value. The result list for this table should look...
  2. T

    VBA - If C2 = x, Move D2 to Next Available

    Hi all, I'm really sorry as I'm struggling to even describe what I'm asking help for here. I basically have a list of 30,000 rows of data where Column C is the unique number relating to a customer and Column D is a product they hold. I'm looking for some code to do something like run down...
  3. D

    Looking for a formula

    Hi, i need a help. I need a formula for the calculation for the below data <tbody> <tbody> Location </tbody> <tbody> Vehicle No. </tbody> <tbody> Transport </tbody> <tbody> Weighment </tbody> <tbody> Charges </tbody> <tbody> Total </tbody> <tbody> Credit...
  4. H

    lookup on cells with Comma separated value

    Hi All, Need a help please with either using excel formula or Excel VBA to lookup cells with comma separated values. I have 2 tables below: table 1 and table 2. I will like the Col B (2nd column) of Table 1 to return a true or yes when any of the value is in the Col A (first column) of table...
  5. A

    Mass SUBSTITUTE using a list?

    Is it possible to use SUBSTITUTE (or some other method) using a list of inputs? For example, my target cell contains the string <tbody> I love Apples, I hate Orange, my Banana, my Grape </tbody> and on another sheet I have a ranged list: <tbody> Apple Red Orange Orange Banana...
  6. M

    COUNTIFS with multiple criteria

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

    How to get last value on row data based on criteria?

    I have a data series, example shown below, what I'm looking is to extract the LAST value on the bottom row based on the criteria of the top row. For example: If top row = A, show result Grape If top row = B, show result Apple If top row = C, show result Banana * note that range will vary and...
  8. R

    VBA: How to write a value to a specific cell on another worksheet?

    Using VBA, how do I take a value from Sheet 1 and write it to the cell I want on Sheet 2 when the row changes? On Sheet 1, the active cell is E12. <tbody> E F G H 10 melon Brian pants green 11 squash Barbara pants blue 12 grape Lois blouse red 13 eggplant Bruce shirt red </tbody>...
  9. S

    Generate lists from array

    Hi, new user here who's not bad at Excel, but doesn't have a lot of experience with arrays. My problem: Given a list of groups (in this example types of fruit) and membership in each group (names), I'd like to generate a rows where each person's group memberships are listed. <tbody> A B C D...
  10. A

    Need Help With Drop Down List

    Hi, so I need help with some data that I currently work with. The data goes like this, for example <colgroup><col span="2"><col><col span="4"></colgroup><tbody> VisitDay Fruits MON-1 Apple Orange Pear Grape Melon etc MON-2 Grape Watermelon etc MON-3 Apple Durian etc </tbody>...
  11. T

    Formula to locate duplicate products with the lowest price

    Example Data: Column B Column C Column F Apple 1234 1.00 Orange 1234 1.25 Orange 4321 5.00 Pineapple 4321 3.50 Banana 4321 3.50 Grape...
  12. L

    Macro for auto filtering based on cell value

    Hi All, Could someone please help me to write a macro that filters the selection of data based on a cell value? The situation is: Let's say I have 2 columns A & B, and I have 2 other cells that I can enter value in them. I need the macro to auto filter column B by searching the content of...

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
Back
Top