output

Hi, Formula needed as per below inputs Sheet 1 <colgroup><col><col></colgroup><tbody> A1 B1 From To 435190 435200 416401 416409 437932 437960 435328 435365 438001 438046 435254 435278 </tbody> Sheet 2 - in A1 should come output as per below <colgroup><col width="64"...

Hi, I am trying to ignore the blank cell whenever the marco finds it. I need is the output workbook to be copied a blank cell if the Input workbook has one. Instead of this, I am getting the output of values from the input that is in the subsequent cell and everything moves upwards...

Hi, I've got a workbook with multiple sheets, which is used to facilitate operational processes. I'm almost done with the "tool" except for one more thing. I am looking for a vba code to save the sheet called "Input CW1" as CSV with the following side notes: - I wish to save the file under the...

Excel 2007 If A1 is >10000 but <20000, then 3% of D1. If A1 is >20000 but <30000, then 5% of D1 If A1 is >30000, then 6% D1. For example: if A1 is 17000 and D1 is 1000, then 3% of D1: Output is 30. If A1 is 29000 and D1 is 1000, then 5% of D1: Output is 50. If A1 is 35000 and D1 is 1000...

Hello, I am trying to create an Excel file that will scrub the output of a program I use (excel file output) into the format of the input I need for a different program. My issue arises when the output file will put the minutes of an employee into various columns of the same row based on...

Sub ExportTextToCSV() Dim oPres As Presentation Dim oSlides As Slides Dim oSld As Slide 'Slide Object Dim oShp As Shape 'Shape Object Dim iFile As Integer 'File handle for output Dim sTempString As String Dim PathSep As String Dim Quote As String Dim...

Hi! I'm still learning to use nested formulas, and I'm trying to divide this particular formulate below by 7, but when I put /7 the output is incorrect (in this case the sum is 24 but the output of when I put /7 I get 20 - which is definitely not right). Please help...

Hi, I need to filter some time series data gathered during an experiment. Column A is Time starting at 0 increasing in 0.1s increments. Column B is voltage data. The number of data rows varies. I found an online program that calculates digital filter coefficients for a selected filter type...

=IF(MOD((J29*1.1),12)>=9,CEILING((J29*1.1),12),(J29*1.1)) This current formula I am using is not working the way I want it to. Here is what I am trying to do: I want the user to enter a number in cell J29. Cell B29 then takes that number and multiplies it by 10%. The result of that number...

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)

I have this formula which works if 'AM Targets'!F6=Budgets!$H$3 : =IF('AM Targets'!C6=Budgets!$L$5,Budgets!$M$6,IF(AND('AM Targets'!C6=Budgets!$G$4,'AM Targets'!F6=Budgets!$H$3),Budgets!$H$4,IF(AND('AM Targets'!C6=Budgets!$G$5,'AM Targets'!F6=Budgets!$H$3),Budgets!$H$5,IF(AND('AM...

=IF((OR(B8=0.375,B8=0.5)),CEILING(C8*D8+E8+F8*0.057+G8*0.094+IF(AND(B8=0.375,H8="X"),0.328125)+IF(AND(B8=0.375,I8="X"),0.453125)*0.25,CEILING(C8*D8+E8+F8*0.069+G8*0.125+IF(AND(B8=0.5,H8="X"),0.4375)+IF(AND(B8=0.5,I8="X"),0.59375)*0.25,0))) The above formula outputs "0". How I want this formula...

I understand Excel can't open a connection to itself, and create an sql-based Recordset without memory leaks. Has this been fixed in later versions, or does the problem remain? In which case are there other solutions? My goal is to output my query (or equivalent) to a Listview control. Can I...

Hi, I am very new to VBA, hence the question is quite basic. However, after browsing forums, i could not tackle it myself. I was doing some modifications to the below part of a SUB. It extracts information from one sheet as per the first row and should make the ''desired output''. I have the...

Hi everyone! I work in medicine and have a data analysis project I'm trying to work on. The basic premise is that I have an excel workbook that's the output of a database search of our radiology records system (submitted a keyword search to radiology system, it output all results to this...

Hello, I need the output from given information: Here is the data information: <tbody> No Mar May Sep Dec 20 5 11 7 20 8 21 9 2 21 5 7 </tbody> The output required: 6 digit unique number for each row i.e 100011 + No + 2017 + Month Number(3) + 31 + amount (5) so for all...

Dear All, Greeting for the Day! I have a query in VBA, I have written the code successfully and macro running properly from backend i.e VBA Editor. But when I'm running the code from excel the automation is not giving me the complete output. Need your expertise in this to understand why it...

Hi, can anyone help with with this problem. I have a list of data where I've done a conditional format to identify duplicate email addresses. I've tagged each email address relevant to the user's interest. So imagine you had a user who had three interests and another with 2 and another with 1...

I found this and it works for what I need, but how do I get it to list through the entire Column A and how would I get it to output the results in column B or at the very least highlight all the matching results in column A...

Hi, I have already setup dependent lists for example if in the "Region" drop down in Cell E4 if you select "EMEA" then all EMEA countries will display in the drop down for cell E5. This is what the data looks like <tbody> (Cell D3) Company (Cell E3) ABC (Cell D4) Region (Cell E4) EMEA...