fruits

<tbody> A B C Oct 2019 % Share Vegetables Apples 10 50 Lettuce 10 50 Total 20 100 Fruits Oranges 10 50 Blueberries 10 50 Total 20 100 </tbody> Hi guys, little bit of an involved question here. The above is an example of my table for sales. I currently have two...

All hi, Kindly require to provide me a support so that a VBA code to run through col. “G” and where is missing the sub category, should place the 4 letters on left of dash in each item. However, the subcategory which consists with 4 initial letters exists in some of the items. Therefore...

Hello i have list of fruits salles i want when i filter by date it show the total of each fruits salles

Hi guys, so i have a set of data with 600k rows, and i was using index-match to lookup value but its really slow, so i'm starting to look into vba, but, i still dont quite understand the concept of two dimensional arrays, am i able to reference a column with a header name (like python)? and is...

Hey folks, Is this possible? I want a particular word to be replaced by a different word in the same cell as it's written in. Example: If someone in cell A1 types "Apples" I want the text automatically change to "Fruits". I've tried Conditional formatting and Data validation without success...

Hi all, I need to populate a drop down list in a cell based on the value of another cell. If type in A1 cell "Fruits", in B1 it only lists "Apples, Lemons,..." of vegetables lists. Thanks

Dear Friends, Suppose I have a data like the following: <colgroup><col><col><col><col></colgroup><tbody> FRUITS QTY RATE TOTAL APPLE 125 40 5000 GUAVA 83 65 5395 ORANGE 52 10 520 BANANA 78 5 390 GRAPE 75.25 45 3386.25 LEAMON 32.5 15 487.5 LITCHI 38.52 30 1155.6 DATES 56.75...

<colgroup><col style="mso-width-source:userset;mso-width-alt:1080;width:23pt" width="30"> <col style="mso-width-source:userset;mso-width-alt:568;width:12pt" width="16"> <col style="mso-width-source:userset;mso-width-alt:3100; width:65pt" width="87" span="6"> <col...

Hi, I have a sheet with a table with two columns: the first column says countries and the second column says fruits. Countries Fruits South Korea China United States Russia Australia Singapore If I enter values on some of the fruits for some countries and leave the...

Hello Excel experts, I have a single yet very long column with several blocks. Each block has a header/category name and each block is separated from the next block with 1-3 new lines. My data is similar to: <tbody> Fruits Apple Banana Orange Grapes Pineapple Veggies Celery...

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

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

The following scenario was already addressed on another post: In the following table I would like the code to return “Fruits” if the cell contains a word that refers to a fruit (i.e. apples, oranges, pears) <tbody> I love apples Fruits I like oranges Fruits I bla bla lettuce Veggies I...

Dear Members I registered today and this is my first post in the forum. if cell A1 to A5 contains fruits like banana, apple, grapes, guava, melon. and in cell A6 i want a random fruit from above 5 fruits, then what formula shall i use? Regards Pigeon INDIA

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

I am looking for a macro (I believe it will be two macros needed) that could do the following.... Say you have a spreadsheet with a whole bunch of BOLD header titles throughout the page. At the top of the spreadsheet is a list of all these BOLD header titles. I would like to be able to click on...

Hello All, I have a workbook that I download that contains a worksheet that has a varying amount of rows each time I download it. Sometimes I can have 10 rows, while other times, I can have 80 rows. This worksheet has a column named "Fruit" and the number and kind of fruits can vary. There is...