cherry

  1. K

    SUMIF where range and sum_range are in every nth column

    Hello! I would like to get result of 19 in B7 for sum up values where criteria is always banana (A7) but there are multiple ranges(A,E,I) and sum_ranges(C,G,K) which are in every nth column. A B C D E F G H I J K 1 apple n/a 1 cherry n/a 1 banana n/a 10 2 banana n/a...
  2. D

    Logical formula for calculating until a number has been reached

    Hi Guys, I would like help with creating a measure for the following data. I would like to categorize the products as i did manually for Apples - I calculated the total volume for the product and divided it by 3. Then I would like to start summing from the lowest volume of Apples to the highest...
  3. 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...
  4. L

    Require VBA Code

    There are 4 excel sheets in a workbook and every sheet has huge data i.e. datewise productwise sales details Now i want get the below details in 5th excel sheet i.e. total sales of specific product in specific time by using VBA code as every sheet has atleast 4-5 lakhs data Why i'm asking...
  5. M

    Macro not completing to end of data

    Hello, I have a code below that will find changes in column J and will insert a blank row after the change. My issue is that when I continue with the rest of the code, it will leave the last row as blank instead of adding a footer with the header and formatting needed. I have data in columns...
  6. V

    Cells with Mulitiple Values Table Filter

    Hello, I am trying to create an excel table that can filter a column based on what is in each cell (using autofilter for now). I was wondering if there is a way to have multiple values in a single cell within that column? Example: <tbody> Name Flavor (filter) Bob Cherry, Chocolate...
  7. A

    Need some creative ideas

    Hello all, I am in need of some creative ideas for the following task: I need to compare hundreds of products to each other to find products that are similar/dis-similar based on the ingredients in their recipes. See below example products to illustrate my idea. In this product set I need some...
  8. W

    Find Top # Most Occuring Text String on Specified Filtered Column?

    Hi I wonder you guys can help me out of this case, I want to rank the strings (1st-5th), in every city for example like this: <tbody> City Fruits Top Fruits in Washington Top Fruits in Oakland Top Fruits in San Diego Washington Apple Apple 5 Orange 7 Cherry 6 Washington Orange...
  9. smide

    Grabbing the Second-to-Last matching value in a column

    Hello. In columns A and B there is a product no. and product list in my sheet. The last matching value I have found with formula ... =lookup(2,1/(B2:B10=C2),A2:A10) How can I find Second to Last matching value? example. <tbody> A B C 1 Product no. List Matching text in cell C2...
  10. S

    Excel using RAND functions

    Does anyone knows how to solve the below question???? I've been stuck at this question for WEEKS. Kindly help!!!!! The slot machine is a favorite among many patrons in casinos and private clubs. It has three identical reels, each reel with spots for 64 images.These include cherry, plum...
  11. A

    Check cell for two sets of data

    Hi All, I have a column that can contain two values each cell can contain one value at a time Eg. Apple Cherry Apple Cherry The whole column is filled with either values and nothing else. I used a macro of if statements to check the cell data is Apple OR Cherry if it contains something else...
  12. E

    Merging duplicate row IDs

    I was using a vlookup to get data from an ID, but I have realised that I have duplicate ID's in the database. I am wanting to merge duplicate row ID's within a database, but keeping all data contained for them. I am expecting there to be up to a max of 5 duplicates, so repeating the...

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