assist

Good day, I am looking for a formula to look for a partial number within a column on a different sheet. Some of the numbers does contain letters for example H1007 or S0436, but they typed it in as 1007 and 436. The only other problem is the numbers are within a description/sentence. Please...

I have tried to use the following formula to find the maximum date in format mmm-yyyy that is in Col E on sheert 'Data" I use formatting in Col E as dd/mm/yyyy Book1CD1Jan-1900SummaryCell FormulasCellFormulaC1=TEXT(MAX(Data!E:E),"mmm-yyyy")...

Sorry guys, I've done this before but cant get it to work this time I have a name as such John,Doe but I need an extra space after the comma as such John, Doe Please assist

Hi, Can someone please assist me in changing the following formula to work if the criteria in Z2 is anything other than "SCT" =IF($Z$2<>"",IFERROR(INDEX(Backorders!$G$2:$G$1000,SMALL(IF($L$2:$L$1000=$Z$2,ROW($L$2:$L$1000)-ROW($L$2)+1),ROWS(AJ$2:AJ2))),""),"") Many thanks

I have a number 19920195872597 I need a to format this as 1992/01958725/97 It would be appreciated if someone could assist me using a custom format

Hi, Can you please assist in providing a formula in which I can extract a part of my raw data line item. Please see below of my raw data and how I want the output to look like. Can you please assist? <colgroup><col><col><col></colgroup><tbody> RAW DATA What I want the formula to provide...

I have the following list of numbers,from which I have to choose numbers which add up to 6649.35 I have tried to use Solver, but it seems not to be able to find an answer. I suspect I am doing somerthing wrong in Solver and am anxious to see if someone at Mr.Excel can assist please...

Hi, Column A(A2:A22) and B(B2:B22) contain ID and text. If column B is blank, I want column C to contain a number that counts down to 1 in the last row that contains a blank cell in column B only. (If column A and B is blank return C blank) I am apply the following formula but value return...

If a cell in column B contains the letter "J", copy the value of the cell in column C, next to the value found in B, to column L in the same row. Note: Column B will always be made up of only one letter. Could you please assist me with a function for this. If it makes any sense.

I need a solution to open an a specific pdf (Adobe Acrobat 9 Pro Extended) page in 2016 excel (workbook, sheet 3) in my own local drive. My PDF document is a sub-folder in my laptop. Please assist.

Hello Can some one assist in vba code what is the meaning of SpecialCells(2, 1)

Hi all, I am trying to COUNT the values in a column, but only if they do NOT correspond to a duplicate value in a different column. In other words, only count the Xs for only ONE instance of 101, 102 or 103 in the example below. This is well beyond me and my powers, but could anyone kindly...

I have the following sumifs formula which gives me the correct result =SUM(SUMIFS(C:C,B:B,({"*lab mon*","*lab fast*"}))) However if I use the following formula , it returns zero =SUMIFS(C:C,B:B,"*lab mon*",B:B,"*lab fast*") It would be appreciated if someone can assist me

Hi Guys, Relative newbie here ... I have found code on here an I have made it do what I want but I want to see how I can do a paste special link option in the below line if you could so kindly assist me :) For i = 1 To LastRow With Worksheets("Details") If .Cells(i...

hi all I have the following to delete the last non-empty row [Sheets("sheet1").Cells(Rows.Count, 1).End(xlUp).EntireRow.Delete] I also need to add to the above code once it finds this row to delete the row immediately above it. Can someone please assist.

Hello, I have a long repeating angle/circular sequence as example below which repeats at every 360 degrees. I wish to add 360, 720, 1080, 1440 (circles) at every turning points so I get an ascending sequence. <colgroup><col><col><col></colgroup><tbody> Original sequence Desired result Note...

Hello I have the following statement that is working fine however I would like to add an additional criteria to the statement: round (IF([PAYTYPE]<>'Stipend' ,IF([PAYTYPE]='Ftn',((([ANNRATE]+([ANNRATE]* ToNumber([RATEINC])))/10)*261)*[PRORATESAL], ((([ANNRATE]+([ANNRATE]*ToNumber...

Hello I have the following statement that is working fine however I would like to add an additional criteria to the statement: round (IIF([PAYTYPE]<>'Stipend' ,IIF([PAYTYPE]='Ftn',((([ANNRATE]+([ANNRATE]* ToNumber([RATEINC])))/10)*261)*[PRORATESAL], ((([ANNRATE]+([ANNRATE]*ToNumber...

I have a column with first and last names in it. I need to split them into two columns, however I can't use Text to Columns because some of the names are formatted as FirstName LastName, but others as FirstName & PartnerFirstName LastName. I need a way to break it up on the following conditions...