returned

Hi All, I am facing a problem while sorting a group of Objects according to their values. When multiple values entered are same, then Only the First Object is being returned thrice. While I want all the objects to be returned with same values. Please help. Demo...

Is it possible to add a piece of text to say that there is no end date in the DateDif calculation I have this =IF(DATEDIF(J18,K18,"m"),"No End date") and I get the #VALUE returned

<colgroup><col><col><col span="4"></colgroup><tbody> A B C Error Code Doc 1 Doc 2 C010 C011 e C012 The question I have is if columns B through K = "e" (meaning...

Good afternoon, I'm trying to create a nested formula in cell Y1 that will return the values of HIGH or LOW depending on a few criteria. 1) First off - I want the cell to return a blank value of nothing applies 2) Looking to have the value of HIGH or LOW returned depending on if the value in...

Recently my company has changed EXCHANGE servers. I have been using CDO for years. Now my emails are not being delivered. I keep getting this message: Remote Server returned '550 5.7.1 RESOLVER.RST.AuthRequired; authentication required' How can I get around this? Thanks.

I'm helping a gentleman with some data analysis, using Power Query to combine files by adding more to a folder, like this: http://www.excel-bytes.com/how-to-combine-files-using-power-query-in-excel/ He is only up to around 12,000 lines of data. Any thoughts on why this is occurring? Using Excel...

Hello I tried to install the version for windows 8 and Hlp32Fix_Win10.zip but both processes returned an error message. I am using windows 10 and Excel 2016 Regards António Teixeira

Hi I want to count number of cells based on color. So I used conditional formatting to highlight cells which has value >70. The under column A I typed =subtotal (2,B2:B25) then I used to auto fill to copy that formula to column C, D, and E. Now all subtotal() returned 24 (so far so good). Then I...

Hi all I am using Index and Match to return values off another sheet, e.g =INDEX(!Sheet1A:A,MATCH(D2,!Sheet1B:B)) However there are some values that are being returned which I want to appear differently, these values are: 0 1900 I would like 0 to appear as "X" and 1900 to appear as "Y". All...

<!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--> I bought a new Microsoft Surface Pro 4 (Win 10 / i7 / 16 GB RAM using Excel 2016 64 bit) about 6 weeks ago and had numerous issues with it right out of the box. The OS alone has...

I am trying to copy the following formula into multiple rows within the same column: =VLOOKUP(A2,'[Sheet1.xlsx]sheet1'!$A:$2:$AP$220,3,FALSE) It seems to work, adding appropriate errors when no value can be returned but when I copy the formula down the column into different rows, it doesn't...

Hi All, I am trying to add another IF to the following formula IF AH16 is not "" then print "Partially Returned" IF AF16 = AH16 then print "Returned" =IF(AV16="","",IF(B16='Order Status'!AF16,"Received",IF(OR('Order Status'!AF16="",'Order Status'!AF16=0),"Ordered",IF('Order...

Hey Everyone, I have a formula that text joins three cells using index/match for each. The second cell being joined is a number. Is it possible to have the number being returned by the index/match multiplied by a number in another cell? If my current formula returned: Truck 5 Cat. The new...

I am using vlookup - it is returning N/A where there is no value - I would like a value of zero returned - how do I fix?

I need Excel to select a value depending on a random coin flip. The values are: 5, 10, 15, 20, 25, ... through 95. The beginning number is always 10. If the coin returns tails the number returned will always increment one level (plus 5, but never greater than 95). If the coin returns heads the...

Hi there, I am trying to eliminate text that has been returned in a report. This is what has been returned...

Hi there, I can't believe that I am asking this because I can't figure it out - its been a very long day at the computer screen so I think I am having a brain freeze.... I am trying to find the percentage from the sum from a series of cells. The returned value of these cells is in A1. "67"...

Hello all, I hope you can help me. I have a spread sheet set up and I record when documents are returned to me. When I put the word "returned" in a cell , I'd like the date the document was received to be posted into the adjacent cell on the spread sheet. Thanks MR VEB

Hi All, Can I expand the following formula that if the value in A2 is not found within the "Data" tab that the word "Empty" is returned? =(VLOOKUP(A2,Data!A1:C887,3,FALSE))

Hi I hope this makes sense. I'm trying to do a lookup which would return the match against the first instance and be blank for the remainder of the matches. Appreciate any help <tbody> Red returned look up value Red (Blank) Red (Blank) Yellow returned look up value Black returned...