fruits

  1. U

    VBA - Replacing cell values based on specific range

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

    Place sub category's letters in all items

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

    SUM IF AND subtotal & filter dates

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

    VBA Using Arrays for lookup

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

    Replace one text with another

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

    Dropdown list dependent

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

    Formula or VBA for auto changing of qty based on a Value

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

    vlookup with multi name range

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

    Excel VBA to Copy non-blank cell values to another sheet

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

    Return first value for each block in a range and count block size

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

    Need Help With Drop Down List

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

    Macro to offset at specific tags and label them based on prior tag

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

    VBA: If cell contains word (from a list) then return a specific value

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

    Random Text

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

    Formula for Calculation of Covered Inv No & Covered Inv Date

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

    Hyperlink Style Search Macro

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

    Create a distinct worksheet for each unique value in the column named "Fruit"

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

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top