orange

I am trying to count the number of times a certain text shows up in a row since the last time another text shows up in that row. Example: I would like to know the number of times the word "apple" shows up since the word "orange" showed up. C2 is "orange," H2 is "apple," L2 is "orange," then...

Hello, Can somebody tell me formula how to return date from column B in to column F for matching product with status awaiting? <colgroup><col span="2"><col span="2"><col><col span="4"></colgroup><tbody> <tbody> A B C E F Prodcut Date Status Product Date Apple 20/04/2018 Done Apple...

Dear Sir I am trying to search for same value in a column and return value base on some formula How to create a excel formulate that it will search in the column and if there is matching fruit, it will generate a formula to add the price andr select the biggest number in the WEEK? For...

Hello all Could anyone help count my below issue? Thank you very much <tbody> A B 1 0-100 0 2 100-500 2 3 500-1000 2 </tbody> I would like to count column A that meet criteria with above table <tbody> A B C D 1 Apple 100 2 Orange 300 3 Mango 500 4 Apple 1000 5...

I have a column of data: Apple Orange Apple Apple Orange Pear How would I get excel to count and list out: 3 apple 2 orange 1 pear I know how to use countif, but that is if I am searching from a list of data. Sometimes there might be other unknown data inside, so I need to count and list out...

Hello, I'm trying to establish which two products are frequently bought together. I have the data in the below format: <tbody> Product(s) Apple Banana Orange Pear Apple 0 0 0 5 Banana 0 10 0 0 Orange 12 0 0 0 Pear 0 0 6 0 </tbody> So in the above, 12 customer's bought an Orange and...

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

I am currently generating a distinct list from a list with duplicates using: =IFERROR(INDEX(C15:C50, MATCH(0, INDEX(COUNTIF(D50:D50, C15:C50), 0, 0), 0)), "") However, when the source list changes, the entries of the distinct list will (potentially) reorder. This is messing up another purpose...

I have been working on this formula for a while and cannot find a solution without having a super long and complex nested if statement. For the below table, I want to be able to choose a name (Bernard for example) and have a formula tell me the column name of the first cell with a value greater...

I need help to look for nearest date (Min, Max) available in sheet2 for the given date sheet1 and applicable variable(Apple). (similar to lookup but in this case exat date doesn't match). <tbody> Sheet1 A B RESULT() Expected Result 1 Name DATE Nearest min date Nearest...

Hi, I got a sheet where each order are splitted into one row per item. I would like to collect all items from same order into one row - is this possible? FROM THIS: <tbody> Order Item 1234 Red 4567 Blue 1234 Yellow 4567 Brown 1234 Orange </tbody> TO THIS: <tbody> Order Item Item2...

Hi I'm trying to create a formula that auto "pull in" names that are assigned to a specific group number. For example, i have a table below to start off - <tbody> type group orange A 2 orange b 4 orange c 2 orange d 2 </tbody> I then want to create a formula that automatically...

I have a list of duplicate cases (column A). Both duplicates have information that the other may or may not have. I would like to somehow merge the duplicate cases and return the non empty value corresponding to the attribute. Additionally, I would like to carry over the cell color (pretend the...

Hi Everyone, I have a problem with the shading area under the 2 intercept lines as photo below. I would like to have the shading under the interception of the yellow area and orange line as blue shading in the photo. However, the problem here is I cannot make the blue shading fully shaded...

Hi guys. This sounds like a simple question and I've been searching and searching, but can't seem to find the right answer. I currently have a spreadsheet with 2 tabs/worksheets named SHEET1 and SHEET2. Basically all I want is if anything is entered in cell A1 of Sheet, then the tab on Sheet...

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

I am trying to get the countifs by using multiple column. I need to find out the number of times Column A and Column B. Column A with unique ID and Column B with multiple criteria. For eg. Coulmn A1 = Apples, Column A2 = Apples Column B1 = Orange and Column B2 = Peach Above case count as...

Hello Experts, Need your invaluable insight into the issue that I am facing below, My data is as below, Column A Column B Orange 10Kilo Orange 20Kilo Orange 30Kilo Orange 40Kilo Apple 5Kilo Apple 15Kilo Apple 25Kilo...

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

Hi Guys, Need help with the below. So I need to copy the whole row of those crops that have changes in length from day 1 to day 2. The below is just an example, true data contains many rows and columns. I don't want to add another column that will check if day 1 and day 2 are the same. What...