banana

<!--[if !mso]> <style> v\:* {behavior:url(#default#VML);} o\:* {behavior:url(#default#VML);} w\:* {behavior:url(#default#VML);} .shape {behavior:url(#default#VML);} </style> <![endif]--> Need your help guys, I have this example regarding my concern of giving me the figure from cell C...

Okay so I need some help here. <tbody> Apple 10 Orange 5 Drink 7 Banana 13 Chicken 3 Oil 4 </tbody> I want to be able to either: 1. Convert certain words into numbers. E.g "apple", "orange" and "banana" into a 1. "Chicken" into 2, "Oil" into 3, and "Drink" into 4. So it will...

hi everyone i need some help from coctail macros/vba codes. i have some fruits(14) every week this fruits counts changes. example this week we buying 23 berry next week maybe 10 another week maybe buying 30 berry. we have unstable gradient "fruit ice" (its mean ice + fruit ) just...

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 all i have this: A1=Apple with sugar at A2=Apple with salt at bottom A3=Chese cream with banana and in: h1=1 j1=Apple h2=2 j2=Chese cream h3=3 j3=Orange h4=4 j4=Table i want in B1 know if A1 start with any value of j if yes put the h column in this case: A1=Apple with sugar at...

<tbody> Current Text (A) Desired Lookup Result (B) green apple apple red apple apple brown banana banana yellow banana banana yellow strawberry strawberry red strawberry strawberry </tbody> Column A contains extended text with the key word. I want to return the key word in column...

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

I have thousands of rows of data. In one column there's a string of both text and numbers. Some of the numbers are dates. The dates represent many different years, but I only want the dates for 2016 and 2017. I've tried using the IsStr function but I just could not get it to work. Here my...

Hi Guys can you help me ? I have data on a worksheet as below Product Date1 Date2 Date3 Apple 2 4 0 Banana 1 3 4 I need to get the data in the form, I have around 11000 rows. Using Excel from Office 365 Version 1711 Build...

Hello All, I'm trying to work on a formula regarding vlookup. there are basically 3 column. Column A's data corresponds to the data in column B. (basically, they are partners) I need to find (using vlookup) the values from Column C that are in Column A together with Column B. <tbody>...

Hello All, I want to compare two data's. My A-D are main data, F-I are my ref data. I have to check is the reference data have the same value or not. If it dont have it then it should provide correct data. If you see Stephen have the same Fruits in both Main and Ref data. Some thing should...

I have One sheet which have one ITEM many times for example I need a formula which copy UNIQUE Item ONE time to Other sheet. Example One Sheet APPLE APPLE APPLE ORANGE ORANGE BANANA Other Sheet APPLE ORANGE BANANA

SHEET 1 <tbody> GIVEN ITEMS PACKING 10 APPLE 20 KGS ORANGE 20 KGS 5 BANANA 20 KGS 2 GRAPES 20 KGS WATERMELON 25 KGS STRAWBERRY 30 KGS 3 PINEAPPLE 40 KGS MANGO 10 KGS 1 POMEGRANATE 5 KGS </tbody> SHEET 2 - HOW I WANT IT TO BE: <tbody> GIVEN ITEMS PACKING 10 APPLE 20...

Hello all, I have a question Ive been trying to figure out for a long time now. Unfortunately I didnt succeed, hopefully you can help me. The situation is: In column A I have merged cells, in column B and C just text and at row 1 I applied the standard filter of Excel. What I want is: if I...

Hey All I'm after a method of comparing two cells and seeing how similar they are, preferably in a percentage format based on the words in the cell. So; A1 = "Apples" | B1 = "Apples" - The result would be 100% A1 = "Apples" | B1 = "Banana" - The result would be 0% A1 = "Apples Banana" | B1...

Hi, I am looking for a formula that will be able to populate a cell with the max value in a range based on a custom list. Example. CUSTOM LIST (Smallest to Largest) = ORANGE 00, APPLE 05, BANANA / HOLD, PINEAPPLE (If I have to have the list somewhere in my workbook it will be on a sheet...

Hi, I am looking for a code that returns the count / frequency of transactions where any two or more items are sold together for eg. <colgroup><col><col></colgroup><tbody> Transaction No. Item 10020 apple 10021 apple 10021 banana 10021 carrot 10022 apple 10022 banana 10023 lemon...

I have column A and Column B, how to highlight the cell when they are equal? Sample and Expected Result <tbody> A B C 1 Apple Banana 2 Banana Apple 3 Apple Apple 4 Banana Apple </tbody> I tried to do this by doing Conditional Formatting, it works, however my rows are dynamic...

Hello, Need help! I tried searching google and the forums, but for the life of me I can't seem to find what I'm trying to look for. I have a list of data in sheet1 and I'm trying to copy/paste each line into sheet2 on every 3rd row and then fill down the blanks. The list of data changes daily...

Hi, My table is as follows: <tbody> Shop Fruit A Apple A Apple A Pear B Strawberry B Banana B Orange B Banana </tbody> And I need a DAX formula to create the following table: <tbody> Shop Fruit A Apple A Pear B Strawberry B Banana B Orange </tbody> Which...