banana

Hi, I have a sheet which lists data like the below: <tbody> Column E Column F Apple Banana Other Melon Other Lime Banana </tbody> If column E contains "Other" then the answer is found in column F. What's the best way to look down column E, find "Other", and replace other with...

Dear Friends, I want a help for a formula which will calculate covered invoice Nos & Inv dates based on Fruit & that particular Fruit's stock. Giving an example below: Sheet1 <colgroup><col style="WIDTH: 30px; FONT-WEIGHT: bold"><col style="WIDTH: 64px"><col style="WIDTH: 64px"><col...

<tbody> Potassium Vegetables Fruit Banana </tbody> Hi all. So, I have a Portfolio in a Pivot Table. I need help with the last item of each of my cascades. In this example the item is the cell "Banana". I want to insert an object on the last cell of each cascade, more...

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

Hi, I have been trying a formula to return row and column heading from table 1 including the cell value of the cell with value in it. I had been trying to follow this post ...

Hi, so say I have this table: <tbody> Type Number Closest difference (in %) Apple 12 Apple 16 Apple 22 Banana 24 Banana 26 Banana 42 </tbody> I need to fill the third column, so for example in first row it should give me % difference between 12 and 16, in second - same, in...

Hi Everyone I have a workbook with loads of sheets in it I have one sheet call "Tab Names" which has a list of some of the tabs (40) in Range A2:A42 I have a macro called "Banana" I want another macro that when in run it will go to each tab in the list and run the macro "banana" then got to...