pear

Good Day Excel MVPs and Experts. Please advise. I want to automatically populate in any order the results in Table 1 based on data inputs table. I also want to have a button to click for the results in table 1 to "repopulate" again and again. Can anybody help me? Thanks in advance...

Dear All, I am new to this forum. I am trying to find a solution for the following; within a tabel with several columns I am trying to find the last row (preferably column with the date for which the last specific value has been found in the table). See attached example. With vertical...

Hi all, I am trying to compare two different headers from 2 different excel files. For example, for the 1st excel file, I have Apple, Orange, Pear, honeydew For the 2nd excel file, I have Orange dragonFruit, starfruit, pear, Apple. I need to manipulate the columns till it becomes...

Hi, I've tried loads of different formulas but can't get one to work. What I'm looking for is a formula that says something like: If a1=1 then apple, but if it doesn't and b1=1 then banana, but if they both don't and c1=1 then pear. Any ideas?

Hi all, I would need to find multiple words inside a String. An example of the String: "I need to buy apple, pear, orange and other fruits" I need to the expression to find apple, pear and orange inside the string. Is it possible to find all at once or do I have to find a word by a word...

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

Guys, I need urgent help with converting of the below raw data into the below format of data to be presented. I am open to all other methods, not necessarily using vlookup/hlookup. Thank you. (Raw data) <tbody> Fruit Year Price($) Apple 2014 1.32 Apple 2016 1.49 Apple 2017 1.55 Pear...

Hi, I need a VLOOKUP which will give me a result if the text in a column is found in another column even if this text is contained inside a word. So if I have: A...... B...... C apple apple apple pear...

Hi All I have a column (in sheet called worksheet column E - starting in row 2) with all names, including duplicates. I wish to make a list in a seperate sheet in column A with only the unique values (each name once in this list - starting in row 6). This list must also look at the value in...