medium

  1. F

    Long Code, Sum I

    I need help, I have a Quotation that I have made for work. It has drop downs Lists to save time and speed up the completion of the quotation. Problem is I have added a drop down List under subtotal is for offers like 20% off ect. the one I'm having trouble with is the free packing material...
  2. I

    Assign a cell a specific value

    Hi, I'm not sure if i have the correct title on this thread, here is what i am trying to achieve. I have 4 shipping templates. 1. Flat Rate Envelopes 2. Small Box 3. Medium Box 4. Large Box I also have an excel sheet that has products, each product has one of those shipping methods above...
  3. M

    Index Match On Multiple Columns

    Hi and good evening,how would I perform a lookup on 1 unique "date time value" in columns D and F and return their matches from columns C or E all sorted from oldest to newest (like finished Data Set below).Times and Dates in columns D and F are formatted as "ddd-dd-mmm-yy hh:mm".Also I would...
  4. D

    VBA function IF

    Hi all, I try to make appear on the cell Cells(emptyRow, 11) the value ''HIGH'', ''MEDIUM'' or ''LOW'' in function of the value of the cell Cells(emptyRow, 10).value I mean if the value of that cell is more than 6 the value of Cells(emptyRow, 11) is ''HIGH'', if its value is less than 1...
  5. W

    Return Related URLs into one string (Textjoin)

    So I have a list of URLS and I need to return all the related ones into one string. The urls are laid out in a logical manner Domain / directory / sub-directory / In theory this should work, but I'm getting some random urls in there. I just want any url that contains the group slug none others...
  6. G

    MODE for text with multiple criteria

    Hi there, I was hoping someone can assist me in crafting a formula that would look at text and return the most frequent appearing text provided it meets certain criteria. Example data set: <colgroup><col><col><col></colgroup><tbody> Category Sub-category Data Breakfast Light Good...
  7. N

    Counting multiple lines of one order

    <tbody> A1 B1 C1 D1 Order No: BOX or WRAP Medium Large MK23 1 1 0 MK23 1 0 1 MK23 1 1 0 MK24 1 1 0 MK24 1 0 1 </tbody> B1, have sorted to 1 for BOX and 0 for Wrap I would like to count, how many medium and how many large boxes for each Order No: The output should be as below...
  8. W

    Need help urgent!!

    Here's a quick question. I am currently trying to create a calculator on excel that determines if a cell is greater than 10% then by how much and then allocates the amount that it is greater than to another cell respectively. So I have 3 categories High Medium Low that equate to 100% there are...
  9. L

    Listing the values that were added by COUNTIF/SUMIF or gettign the summary of the values (

    Hello, I have an excel with a lot of data (attached excel is just a small portion of it). In this excel, my primary objective is to find the EFFORT by each RESOURCE to each PROJECT. If i use SUMIF, i get the total effort for each resource easily. However, I want to know list the PROJECTS and...
  10. B

    Index and Match Help for Risk Calculation

    I am trying to auto populate the risk level of an item based on the selection from two fields and where they intersect in a matrix Column A = Impact; dropdown selection Column B = Probability; drop selection Column C = Risk Level; calculated based on the selection in the above two fields and...
  11. B

    Risk Assessment Calculation

    I am trying to calculate the level of risk for a particular item based on the user inputs to two fields. Column A = Impact; drop down of values Column B = Probability; drop down of values Column C = Risk Level; calculated based on the entry in Column A and B and where they intersect in a...
  12. C

    IF AND or IF OR - HELP

    I'm sure there is a more efficient way to write this formula. I'm hoping my Excel Brain Hive and help. I've attempted to break it up in lines. =if (AND(M3="Low",N3="Low",O3="Entry/Lower Level"),"No Change",(AND(M3="Low",N3="Medium",O3="Entry/Lower Level"),"No...
  13. S

    VBA to merge duplicate rows and sum values in column

    RE: https://www.mrexcel.com/forum/excel-questions/1021341-vba-merge-duplicate-rows-sum-values-certain-column.html Tried the code here but doesn't seem to work well for my case. Example: <tbody> Room Quantity Description Small -- 2101 Small 1 Apple Small 1 Orange Small 2 Pear...
  14. B

    Formulas for 9 box grid

    I'm working on a 9-box talent matrix, and what we're trying to do is pull names from a list and into their respective grid square. Everything is working, except for the category of "High-Low." I keep checking the formula, tested tweaks, and even re-created it multiple times from scratch. But I...
  15. B

    Formulas for 9 box grid

    I'm working on a 9-box talent matrix, and what we're trying to do is pull names from a list and into their respective grid square. Everything is working, except for the category of "High-Low." I keep checking the formula, tested tweaks, and even re-created it multiple times from scratch. But I...
  16. S

    IF statement with Concatenate

    I'm trying to do a concatenate formula to combine all the categories from sheet 1 into one cell. The values in Sheet1 for categories would be a drop down list of blank, L, M, and H. In Sheet 2, if the category has a value, include it in part of the concatenate formula. Is an loaded IF statement...
  17. C

    Nested IF formula

    Hi, I have a number of nested IF formulas that aren't working and I feel like I've tried every variation but still can't craack it! Any help would be gratefully received! SO in the cell next to the formula, I have 3 options and depending on what is selected, I then want it to generate a...
  18. H

    Tricky extract

    Hi there, Coming back from my datas from yesterday and the help of Peter, I have 2 questions : 1st question : My data : B1 : Broad Spectrum SPF 15 - # Medium Beige 18g/0.6oz B2 : Restructuring 1000ml/33.8oz B3 : Treatment 118ml/4oz B4 : Spectrum SPF 15 - # Medium 18g/0.6oz I would like...
  19. E

    Charting Multiple Clusters on same graph

    Hello, I don't have much experience with charts in excel and I'm not sure how to build this chart I want with my data set. Below is a sample of the data: <colgroup><col><col><col><col><col></colgroup><tbody> School ID Grade Level Size $ Per Pupil Poverty Level 2010 High School Medium...
  20. S

    Add multiple columns into one cell

    In tab1, I have a table with the end user will complete: <tbody> Type Check 1 Check 2 Check 3 Check 4 Check 5 Check 6 Check 7 Check 8 Check 9 Combined Check Type1 L M L H H Type2 M L M M M </tbody> In tab2, Column B is what I'm attempting to get as an end result. I can't...

Watch MrExcel Video

This Week's Hot Topics

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
Top