returned

Hi Guys Need your assistance in separating the words given in the subject line For eg : the subject line as below Returned Ticket Notification INC000000515843 Returned CI: SAP: Transport Equip Missing Information I want to separate word which comes after Returned CI till ":" or "-". In this...

I am using Power Query to review an Excel file and look for any error values (such as #NA , #VALUE , etc.). When PQ imports these, it converts the cell to Error. If returned to the Excel worksheet, these cells become null. I'd like to know if it's possible to have PQ actually return the cell...

Very mysterious to me that COLUMN() will not work in this case. I illustrate with an example to isolate the problem. Fill in V1:V10 on Sheet2 dates 9/1/18, 9/2/18...9/10/18. Enter into W1:W10 numbers: 15, 18, 9, 25, -15, 14, 7, 3, -7, 4. There is a defined name "firstrow" which is = 1 (but...

i have a vlookup against another tab and the numbers that have ONE leading 0....theyre stored as text....when i do the vlookup, tho, the leading zero isn't returned.. is there a way to pick it up without having to concatenate?

Hi All, I'm trying to use a formula to find the first alpha character from the right of a string. For example, from the below, I'd expect "C" returned. <colgroup><col width="161" style="width: 121pt; mso-width-source: userset; mso-width-alt: 5888;"> <tbody> BABA US 09/21/18 C165...

Link to sheet: https://docs.google.com/spreadsheets/d/1nZs3it5lLQm8onE7KPP-RYfpnpeKivNQMtRvcrYqxmM/edit?usp=sharing I am needing to finish the pay sheet for my sales staff. I am needing to return a certain value in column R if 2 different cells have specific data and needing to return a...

Greetings, Unfortunately, aim facing a very complicated problem in excel and I need your solution please. Briefly, if I have a product A as follows: <tbody> Product Qty Price A -3 100 A -5 130 A 4 ?? A 4 ?? </tbody> 3 parts were withdrawn with price 100...

Hi guys, I have this formula which matches two criteria and returns upto 4 values all in the same cell. It works well and as i intended but one thing I'd like to address is only putting commas in if a trailing value is returned. So my question is, if no value is returned, is there a way to not...

Hello, I am hoping someone can help me with a formula issue. Thank you for your help in advance. Column A: Items Column B: Type of the item is Column C: Value of the occurrence I am attempting to have a value returned which will havemultiple criteria and return the maximum value for that...

I have a table of data: <tbody> Value Function ID Current Returned List Expected Returned List 3 Create 1000 1000 1000 2 Do Not Create 1200 1111 3 Create 1111 1111 1456 1 Do Not Create 2222 2 Create 3333 3 Do Not Create 4444 3 Create 1456...

Is there a way to make this work? Scenario: Table of variable height is returned from Power Query to Excel workbook. For visible audit purposes ONLY some calculations are added to this table before it is sucked back into power query. This is because my manager freaks at an if statement in Power...

I have an Excel 2013 document where I am getting a little confused with IF and AND functions. My problem seems relatively simple to resolve but I am having a few challenges! I have three columns which are affected. In Column A there is a deadline date In Column B there is a completed date In...

Hi, I have an issue trying to get a conditional formatting set up on returned values from formulas. I have a worksheet with formulas in it that return values from another worksheet in the same workbook. I want to keep the formulas in the cells but impose a CF based on the value of the...

Hi All, I require some extracting and correlating data. In my raw data i have a PA1 followed by a PA6 <tbody> PA1*7*-1*Item one PA6*81001234*Item one I require the "7" and the "81001234" to be returned in specific places in a table so i can then do a look up against them. One thing to...

I have a range of codes at column a (about 1500 codes) I used =countif($A$1:$A$2000;EG43) to check if the input code at EG43 is correct and it returned 1 but should have returned 0. EG43 contains R1738* while at A81 there is the value R1738.If i delete the value of A81 countif returns 0 so the...

I know this is probably simple, but I am having trouble. I simply want to return the first value in a row that is not blank. So if X=blank: X X 4 X 5 6 1 X 5 X 3 X 5 X X X X X For the 1st row, the returned value would be 4 For the 2nd row, the returned value would be 3 What is the formula I...

Hi, I'm building a shift schedule for a restaurant. I want to have one cell with start time, one cell with end time, and one cell with duration. However, I want the duration to automatically subtract a 30-minute unpaid meal-period. I found an old thread with the formula below. It works...

I'm using =if(d3*e3/f3+g3<>0,d3*e3/f3+g3,0) Isn't there something similar to iferror(x,0) - that simply returns x as long as x is not an error. A number of times - I need to test if something meets some condition and if it does I just want that value returned and if not I want a zero - but...

Hi All, I have a list of unique IDs in column A, I want to check these against the unique IDs in column A of "tab2" and when there is a match I want column B of "tab2" checked for an occurrence of "3(1)". With column B the cells maybe mixed so some will have "3(15), 2(18)" in this occurrence I...

Hello, I have the following formula: =IFERROR(INDEX(Matrix!A4:A98,MATCH("DNA",Matrix!F4:F98,0)),"") This formula works perfectly and searches the array for DNA and returns the appropriate cell value. However I need a separate formula to search for 2nd,occurrence and not return the value that...