1. J

    Not sure if nested IF, with AND, in addition to OR, unless there's a better way?

    Excel 2016 without the office 365 subscription so I can't use IFS. So I've got two columns of conditions. Column 1 has five possible values; low, low/mod, moderate, mod/high, and high. Column 2 has four; Strong, adequate, needs improvement, and none exists. I want to look at those values and...
  2. D

    Weighting Question!

    Good Evening! I am having trouble getting the last step of this worksheet done. Basically I have 1 Budget and 3 projects types. I want to weight the projects by importance but maintain a balanced budget. For example: Budget: 1500 Project A: 5 Team Member Project B: 4 Team Members...
  3. T

    Count and show Formula based on importance?

    Hello, This might be a very simple question for some of you, but i need help finding the solution. I got a long row that ive filled inn with information. at the end of the row i want it to count it up, im open on suggestions here on how to show it. i was thinking something like this. 5/5 i...
  4. B

    Extracting Partial Text and copy to another cell

    Good Morning, It may be easier to explian in a diagram below what I am trying to acheive. Any help would be much appreciated. <tbody> Ideas Date Created Revised Date Idea Rating Idea 101 Low 20/01/18 - Cell reads whether text in Idea 101 Low, is Low, Medium or High and dispalys that...
  5. B

    Extracing a value from one paticular cell in multiple workbooks and listing them in order.

    Hello, I have a workbook that records new files saved into a folder and generates a hyperlink to that file. In each workbook file that is saved there is one cell that advises if the value is Low, Medium or High ( in this instance cell is D3). I need my workbook that stores these hyperlinked...
  6. P

    Complex weighted distribution - multiple input sheets

    Hi everyone <o:p></o:p> <o:p></o:p> Would appreciate some help with a formula which tracks the percentage of time each employee utilises particular ‘Requirements’ – this information is determined by the Job each employee is assigned to. I have completed an initial version of this (with an ugly...
  7. S

    VBA to swap values

    Hi, I have a large dataset, about 4000 rows, which I need to correct some values in case of a criteria. Below is the example of my data: <tbody> Order ID Product Type Dollar Amount 11 Low grade 20 11 Premium 35 11 Low grade 10 12 Premium 50 12 Premium 20 12 Low grade 10 12 Low...
  8. ErCoGor

    Subtotal Detail Sorting

    Hello! I have been researching this question for a while and don't know if I'm misunderstanding what I've read, or if my question truly isn't being answered... so, I'm hoping to try and explain it here and would love some help!! I am using Subtotal to understand what Categories have highest $...
  9. M

    Data Validation List & Formula result in the same cell

    Hi, new here. I'm working on an excel sheet and I came up with such problem: - I would like to have two fields/cells let say A1 and B1 - In A1 I would like to insert a number (no of holes) - In B1 I would like to show "low", "mid", "high" depending on some simple calculation/condition based on...
  10. G

    VBA Duplicate Values in one Column/Sum occurrences in second column off criteria

    I have a bunch of IP Addresses in Column C that are in consecutive order containing duplicates. In Column D I have a text value that could be 1 of 4 items (Critical, High, Medium, Low). I need to delete the Duplicate IPs and Sum the occurrences of the criteria in another Worksheet to the same...
  11. P

    Counting empty cells between two filled cells

    Hi All, I'm trying to create dynamic ranges using the offset function. The number of columns in the range needs to be the first 'filled' cell to the next 'filled' cell less one. Example: | Low | | | | | | | medium| | | | | | | | | | |...
  12. matthewlouis

    Conditional Formula with Multiple Columns - Help!

    <!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--><!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:TrackMoves/> <w:TrackFormatting/> <w:PunctuationKerning/>...
  13. matthewlouis

    Conditional Formula with Multiple Columns - Help!

    <!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--><!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:TrackMoves/> <w:TrackFormatting/> <w:PunctuationKerning/>...
  14. S

    Formula to assign "weights" to things based off a rating of "Low," "Medium," or "High"

    I am not sure if this is an easy task and I am just missing something but here is what I need. I need a formula that will assign a weight (with all weights adding up to 1 of course) to data in excel based off whether that data has a rating of "Low," "Mod" or "High." Naturally, low would have the...
  15. D

    VBA to find Hierarchy Low LEvel

    Hi All In order to progress with some MRP calculations is need to find the lowest level in which a manufactured item is used within a BOM structure, column C below. The raw data below shows the relationships between the Parent and Child Items in columns A & B. Items A, B and J return a low...
  16. H

    Help with a formula (array?) to do the following

    I have cell K12 in which a summed value is displayed. There are thresholds (reflected by CF colouring). That's by the by I realise. These relates to subjective descriptions of low, medium, high, extra high. In the cell below (in K13) what do I need to put in to get, depending on the score, the...
  17. R

    Trying to work out a financial return from start and end of trend - help

    <tbody> Date High Low Close 1/1/17 106 101 103 2/1/17 110 103 107 3/1/17 103 95 101 4/1/17 105 92 100 5/1/17 100 88 95 6/1/17 98 86 92 7/1/17 100 80 90 </tbody> So I am trying to put a formula/spreadsheet together that does the following. % return...
  18. P

    re order columns on value

    45 58 02 30 56 in Columns A1 to E1. How can I re-order low to high please?
  19. P

    Look up high and low values, then define them

    Hi, I'm trying to take a list of values in Column A, then in Column B define which ones are "high ranked" and which are "low ranked" So if I have the table shown below, I 'd like to take the top two values in column A and in column B label those as "high" and the bottom two should show as...
  20. A

    If and or conditions (combination) help please

    Greetings all - and Merry Christmas, Happy Holidays and a wonderful whatever else you may choose to celebrate at this tail end of the year. I have been trying accomplish this below, and google, this site and many others have led me close, but I just can’t find the right bit to get it done...

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