Category "excel"

QuantLib FixedRateBond versus Excel Yield()

I'm currently trying to calculate the Yield of Treasury Bonds in Python using the QuantLib library. As a reference I used the Excel Yield function, but I'm gett

Find duplicate column values across multiple workbooks, and extract columns row data to new sheet

I have multiple Excel workbooks some having multiple worksheets. I'm trying to export the duplicates across the workbooks into a new workbook using Column A of

Is it possible to copy, paste, and delete data from one sheet to another in office scripts?

I have a document saved on SharePoint that documents testing. Once testing has been completed I would like to move the tests (entire row) to a separate sheet to

Deleting duplicate values

I'm trying to delete all duplicate rows based on Column B and leave only the unique rows. It will leave one of the duplicate entries. I tried with > 1 and =

Excel Conditional Formatting if cell in Column A AND the cell in Column B are blank than highlight cell in Column G

I am trying to use the conditional formatting in Excel so that if a cell in Column A is blank and the cell in Column H (of the same row) is also blank then the

Using userform vbmodeless in a loop

I refer to this: How to have VBA code wait until vbModeless userform is closed I tried to apply the code in a class module for my problem. Problem description:

How to copy the last data column and insert it immediately to the right?

I have this data This code grabs column "BO" and copies it to the right. I need a repeatable macro that copies column BK and inserts it to the right, which push

How to add option button to spreadsheet?

I am trying to put together the 'Hello, World' of a macro button that will make an option/radio button on a cell in an Excel spreadsheet, the simplest possible

How to return a word from between nth comma and n+1 th comma?

I want to extract a word from text which is separated by commas. This is one of the data from users. 117573,117573,219,219,75,75,Messi,barcelona,53780217,forwa

Find xlprevious code bringing up first record not last

Here is my code I've set up and is working as a vlookup. (I can follow this and I will understand it when I come back to it in 2 years.) Sub lookup() On Error

Run along the rows in Excel

I have new entries that go into the Excel table and I constantly want to run to the last row number but it does not work excel.Row.Count() this the problem for

Locked Excel Cells Becoming Unlocked When Re Opened

I have a Blueprism process which is locking a column and protecting the worksheet. The cells are then locked. When the file is saved, closed and re opened the c

Use python to remove blank cells from column and shift populated cells up

I have this excel file and I would like to delete all blank cells in columns A and shift the populated cells up using python. Not sure how to do this, any advic

LabVIEW generated Excel files unable to be read by pandas.read_excel

I'm having an issue when I save LabVIEW outputs as .xlsx files. When I try to import with Pandas I get the following error: expected <class 'openpyxl.styles.

How to properly get if a number is between two given numbers in excel?

Given this rule to follow: And I have some value to check from this: Where cell AA727 is a result of some calculations which I already formatted into a number

Copying from a range of cells with openpyxl, Error: Colors must be aRGB hex values

I am copying a range of cells with openpyxl from one workbook to another with the following code: import openpyxl import os #Current path path = os.path.dirnam

Differences in Example and Excel Calculations

We are trying to produce an Excel file to calculate a population bioequivalence test as per the FDAs Budesonide Product Specific Guidance (PSG), which can be fo

How to subtract multiple cells

I have the above cells and i want to substract each individual row . i.e. 137.61-137.61, 132.88-270.49 and print each one of the results on the respective row

Export Excel tabs and set page formatting at same time

I have some existing VBA code that works great for exporting all tabs in my workbook as individual sheets named by the tab name. I just want to be able to set

How can I auto populate several excel sheets from other Excel files

I am currently working on a power bi dashboard that uses an excel file as a data source. I want to auto populate the excel file with new values from existing ex