i am trying to import a excel data in to ms access file using python. below my code; import pandas as pd import urllib.parse import sqlalchemy from sq...

I'm trying to figure out how to create a formula to call out an entire range where there is a date less or equal to today's date. In this example, I h...

I am attempting to add an excel formula to calculate Upgrade Effort based on certain conditions that will refer to other columns in the same excel she...

Here I'm having the below formula. =SUMIFS(Table2[Amount],Sheet2!$A$6:$A$9,Sheet1!E8,Table2[Category],Income[@Income]) I want to make Table2[Amount] a...

I want to use function instead of range in excel SUMIF function like i used below =SUMIF(row(E14:P14)," I want the sum of that row only if that row is...

I have 3 dynamic array formulas. In the below example, they would be the columns "X", "Y", and "Type". For the purposes of example answers, let's use ...

I have a table in excel Column 1 has a list of items. I want to categorise them under different headings by matching them e.g. if the item was an ‘app...

I'm trying to concat multiple files in folder with pre defined sheets name (Because each file has some sheets that I don't want to concat) but I got a...

I have an Excel worksheet (TAB1) that lists items like this. Class Type AA A AB B AC A AD C So, there are unique Class values, but t...

So when you use IF() and AND() at the same time, does excel run all the logics even if it fails on the first logic? Example: IF(AND(A1=1, A2=2, A3=3),...

I am running my macro: Worksheets("LP").Range("D:D").Copy Worksheets("LP").Range("C:C").PasteSpecial Paste:=xlPasteValues Worksheets("LP").Range("C1:...

I have a user form in excel written in VBA. There is a label in my user form and I want to change this label's caption each time I click on it. For ex...

I am trying to create new excel web-add in using JavaScript (https://learn.microsoft.com/en-us/office/dev/add-ins/design/contextual-tabs). But I am n...

I've got some issue with the filter function. When I'm using weeknum in a filter fuction on a whole column I get a Value Error. I guess I could solve ...

I am trying to work in a formula that can search a set of values in a specific cell, and if so, sum 1 per each found value. Today I am able to achieve...

I have a list of tables (UserForm listbox) I want my users to pull into Excel when they need to create a PowerPivot. I create the query just fine, I ...

I am trying to calculate the Customer Lifetime Value. I have all the components except for the Average Customer Lifespan, which I am having trouble co...

with openpyxl can we move column 'EE' to column 'CC' it should look like below excel here column 'EE' moved to 'CC' place and 'CC' automatically mov...

In Excel (2021) I have a header row for 11 columns. In my data rows, in column 1 through 10, I have numbers. I want column 11 to be the column head...

So I am trying the spreadsheet to inform me if there are accidental duplicates. I will show the image first to make explaining easier. So what I am t...

Full disclosure, I'm not a programmer but can attempt to write a little bit of code with some help from the forums. I'm trying to use python to manipu...

Let's say I had the following data on row 2 in the range in Excel (A2:L2): A2 B2 C2 D2 E2 F2 G2 H2 I2 J2 K2 L2 |31|28|00|00|07|00|00|00|05|31|10|00| W...

Not sure what wrong with code below, i want to give white color to the text import openpyxl from openpyxl import Workbook from openpyxl.styles import ...

In the example below I'd like to enter in cells L4, M4 and N4 a formula that will return all the flavors (range C:C) for a given product (range B:B). ...

I would like to develop the formula based on the IF(AND) statement, which will throw more than 2 results. Usually, it's just 2 (value if true and valu...