cherry

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

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

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

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

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

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

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

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

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

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

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

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