return

Greetings, I have a Workbook for tracking change orders. When an ECO is closed, I select any cell in the row and run the following to erase the data and clear the formatting on that row. Sub Clear_ECO() MSG1 = MsgBox("This action cannot be undone!" & vbCrLf & vbCrLf & "Selected Row is: " &...

currently i i want to look up a unique security ID to another tab and return the inventories its in. the problem with obviously vlookup is that it would only return the first inventor result found.....what would be a way to return all the inventories the security ID is in? i suppose this can't...

Hi, I have a long list in column E which is say 1000 + results down the page. I am in need of a Return to top of page code BUT a floating type if possible. I mean the Return to top icon which will hold the code must be in view on the worksheet whether i am on row 55, 239 or 850 then i can...

Hello, can you please help point me in the right direction on this formula. Basically it has 3 conditions depending on day count. If <60 it should return “80%” If >60 but under 180 it should return 75% And if over 180 it should return 65% I am trying this but it wont work...

Hello, I am looking for a formula that can find a certain work and return only 10 characters to the left of that word. For example OTHER INFORMATION.... FOR PO# 55222 FROM COMPANY Left of "From Company" I want it to return the PO# 55222 Any help would be appreciated Thank you! :) Carla

Hello, Probably being thick here and the obvious answer is alluding me but I need a formula to return a value based on where something is between a range of alphanumeric characters. At a basic level something like the below: <tbody> Start Location End Location Who A001 A100 MT A101 A200...

I'm looking for a non-array formula that will find the position in a list of the number closest to another number. In A1:A6, let's say I have 1;2;7; ;8;9 The closest number to 6 would be 7, so the formula would return 3 for the 3rd position. The closest number to 3 would be 2, so the formula...

Have values in C21-G21 ranging from 0-3. if the value is a 0 or 1, return an 0;if the value is 2 or 3, return an 1. Thanks or any responses.

Hi there. I have searched for the answer but I think maybe I'm not quite describing my aim correctly in order for the search to return what I need. Anyway I'm sure it's pretty easy for you guys. Here goes. I would like a function/formula for the following. If cell A1 is greater than the value...

Hi, Is there a formula that would return an integer from a division calculation? For example: A1 will contain a varying non integer In A2 I would like to show the integer from dividing the value in A1 however, this division is limited by a set number. If A1 = 2.962 this number should then...

i am hoping someone can help me with an IF formula that has multiple conditions. I have tried a few different ways but still I cannot get it to work. What I require is if A2="0" then return a blank if L2 ="0" then return a blank If A2>L2 return "Late" If A2 is <=L2 then return "on time"...

Hi all, I am trying to use a tab name as part of a VLOOKUP formula however what I have so far returns #N/A VLOOKUP Formula =VLOOKUP(U5,'SCORING BY MONTH'!A4:B203,2,FALSE) And in cell U5 I have the following: =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255) In this instance this...

Hi, I have a set of data that looks like this: <tbody> Name 1 2 3 4 5 A 12 15 16 10 6 B 6 4 15 1 19 C 22 14 13 17 10 D 6 8 7 10 6 E 8 9 15 26 4 F 10 14 19 2 10 G 15 16 20 25 15 H 16 20 22 10 8 I 14 16 19 17 6 </tbody> In another sheet I have the list of names but not in...

Is there a way to lock the return value of a formula. I need my vlookup formula to return the value and leave it unchanged because the data range vlookup is pulling from will be deleted on a daily basis. Any and all help is appreciated. Thank you.

Dear All, I am trying to convert a hexadecimal string eg <style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>EAAA863573781B which should return <style type="text/css"><!--td {border: 1px solid #ccc;}br...

Hi Does anyone know how i can return multiple column using VLOOKUP in a new workbook? I have tried this off the net but it won't work. =VLOOKUP(A3,[Parks and Leisure Sites.xlsx]Sheet1'!$A:$F,{2,3,4,5},FALSE) Thanks Ernie

Hi all, I have tried ( I am very new to this) to write a CASE statement where if the product Family= custom and unit list price =0 return NO but the tricky part is everything else with a list price of 0 needs to be YES else NO. No matter how I write the statement the list price of 0 is...

Hello, If i have a series of numbers as per the below, how do i make the lowest value return a 0? A1 - 25 A2 - 36 A3 - 14 A4 - 20 A5 - 6 In B1:B5 i need B1 - 25 B2 - 36 B3 - 14 B4 - 20 B5 - 0 Thank you

Hi, In A2:A1000 in Sheet1 I have series of consecutive month-end dates (31/07/2012, 31/08/2012 etc). In A2:A700 in Sheet2 I have a series of consecutive month-end dates and in B2:B700 the associated monthly sales values. In A2:A700 in Sheet3 I have a series of consecutive month-end dates...

This is super easy for the experts but I can't figure this out with 2 arguments If cell D9 does not equal "WI" or "IA" then return a 1 - otherwise display 0