returned

I know this is such an easy one, but I'm not getting the desired result and there's a lot of complicated formulas out there that are throwing me off! I just want to calculate the difference between month numbers. So April (4) and October (10) is 6. September (9) and October (10) is 1. December...

I am looking for a way to print a returned array for a specific criteria. For example, if the following values in a column do not equal 0, I would like to return them and print them in another column. I do not want to use a Macro. i.e. 0 0 0 0 Apples 0 0 Oranges 0 0 Values...

<tbody> <colgroup><col width="64" style="width: 48pt;"> <col width="112" style="width: 84pt; mso-width-source: userset; mso-width-alt: 4096;"> <col width="119" style="width: 89pt; mso-width-source: userset; mso-width-alt: 4352;"> <tbody> 44155 00/01/1900 0 44215 18/08/2019 1...

Hello all, I am working on a project and I have come to a problem I don't know how to solve, I have a grid of Data, Row Descriptions (Column B), and then My headers in columns "H:AP" and then the corresponding rows in between Range("H9:AP128"). So, I need code or even a formula that will go...

Greetings all, I'm looking to multiply the values returned by these 5 rounded sumproducts by the array created by "Volume!Y$24:Y$28/Volume!Y$63", but I don't know how to get the formula to recognize those 5 returned values as an array. Thank you for our help in advance...

I am using two vlookups in one cell such that the two values are joined together by a space =VLOOKUP(….)&" "&(VLOOKUP(…) where the value returned appears as something like: CompanyName 43658 The 43658 is the value returned from a column of dates. Is it possible to change the 43658 to a...

I just have a quick question about a formula I have that is referencing a pivot table. In some areas the pivot table will not have data yet. How can I modify the below formula that if there is an error, to display a blank cell? =GETPIVOTDATA("Part Name",'Reference Data 1'!$A$1,"Date...

Hi Team I would like to send a mail from excel with the info from - specified columns - Specific email body Please see screenshot - SDA email - that should be To - TL Email - That should be in CC - Reason and INC/WO should be in subject with line "Returned Ticket...... - Email body - "Your...

Hi all, New here and would really like some help with a formula. (Table created for clarity) I would need the formula to firstly find the persons name in the first Row, once it has been found it would look along the row and return a specific cell (For this instance say its the second row), it...

Hi All I have the following formula =IF(SEARCH("Risk",D41),"x","no") Where there is risk an "x" does appear so the formula is working but where there isn't the word risk instead of getting "no" I get #VALUE . Could any one assist me in getting "no" and explain why the "no" isn't being...

I would like a formula that I could lookup and return the latest date. There will be multiple matches, but only want the max one returned. I will have to do this for multiple lines and I have been unable to get Array formula's to work previously

I have a Advanced filter that works as expected, however I would like the user to be able to add additional criteria into two of the columns so more and more information is filter out each time. This is the working filter. Sheets("data").Range("A5:Z10000").AdvancedFilter _...

Hi, I have the following formula I am trying to understand =IF(IF(ROWS($EC$16:EC16)>$EO$14,"",INDEX($DU$16:$DU$512,MATCH(ROWS($EC$16:EC16),$EO$16:$EO$512,0)))=0,"",IF(ROWS($EC$16:EC16)>$EO$14,"",INDEX($DU$16:$DU$512,MATCH(ROWS($EC$16:EC16),$EO$16:$EO$512,0)))) the $DU$16:$DU$512 part is what...

Haven't been able to cobble together an answer for this from previous questions, thanks in advance to anyone who can help. Example data set follows with question below. <tbody> Group Value OWNRSHP_ID PNT_NO PNT_MATCH ADDRESS_LINE_1 2 500 900 11164 701 Green 2 1.5 70 6019302309 11164 701...

I am trying to return a value if one of two cells includes text by using "IF(ISERROR(MATCH" formula. I've added the OR function to try to do this but a value is not being returned even if one of the two cells includes text. Here is my formula...

Table: 1/12/17, value1 1/13/17, value2 1/16/17, value3 1/17/17, value4 I have an appointment at 9am tomorrow morning and I need to get this fixed by then. I would really appreciate some help! I need to create a formula which will retrieve a spreadsheet date from say column N1. Then, the...

Hi, I'm using this formula... =IFERROR(VLOOKUP(AG3,A2:T89,200)," ") Is there a way to also check if the text in AG3 starts with 319 and the result returned from A2:T89 was >499 then colour the result if conditons are met in red? Thanks

Hi All, I have a list of performance percentage figures which I need to give a score of 0, 1 or 2 depending on whether they improve on a benchmark or not. If a figure is greater than the benchmark figure, a score of 2 is returned. If the figure is lower than the benchmark figure but within...

Hello all. I am looking for a way to find an integers (stored as a variable) nearest multiple of 1000's, both above and below. For example, if a variables value is 5012, I would like to have 5000 and 6000 returned as two additional variables. Any ideas?

Hi Guys Need your assistance in creating a formula For eg : the txt as below Returned Ticket Notification INC000000515843 Returned CI: SAP: Transport Equip Missing Information Want to get the word after "Returned CI" i.e in this case it is SAP Want another formula to get the string after...