excel

[Solved] nested IF, AND, OR function compare and give result excel

by

Try this formula =MATCH(G5,{“Prica Plus”,”Miks S”,”Miks M”,”Miks L”,”Miks XL”,”Miks XL Plus”,”Miks XXL”,”Super”},0)-MATCH(F5,{“Prica Plus”,”Miks S”,”Miks M”,”Miks L”,”Miks XL”,”Miks XL Plus”,”Miks XXL”,”Super”},0) Above formula can be broken down in two parts. Firstly, matching Cell G5 to your values =MATCH(G5,{“Prica Plus”,”Miks S”,”Miks M”,”Miks L”,”Miks XL”,”Miks XL Plus”,”Miks XXL”,”Super”},0) Secondly, matching Cell H5 to your values =MATCH(F5,{“Prica Plus”,”Miks S”,”Miks … Read more

[Solved] FDDividendAmericanEngine Function in QuantLib

by

It says clearly in the instructions in the link you provided: Within Excel, the function is named – CT.ENG.FDDividendAmericanEngine This means, in Excel, you should not use: FDDividendAmericanEngine …you should instead use: CT.ENG.FDDividendAmericanEngine To find out how to use functions from a third-party add-in, you need to consult the products documentation (as I just did), … Read more

[Solved] Conversion of large .csv file to .prn (around 3.5 GB) in Ubuntu using bash

by

It’s not clear from your question as you didn’t provide sample input/output we could test against but it SOUNDS like all you’re trying to do is this: $ cat tst.awk BEGIN { split(“7 10 15 12 4″,w) FPAT=”[^,]*|\”[^\”]*\”” } { gsub(/””/,RS) for (i=1;i<=NF;i++) { gsub(/”/,””,$i) gsub(RS,”\””,$i) printf “<%-*s>”, w[i], substr($i,1,w[i]) } print “” } $ … Read more

[Solved] Get exchange rates – help me update URL in Excel VBA code that used to work [closed]

by

Split: Now you have obtained the JSON string you can parse with Split function. Here I am reading the JSON in the comments from a cell Option Explicit Public Sub GetExchangeRate() Dim json As String json = [A1] Debug.Print Split(Split(json, “””5. Exchange Rate””: “)(1), “,”)(0) End Sub JSON Parser: Here you can use a JSON … Read more

[Solved] Why does my macro only work once?

by

Would it work this way? Sheets(“Weekly Plan”).Select ActiveSheet.Unprotect Sheets(“Template”).Select Rows(“1:21”).Select Selection.Copy Rows(“6:6”).Select Range(“B6”).Activate Selection.Insert Shift:=xlDown Sheets(“Weekly Plan”).Select Range(“K10”).Select Range(“K28:K47”).Select Range(“K47”).Activate Application.CutCopyMode = False Selection.Copy Range(“K7”).Select ActiveSheet.Paste Application.CutCopyMode = False ActiveSheet.Protect solved Why does my macro only work once?

[Solved] Splitting multiple columns data into rows

by

Try this code (comments in code): Sub Expand() Dim currentRow As Long, lastRow As Long, table As Variant, i As Long, _ valuesInOneRowCol1 As Variant, valuesInOneRowCol2 As Variant, valuesInOneRowCol3 As Variant lastRow = Cells(Rows.Count, 1).End(xlUp).Row currentRow = 2 ‘read hwole range to memory and clear the range to fill it with expanded data table = … Read more

[Solved] Macro in Excel to Copy a Worksheet (by referencing every cell)

by

If you want to avoid the clipboard may I suggest R1C1 formula format: Sub fillsheet() Dim ows As Worksheet Dim tws As Worksheet Dim rng As Range Set ows = Worksheets(“Sheet1”) Set tws = Worksheets(“Sheet2”) Set rng = ows.UsedRange tws.Range(rng.Address()).FormulaR1C1 = “='” & ows.Name & “‘!RC” End Sub 1 solved Macro in Excel to Copy … Read more

[Solved] Java list write in Excel [closed]

by

Use apache poi to play with xls files http://poi.apache.org/ Here is a good tutorial : http://www.avajava.com/tutorials/lessons/how-do-i-write-to-an-excel-file-using-poi.html package test; import java.io.FileNotFoundException; import java.io.FileOutputStream; import java.io.IOException; import java.util.Date; import org.apache.poi.hssf.usermodel.HSSFCell; import org.apache.poi.hssf.usermodel.HSSFCellStyle; import org.apache.poi.hssf.usermodel.HSSFDataFormat; import org.apache.poi.hssf.usermodel.HSSFRow; import org.apache.poi.hssf.usermodel.HSSFSheet; import org.apache.poi.hssf.usermodel.HSSFWorkbook; import org.apache.poi.hssf.util.HSSFColor; public class PoiWriteExcelFile { public static void main(String[] args) { try { FileOutputStream fileOut = … Read more

[Solved] Excel – opening file stuck on 100%, until VBA code finishes

by

I solved the problem by letting VBA excecute Workbook_Open event ASAP. I put the whole earlier content of Private Sub Workbook_Open under “scraper” procedure and now it looks like this: Private Sub Workbook_Open Application.OnTime Now + TimeValue(“00:00:01”), “scraper” End Sub It must be that Excel won’t (sometimes?) open the file before executing Workbook_Open event. solved … Read more

[Solved] How to select an specific item on a drop down list on ASPX site

by

This particular web page isn’t using <select> and <option>. That suggests to me that they are using some custom JavaScript to simulate a drop-down list using the illustrated <div> and <span> elements. In addition, they are using onselect rather than onclick to trigger event handlers. I can’t replicate your test case. However, I did make … Read more