mango

  1. K

    Formula to Retrieve Value base on specific text.

    Hi Guys, I am using Excel 2016. Its been awhile since I posted would appreciate some help on the following problem. :( I have the following list : <tbody> Fruit Price Apple 5.00 Watermelon 6.00 Mango 4.50 </tbody> <tbody> Fruit Price Watermelone 5KG Banana 300G Red Apple...
  2. P

    sum ifs + index match

    Hi, I'm trying to accomplish the following results: <tbody> #8cb5df[/URL] "]January #8cb5df[/URL] , colspan: 3"]Publix #8cb5df[/URL] "]2019 #8cb5df[/URL] "]2018 #8cb5df[/URL] "]2017 #8cb5df[/URL] "]Fruits Pear 6 10 2 Mango - 1 3 Banana 4...
  3. S

    COUNTIF any part of cell string appears in range

    Hello! I'm having issues getting the correct formula to search a range and COUNTIF any part of a cell's text appears anywhere in the range. Using A as the search criteria and C as the range, I would expect the column B results below, but, in B2/B3 it's returning 0 no matter what formula I...
  4. N

    Values only once when multiple values

    <tbody> Current Desired Result A B 1 Apple Apple 2 Apple Banana 3 Mango Mango 4 Mango Peach 5 Mango 6 Peach 7 Banana 8 Banana </tbody> I need the value only listed once (preferably in Alpha Order) from a data set column that lists that value...
  5. B

    Formula merging a countif with a second if statement

    Sorry for the vague description but not sure how best to describe this. Here is the situation below. I want column C to be a formula. Out of all of the occurrences of Oranges in column B, if any of them have a value of 5 or above in column A, then I want it to return a Y in column C for all...
  6. A

    Vba to transport rows to columns- Set of data

    Hi, coming back after a long time:) coz i need your help very badly. I have 2 columns like below, I simply need to to transpose these data into columns in a new sheet List 1 List 2 Apple Boomerang Apple Offerings Apple Industrial Equipment Apple Chemicals & Natural Resources Apple Consumer...
  7. A

    VBA to fill cells with values

    Dear Excel community, Currently I have a column that looks like this, <colgroup><col width="64" style="width:48pt"> </colgroup><tbody> Mango Apple Orange Pear </tbody> Is there a VBA that can help populate the blank cells...
  8. V

    Countifs

    Hello all Could anyone help count my below issue? Thank you very much <tbody> A B 1 0-100 0 2 100-500 2 3 500-1000 2 </tbody> I would like to count column A that meet criteria with above table <tbody> A B C D 1 Apple 100 2 Orange 300 3 Mango 500 4 Apple 1000 5...
  9. K

    Add column after each different name.

    Hi Guys, Using Windows 7 & Excel 2010. I have the following list : <colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody> List Currency Status Apple AUD V Apple AUD V Apple AUD V Pear AUD V Pear AUD C Durian...
  10. M

    Automatically Populate Results Based on Inputs

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

    how to loop till the drop down list is empty

    Hello world! Please help me out with this I have a work book which has 2 sheets named "Apple" And "Mango" Sheet Apple cell A7 = Sheet Mango A1 example =Mango!A1 on Sheet Mango A1 it has a drop downlist and has many items I have a macro to go to the next item in the list which is named as...
  12. A

    Sequential Numbers in Excel Value

    Hi, How do I add sequential numbering in excel? Say I have below data Cell A1 Mango Cell A2 Apple Cell A3 Orange Cell A4 Banana and I would like it to be like below which is a function in MS Word Cell A1 1. Mango Cell A2 2. Apple Cell A3 3. Orange Cell A4 4. Banana I don't want to use...

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