Results for excel

December 10th, 2023

import excel data into ms access using python

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...

December 8th, 2023

Excel Formula to highlight range based on date range

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...

December 8th, 2023

Formula cell in excel shows #NAME?

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...

December 8th, 2023

How to make table value as constant in excel

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...

December 8th, 2023

How to use functions instead of range in sumif function excel

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...

December 8th, 2023

Excel - Concat values from multiple dynamic arrays into single cell

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 ...

December 8th, 2023

How to match values in a cell and return all matches (excel)

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...

December 7th, 2023

Pandas concat multiple excel file in folder by pre defined sheets

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...

December 7th, 2023

Build an Excel Worksheet that lists information from another worksheet in an opposite format

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...

December 6th, 2023

Excel order of process question (REGARDING IF and AND)

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),...

December 6th, 2023

excel vba error the sort reference is not valid

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

December 5th, 2023

Can we click multiple times on a specific label we have created and change the label text each time we click (in user form of excel VBA)?

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...

December 7th, 2023

Show excel contextual tab by default

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...

December 3rd, 2023

Excel Filter function on whole column as criteria

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 ...

December 3rd, 2023

Excel: Formula to search in a cell of a table if any of a list of values is contained in the cell, summing 1 per each found value

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...

December 5th, 2023

Creating Data Model in Excel using VBA getting Query Not Found

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 ...

December 4th, 2023

Formula for Average Customer Lifespan in excel for Customer Lifetime Value

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...

December 4th, 2023

Move column to the left in excel with openpyxl

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...

November 28th, 2023

Finding matching column header in excel

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...

November 28th, 2023

Excel Duplication verification Function

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...

November 29th, 2023

Python - Populate excel fields with incrementing time

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...

November 28th, 2023

Excel Question: How do I approach compartmentalising and summing/extracting data for instances where specific criteria is met?

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...

November 30th, 2023

Want to change font color in excel using python

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 ...

November 28th, 2023

Excel formula that returns a range of non empty cells based on conditions

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). ...

November 27th, 2023

Excel IF AND statement with multiple results

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...

- 25881
How do I undo the most recent local commits in Git?

- 11618
How can I remove a specific item from an array in JavaScript?

- 20343
How do I delete a Git branch locally and remotely?

- 7387
How can I find all files containing a specific text (string) on Linux?

- 7330
How to find all files containing specific text (string) on Linux?

- 7611
How do I revert a Git repository to a previous commit?

- 2671
How do I create an HTML button that acts like a link?

- 8481
How do I check out a remote Git branch?