modify

hi all.. i have following problem to modify this formula...

How do I modify this: =IFERROR(VLOOKUP($A8,'D:\Corporate\Analytics\2019Analytics\Final2019\[NewsLettersJan2019.xlsx]Stations'!$A$3:$FC$156,64,FALSE),"") so the result is multiplied by J6 thank you in advance

How can I modify the below to round the output to 2 decimals? =IF(AND(ISERROR(AOT_PricePerShare),AOT_Shares>0),-AOT_BasePrincipal,AOT_PricePerShare*AOT_Shares)

Hi, I have the macro below so that it saves a copy of an excel sheet to pdf in folder named "chits". I need that the file name will be as cell J8. What I have to change in the macro? Thanks in advance Sub Macro1()' ' Macro1 Macro ' ' ChDir "C:\Users\littl\Desktop\chits"...

Hi, I've found a thread in below and I would like someone help me to modify autofilter at cell CL13 https://www.mrexcel.com/forum/excel-questions/974450-autofilter-loop-vba-code.html Regards, tt3

I have used this code before and it functions fine. I want to modify it for another use. original code {=IFERROR(INDEX(Entry,MATCH(1,(B56=Div)*(B57=Model)*(MAX(IF(Div=B56,IF(Model=B57,Pts)))=Pts),0)),"x")} I no longer need "model", so I thought I could just removed it, but it's not...

Hello all, I have been looking for a formula that would give me a total number of numeric data entries. i.e: E5 8 E6 7.2 E7 5.5 E8 6 E9 16.4 =count(e5:e8) My result is 2, how can I modify or use a different formula to total 5, including decimal numbers that may have been entered. Thanks in...

Hi to everyone, i have searched around to find the specific macro that i can use to solve my issue but nothing works, so i need a modified macro to help me get cell values from multiple files in one folder C:\workbooks (.xclx) the concrete cells i need to get data from are A1 E59 E60 etc. (i...

I have some cells in a spreadsheet with a small red triangel in the upper right-hand corner; don't know how they got there. If I hover ove the cell I get a message box with the name of the ONLY other person (besides myself) that is allowed to modify data. How do I ger rid of this red thing...

Hi people, I come across some similar posts but not able to modify it to my purpose. In column C & F has if function, D&E has sum function. The formula in C:C is =IF(AND(M4>=3,N4>=2,O4="wait"),"wait",IF(AND(M4<=-3,N4<=-2,O4="close"),"close","-")). These values in D,E and F keeps changing for...

Hi, I have this macro that works fine; it copies the date from a cell in that sheet to the tab name. Sub myTabName() ActiveSheet.Name = ActiveSheet.Range("A1") End Sub How can I modify it so it can change the other 11 tabs so I have a full year of monthly tabs in sequence? Thanks

Hi I am using the following formula to find the earliest date in a column of cells for a particular year, in this example, 1994. =AGGREGATE(15,6,Records!$F:$F/(YEAR(Records!$F:$F)=1994),1) I now wish to modify this such that it will only consider cells where a corresponding cell has a value...

Hi, I have a report which is generated with VBA referencing data from another sheet with formulas then turned into values Example Range("D2:D1000").FormulaR1C1 = "=R[-1]C[-1]*10" Range("D2:D1000").value = Range("D2:D1000").value Which works fine but the problem is if I ever need to modify...

Good morning. I need some help altering existing VBA. Right now, the code will paste under the last used row. I would like to modify this so that the copied data is pasted starting at B5 of the master, with each file pasting underneath. What I currently have is this: 'set to the current...

I've seen the post to find (6 consecutive numbers adjacent to each other in the string) with the solution being: =LOOKUP(10^6,MID(A1,ROW(INDIRECT("1:"&LEN(A1)-5)),6)+0) I am trying to find the first 3 digits in a string like this: text 777 moretext 555. When I apply the solution above and...

hi all... how to use if, vlookup & and together like this : i want to adding AND function, e.g. in cell AF79 with criteria in cell "AF79>0" how to add that function? maybe modify : =IF(And(VLOOKUP($AL$8;KKI!$A$2:$P$137;11;0)=U71;"V";"";>0" but not work for me... would you help me? susanto...

I am using the following for a student roster to provide a short list of absent students. I want it to return all students that have a "Y" in the "Absent" column. How do I modify this? Thanks...

Hi All, The below connection code line using to send data in access DB. cs = "Provider=Microsoft.ACE.OLEDB.12.0; Data Source=\\inmum-i-fs4\group$\WNA Skyline\H&B\Timesheet_Data.accdb" I want to modify this code for older version of access DB. Can anyone please provide me code..

I have this formula that I need help to modify =LARGE(CHOOSE({1,2,3,4,5},Z3,AC3,AF3,AI3,AL3),1) I want modify the formula to only function with a result if there more than one value to calculate. If there is only one value the result would be 0 or blank

Is there a way to link worksheets together, to where I modify one and the other updates? Thank you,