medium

Hi, I need help working out if a product is Standard, Medium or Large size based on the length, width and height dimension with the following restrictions: <thead style="margin: 0px; padding: 0px; border: 0px; outline: 0px; font: inherit; vertical-align: baseline;">#C7E0F9[/URL] "] Standard...

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

Hi all, could anyone please help me to sort the below question. A table contains List of project, Benefits and complexity and another table contains Headings and rows as Complexity and Benefits how could i get ans like in the table 2: For Eg: Table 1: Projects Benefits Complexity...

Hello, I am completely new to this forum and was hoping someone can help me figure out a convenient way to do help in tabulating data from a large scale interviewing process. Essentially, there are specific 4 questions (Q1, Q2, Q3, and Q4) that can asked by different individuals. I would like to...

I have a formula that looks up a project id and returns values "very high", "high", medium, low. I want the formula to look up the project id and when the value is Very High, display VH in the cell instead of Very High, H instead of High, M instead of Medium and L instead of L. Is that possible...

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

Hi I got list in one table which contains three columns (Customer, Product and Type). On the other sheet I got drop down list. I am looking for a macro through which each row data populate in drop down list one by one. Like S.No.1 will populate in dropdown list then S.No. 2 will populate...

Hi guys This is my first post and I'm really stuck on a formula. any help would be really appreciated. I've got a column of results from various checks across my spreadsheet, and each of these checks will come back with a result of High, Medium or blank. What I'm trying to do is create a...

Hi, i have written the following formula, all elements work correctly, apart the from last, which returns "true" instead of Medium. =IF(CV6<>"",CV6,IF(CT6>=Macros!S$17,"Material",IF(CT6<=Macros!S$15,"low",IF(CT6>Macros!S$15,CT6<Macros!S$17,"medium")))) I have tried making if or .. or if and...

Please help to convert the following COUNTIF formula to VB code.. Logic - IF =IF(COUNTIF(G8:G17, "ü")>3, "Medium") Else IF =IF(COUNTIF(I8:I17, "ü")>3, "Large" Then "Small" Thank you!

Hi anybody can help me with this pls. <tbody> Strong Medium Weak Result O 100% O 75% O 0 </tbody> All I want to show is that when I key in "O" in the strong column, I will have a value in the Result as 100%, if I key in "O" in the Medium Column, I will have a value in the...

Hi, I have a list of prices, their frequencies and the medium price for the transactions. I need to write a formula that will count number of transactions that are +-15% of a median price (I already separately determined median price). BESP Analysis contains all the individual transactions...