bananas

Hi guys, Just looking for a little vba assistance. I'm sure this one has been asked but wasn't sure how to describe it to search for it. Basically if I had a sheet where Column A is populated as follows: 1: Fruits 2: Apples 2: Bananas 2: Pears 1: Vegetables 2: Broccoli 2: Peas and what I'd...

Hello, Does anybody know how to automatically highlight the highest value in each row label of a pivot table? In this example, I would like to highlight the highest selling fruit in each state. I couldn't find this option in conditional formatting. Thanks. <tbody> Sum of Amount Row...

Hi, How would you get Column B from Column A? <tbody> Col A Col B List Date 15-Nov-17 15-Nov-17 Bread 15-Nov-17 Apples 15-Nov-17 Bananas 15-Nov-17 16-Nov-17 16-Nov-17 Eggs 16-Nov-17 Bread 16-Nov-17 17-Nov-17 17-Nov-17 Bananas 17-Nov-17 </tbody>...

I'm struggling on how to do this. I have list of search engine keywords, thousands of them with amount of searches. In another table I have search phrases that led to sales. Those two tables are not connected in any way from their source. So my question is, how can I look up the unique phrase...

Hi all, First of all, great forum so cheers for the help already provided just by scanning the posts! I've got one that couldn't find so hoping someone can help me out. I need to find matching opposite pairs by value in column B (by opposites I mean negative and positive values) which relate...

Hello everyone, I would like to copy values from Sheet A to Sheet B. Sheet A has a drop-down (data validation list) and items in that sheet change according to the item that is selected. E.g.: Items in the drop-down are Apples, Oranges, Bananas. Below the drop-down I have monthly counts...

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

Is there a formula to move a specific text within a cell to the end of the string? For all rows in column W I would like to move “ / HOLD” to the end of the sting. If the cell does not have “ / HOLD” I would like to keep it as is. I would like the results to be in column X. Example...

Hello, I have the code below that works as intended (except the last condition matches with Bananas for simplicity). I need to change it so that in adition to existing criteria it counts all alarms starting with "Ban". So it would count all the alarms for "Bananas", "Bandanas", "Bankrupt" etc...