Trending questions in Others

0 votes
1 answer

VBA - Applying border around the areas with value/text

Try this: Sub BorderArroudAreas() Dim sh ...READ MORE

Mar 31, 2023 in Others by Kithuzzz
 • 38,000 points • 1,516 views
0 votes
1 answer

Conditional Formatting not applying to all the cells in a given range

Use the following instead as the Formula: =$P5=75% I ...READ MORE

Apr 7, 2023 in Others by Kithuzzz
 • 38,000 points • 1,196 views
0 votes
1 answer

Conditional formatting on a calculation in excel

In E5, you could use =IF(COUNTBLANK(E3:E4)=0,E3-E4,"") which would ...READ MORE

Apr 1, 2023 in Others by narikkadan
 • 86,360 points • 1,452 views
0 votes
1 answer

VBA Repeatable Function on button click

Remove Duplicates Based on a Single Column The ...READ MORE

Apr 9, 2023 in Others by narikkadan
 • 86,360 points • 1,104 views
0 votes
1 answer

Use AutoFilter on the current visible data

Use the following modified code. It's assumed ...READ MORE

Apr 10, 2023 in Others by Kithuzzz
 • 38,000 points • 1,033 views
0 votes
1 answer

Excel - FIND function (case-sensitive) ignores case?

Just to show the behaviour of find(): READ MORE

Apr 3, 2023 in Others by narikkadan
 • 86,360 points • 1,334 views
0 votes
0 answers

Why does Excel give me a #NAME? error when I open this CSV file?

The CSV file consists of two lines: ...READ MORE

Apr 10, 2023 in Others by Kithuzzz
 • 38,000 points • 980 views
0 votes
1 answer

Comparing worksheets from a directory of xlsx files

Here is a refactored version of your ...READ MORE

Apr 6, 2023 in Others by narikkadan
 • 86,360 points • 1,193 views
0 votes
1 answer

Open Existing PowerPoint via VBA

You do not have the proper reference ...READ MORE

Mar 24, 2023 in Others by Kithuzzz
 • 38,000 points • 1,754 views
0 votes
0 answers

VLOOKUP with date range does not work as intended

I have two excel tables in separate ...READ MORE

Apr 11, 2023 in Others by Kithuzzz
 • 38,000 points • 1,011 views
0 votes
1 answer

How to use COUNTIFS with multiple conditions and columns in Excel?

Use  SUMPRODUCT and double unay operators: =SUMPRODUCT(- ...READ MORE

Apr 4, 2023 in Others by Kithuzzz
 • 38,000 points • 1,246 views
0 votes
1 answer

Is it possible to create a universal hyperlink in excel for windows and mac without programming

You may learn whether it runs on ...READ MORE

Mar 28, 2023 in Others by Kithuzzz
 • 38,000 points • 1,550 views
0 votes
1 answer

Nesting functions within the IF statement in EXCEL

For Excel 2019 and above use TEXTJOIN ...READ MORE

Apr 6, 2023 in Others by narikkadan
 • 86,360 points • 1,128 views
0 votes
1 answer

Create dropdown list in excel that displays different values from the same lookup table

Looks like the Worksheet_Change() sub needs two ...READ MORE

Apr 6, 2023 in Others by narikkadan
 • 86,360 points • 1,127 views
0 votes
1 answer

Mapping cells between between two ranges

Try this: =IF(B4:H10<>"",B14:H20,"") READ MORE

Mar 27, 2023 in Others by narikkadan
 • 86,360 points • 1,556 views
0 votes
0 answers

Require a dropdown list based on input that matches Column header

The input should be one of the ...READ MORE

Apr 11, 2023 in Others by Kithuzzz
 • 38,000 points • 942 views
0 votes
1 answer

Excel Debt Payoff Calculator

You can change the formula in the ...READ MORE

Apr 9, 2023 in Others by narikkadan
 • 86,360 points • 983 views
0 votes
1 answer

Excel VBA Selecting Multiple columns with last row and apply Condition Format

Try this: Sub Test() Dim ...READ MORE

Mar 21, 2023 in Others by Kithuzzz
 • 38,000 points • 1,790 views
0 votes
1 answer

Code breaks after executing copy statement in VBA?

Qualify the sheets with a workbook reference ...READ MORE

Mar 31, 2023 in Others by Kithuzzz
 • 38,000 points • 1,343 views
0 votes
1 answer

Filter a list by using another list in PowerQuery M code

Try this: let columnNames= {"E ...READ MORE

Feb 23, 2023 in Others by Kithuzzz
 • 38,000 points • 2,899 views
0 votes
1 answer

Why am I not being able to read the Excel sheet in my Jupyter Notebook

Verify that it is actually in your ...READ MORE

Mar 28, 2023 in Others by Kithuzzz
 • 38,000 points • 1,464 views
0 votes
1 answer

File module issues with excel format

The xlsx extensions are not supported by ...READ MORE

Apr 2, 2023 in Others by Kithuzzz
 • 38,000 points • 1,240 views
0 votes
1 answer

MS Excel Reordering letters in cell

Use TEXTBEFORE() function. =TEXTBEFORE(A1,"_X") For ol ...READ MORE

Apr 7, 2023 in Others by Kithuzzz
 • 38,000 points • 1,024 views
0 votes
1 answer

Export Attachment from outlook to excel cells

You will need to save the attachment ...READ MORE

Apr 3, 2023 in Others by narikkadan
 • 86,360 points • 1,192 views
0 votes
1 answer

Global Collections

To store your public objects and expose ...READ MORE

Apr 1, 2023 in Others by narikkadan
 • 86,360 points • 1,264 views
0 votes
1 answer

Excel not closing using the COM in Python

There's a lot of superfluous assignment and ...READ MORE

Jan 24, 2023 in Others by narikkadan
 • 86,360 points • 4,153 views
0 votes
1 answer

For loop to add up areas of openings excluding certain rows keeps returning #VALUE! error?

I think this might be more of ...READ MORE

Apr 7, 2023 in Others by Kithuzzz
 • 38,000 points • 1,001 views
0 votes
1 answer

Loop through each cell in a given range and change the value depending on value in a column in the same row

Use match() and if() without code at ...READ MORE

Mar 26, 2023 in Others by Kithuzzz
 • 38,000 points • 1,493 views
0 votes
1 answer

Field Wrong Calculations

You can accomplish your goals in one ...READ MORE

Apr 3, 2023 in Others by narikkadan
 • 86,360 points • 1,151 views
0 votes
0 answers

Formula in Excel with a particular increment value

I need to use Excel formulas for ...READ MORE

Apr 10, 2023 in Others by Kithuzzz
 • 38,000 points • 806 views
0 votes
1 answer

How to create arrow buttons in Excel to scroll the table left and right?

Ctrl-shift-home goes to the upper-left of all ...READ MORE

Mar 26, 2023 in Others by Kithuzzz
 • 38,000 points • 1,489 views
0 votes
1 answer

Using Substitute or Replace to change specified characters to characters in another cell in a specific order Excel

Replace Occurrences of a Substring With a ...READ MORE

Apr 3, 2023 in Others by narikkadan
 • 86,360 points • 1,141 views
0 votes
1 answer

Create dependable dropdown of unique items in vba

Try this: Sub UniqueList() Dim ...READ MORE

Apr 3, 2023 in Others by narikkadan
 • 86,360 points • 1,133 views
0 votes
1 answer

How do I adjust the size of the pasted image in Outlook email?

Try this : Option Explicit '~~> Since we are ...READ MORE

Mar 18, 2023 in Others by narikkadan
 • 86,360 points • 2,229 views
0 votes
1 answer

Combine Two Formulas in Separate Cells Into One Cell

Use the openpyxl module in Python to do that, ...READ MORE

Mar 26, 2023 in Others by Kithuzzz
 • 38,000 points • 1,463 views
0 votes
1 answer

Automatically Moving Emails to Excel, Code works but I don't want the whole email body just a portion of it

Use InStr function to find the beginning of the ...READ MORE

Apr 1, 2023 in Others by narikkadan
 • 86,360 points • 1,205 views
0 votes
1 answer

Excel If Statement with Wildcards and Value Search

Try this: IFERROR(IF(IFERROR(LEFT(B2,2)*1,"")<=10,"",IFERROR(LE ...READ MORE

Apr 2, 2023 in Others by Kithuzzz
 • 38,000 points • 1,115 views
0 votes
0 answers

asking about career advice

Hey, I completed my graduation in civil ...READ MORE

Apr 21, 2023 in Others by anonymous
edited Mar 5, 2025 • 304 views
0 votes
1 answer

Run macro when on Worksheet change (i.e. changing sheets, not data within sheet)

Try this: 'put this sub in ThisWorkbook module ...READ MORE

Mar 31, 2023 in Others by Kithuzzz
 • 38,000 points • 1,197 views
0 votes
1 answer

Click cell to generate dynamic table

Try the following: The formula in F1 (as per my ...READ MORE

Apr 6, 2023 in Others by narikkadan
 • 86,360 points • 934 views
0 votes
1 answer

Macro VBA code failing to execute a section of the code without an error

You get your code to make a ...READ MORE

Mar 24, 2023 in Others by Kithuzzz
 • 38,000 points • 1,490 views
0 votes
1 answer

How search data in excel with openpyxl?

The method iter_rows in the library has ...READ MORE

Oct 2, 2022 in Others by narikkadan
 • 86,360 points • 8,958 views
0 votes
1 answer

Power Query - Search an element of column A in entire column B

The delta column in PowerQuery is calculated ...READ MORE

Mar 30, 2023 in Others by narikkadan
 • 86,360 points • 1,202 views
0 votes
1 answer

Extracting tabular data from multiple .xlsx files with inconsistent structures

For a cell that is consistent across ...READ MORE

Mar 25, 2023 in Others by narikkadan
 • 86,360 points • 1,411 views
0 votes
1 answer

Type the max number title in Excel

If you have duplicates and want to ...READ MORE

Apr 2, 2023 in Others by Kithuzzz
 • 38,000 points • 1,061 views
0 votes
1 answer

Trying to redo my Export Button Function on my document

You could directly publish the data to ...READ MORE

Mar 30, 2023 in Others by narikkadan
 • 86,360 points • 1,192 views
0 votes
1 answer

A button in excel sheet does not work for the first time

When you press the Display button, the ...READ MORE

Mar 30, 2023 in Others by narikkadan
 • 86,360 points • 1,174 views
0 votes
1 answer

VBA Switch from an open excel app to a different open Excel app

Switch Between Excel Instances Using AppActivate After app-activating, you ...READ MORE

Mar 30, 2023 in Others by narikkadan
 • 86,360 points • 1,174 views
0 votes
1 answer

Issues with a VBA code for excel that takes the geolocation info (longitude, latitude, altitude) from a set of files in a folder

SourceFolder is an object that only understands ...READ MORE

Mar 21, 2023 in Others by Kithuzzz
 • 38,000 points • 1,561 views
0 votes
1 answer

How to transpose data in an other tab in excel

If you're using a previous version of ...READ MORE

Mar 31, 2023 in Others by Kithuzzz
 • 38,000 points • 1,127 views
Page:

Most popular tags

"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.