grape

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

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

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

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

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

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

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

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

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

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

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

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