Most answered questions in Others

0 votes
1 answer

Spill formula to lookup matching row data in one sheet with column data in another and evaluate corresponding cells

Your formula's output will match I2size #'s ...READ MORE

Jan 17, 2023 in Others by narikkadan
 • 86,360 points • 749 views
0 votes
1 answer

Conditions in Excel: skip cells with dates without a year

Both Google Sheets and Excel save dates ...READ MORE

Jan 17, 2023 in Others by narikkadan
 • 86,360 points • 589 views
0 votes
1 answer

Insert formula in multiple excel sheets

To fill across the sheets, you can ...READ MORE

Jan 17, 2023 in Others by narikkadan
 • 86,360 points • 538 views
0 votes
1 answer

Is it possible to get data from a webpage in real-time to an excel file?

The conventional method of obtaining data from ...READ MORE

Jan 17, 2023 in Others by narikkadan
 • 86,360 points • 742 views
0 votes
1 answer

Modifying CSV files from a local folder-VBA

Solution  You need to fully qualify your Columns object ...READ MORE

Jan 17, 2023 in Others by narikkadan
 • 86,360 points • 1,130 views
0 votes
1 answer

Getting a specific value from a dictionary in a function

You must assign the outcome. I changed your ...READ MORE

Jan 17, 2023 in Others by narikkadan
 • 86,360 points • 744 views
0 votes
1 answer

Horizontal Loop

There is no need to use Range if you ...READ MORE

Jan 15, 2023 in Others by narikkadan
 • 86,360 points • 681 views
0 votes
1 answer

Count the sum of difference between two cells

Use a for loop: Sub AbsoluteDifference() ...READ MORE

Jan 15, 2023 in Others by narikkadan
 • 86,360 points • 648 views
0 votes
1 answer

Is there a hierarchy inferring algorithm available in python?

Convert the list of values to the ...READ MORE

Jan 15, 2023 in Others by narikkadan
 • 86,360 points • 599 views
0 votes
1 answer

How to set formula in Excel with POI?

Microsoft Excel only stores en US formula ...READ MORE

Jan 15, 2023 in Others by narikkadan
 • 86,360 points • 1,119 views
0 votes
1 answer

I Get "object required" error when using getElementByID

As you see LoginID is the id of the ...READ MORE

Jan 15, 2023 in Others by narikkadan
 • 86,360 points • 1,368 views
0 votes
1 answer

How to check if a cell is empty in a range variable?

Use WorksheetFunction.CountA() (https://learn.microsoft.com/en-us/office/vba/api/excel.worksheetfunction.counta) function If WorksheetFunction.CountA(rng) = 0 Then ...READ MORE

Jan 15, 2023 in Others by narikkadan
 • 86,360 points • 1,088 views
0 votes
1 answer

PermissionError: [WinError 32] The process cannot access the file because it is being used by another process: (Open Excel File) in Python

Try this: import os import shutil dirpath = os.path.join('C:/Path/Folder', 'Folder') if ...READ MORE

Jan 15, 2023 in Others by narikkadan
 • 86,360 points • 9,214 views
+1 vote
1 answer

Automatically move an entire row of reference cell when one cell is moved or manipulated

You are describing how manually entered data ...READ MORE

Jan 15, 2023 in Others by narikkadan
 • 86,360 points • 528 views
0 votes
1 answer

Error populating email body from word documents

There is no need to use late ...READ MORE

Jan 15, 2023 in Others by narikkadan
 • 86,360 points • 1,911 views
0 votes
1 answer

Using Visual Basic to pull data from within a range to use in an Excel function

Use AVERAGEIFS instead of the full range. ...READ MORE

Jan 14, 2023 in Others by narikkadan
 • 86,360 points • 678 views
0 votes
1 answer

Excel VBA move pivot item to last position

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

Jan 14, 2023 in Others by narikkadan
 • 86,360 points • 1,097 views
0 votes
1 answer

Paste a value from a drop-down list

Check if there is an existing sheet ...READ MORE

Jan 14, 2023 in Others by narikkadan
 • 86,360 points • 730 views
0 votes
1 answer

Excel - External link to multiple workbooks

Try the INDIRECT() function. But this won't automatically update ...READ MORE

Jan 14, 2023 in Others by narikkadan
 • 86,360 points • 598 views
0 votes
1 answer

VBA Insert row instead of copy

Try this: Option Explicit ' declare all variables Sub ...READ MORE

Jan 14, 2023 in Others by narikkadan
 • 86,360 points • 1,115 views
0 votes
1 answer

Excel - Stack Data based in Condition

Try this : =TEXT(SORT(FILTER(B:B,(B:B>=TIMEVALUE("00:04:00"))*(A:A="Available"),""),1,1),"h:mm:ss") It appears you tried Filter ...READ MORE

Jan 14, 2023 in Others by narikkadan
 • 86,360 points • 639 views
0 votes
1 answer

Color specific cell in an xlsx with python

Column B's cells must be iterated through ...READ MORE

Jan 14, 2023 in Others by narikkadan
 • 86,360 points • 2,470 views
0 votes
1 answer

Insert Excel rows for each x in adjacent country columns to prepare Oracle Calendar Event Coverage uploadsheet

Create a table (insert > table) from ...READ MORE

Jan 14, 2023 in Others by narikkadan
 • 86,360 points • 649 views
0 votes
1 answer

How do I run a VBA Sub routine continuously when working in a Workbook and not only when the Workbook is opened?

on Thisworkbook, put: Private Sub Workbook_Open() Call checkPW(True) End Sub Then ...READ MORE

Jan 14, 2023 in Others by narikkadan
 • 86,360 points • 819 views
0 votes
1 answer

EXCEL-Function to find how many people does the oldest female live with

You can try something like this: =ROWS(FILTER(B11:B9291, T11:T9291=MAXIFS(T11:T9291,G11:G9291,2))) It ...READ MORE

Jan 13, 2023 in Others by narikkadan
 • 86,360 points • 783 views
0 votes
1 answer

How to validate values entered in a multiline Excel cell?

Try: The formula in B1: =AND(BYROW(TEXTSPLIT(A1," "," ",1),LAMBDA(x,SUM((LEN(x)={3,7,4,4,5})ISNUMBER(-x)(MID(TAKE(x,-1),3,1)="."))))) Or, write a ...READ MORE

Jan 13, 2023 in Others by narikkadan
 • 86,360 points • 540 views
0 votes
1 answer

How can I scrape a excel file from a website and divide it in different parts?

Use Scrapy or beautifulsoup4 parsing data it's more convenient ...READ MORE

Jan 13, 2023 in Others by narikkadan
 • 86,360 points • 883 views
0 votes
1 answer

VBA code to select only a table. I am getting a Run-time error '1004'; Method 'Range' of object'_Global' failed

No copy/paste, just direct assignment use.Value Sub Final_Report() ...READ MORE

Jan 13, 2023 in Others by narikkadan
 • 86,360 points • 1,468 views
0 votes
1 answer

How to export print result to excel using python (for loop)

 Use the pandas library import pandas as pd a ...READ MORE

Jan 13, 2023 in Others by narikkadan
 • 86,360 points • 6,585 views
0 votes
1 answer

How can I measure time more precisely in VBA?

At the top of the script you ...READ MORE

Jan 13, 2023 in Others by narikkadan
 • 86,360 points • 550 views
0 votes
1 answer

Need help to delete rows in VBA

Here is a basic macro that deletes ...READ MORE

Jan 13, 2023 in Others by narikkadan
 • 86,360 points • 530 views
0 votes
1 answer

I want to compare two Excel files and highlight the differences with VBA

The workbook doesn't have the UsedRange property ...READ MORE

Jan 13, 2023 in Others by narikkadan
 • 86,360 points • 3,012 views
0 votes
1 answer

Using createobject("Excel.application") to create excel 2007 application

Try the next adapted way. No need ...READ MORE

Jan 13, 2023 in Others by narikkadan
 • 86,360 points • 1,178 views
0 votes
1 answer

How can I replace the nth occurence using regex in VBA?

Use: =RegexReplace("This 9 is 8 a 77 6 ...READ MORE

Jan 13, 2023 in Others by narikkadan
 • 86,360 points • 1,477 views
0 votes
1 answer

VBA Range.Offset Error 1004 Range beyond scope of sheet Dynamic Range

Check the .Row first: With Sheets("Line 3").Range("G1024").End(xlUp) ...READ MORE

Jan 12, 2023 in Others by narikkadan
 • 86,360 points • 1,091 views
0 votes
1 answer

VBA Loop To Import Changing File Names

You can use a FOR loop and ...READ MORE

Jan 12, 2023 in Others by narikkadan
 • 86,360 points • 1,089 views
0 votes
1 answer

Delimiters in Excel VBA Regex Patterns, filter something but not others

Change your code to this: Function RemoveTags(ByVal Value ...READ MORE

Jan 12, 2023 in Others by narikkadan
 • 86,360 points • 830 views
0 votes
1 answer

Export ListBox Data to Sheet range

Use ListCount to retrieve the number of ...READ MORE

Jan 12, 2023 in Others by narikkadan
 • 86,360 points • 2,006 views
0 votes
1 answer

Crawling through multiple excel files, match and copy data to master file

One application only. It would be quicker ...READ MORE

Jan 12, 2023 in Others by narikkadan
 • 86,360 points • 902 views
0 votes
1 answer

Excel VBA- Creation of a New datablock with criteria

To insert the dropdown, you can go ...READ MORE

Jan 12, 2023 in Others by narikkadan
 • 86,360 points • 632 views
0 votes
1 answer

Look up value in dictionary and put the value in cell - Excel

 Use VLOOKUP, to make sure that your "Another ...READ MORE

Jan 12, 2023 in Others by narikkadan
 • 86,360 points • 782 views
0 votes
1 answer

Excel Power Query Group by

Try this let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content], #"Grouped Rows" = ...READ MORE

Jan 12, 2023 in Others by narikkadan
 • 86,360 points • 673 views
0 votes
1 answer

Highlighting Unique List of Words in Each Cell of a Selection of Cells - Excel VBA

In a Textbox it is a vbcrlf ...READ MORE

Jan 12, 2023 in Others by narikkadan
 • 86,360 points • 672 views
0 votes
1 answer

Excel VBA - Using Error Traps where Another Routine is Called

Macro1 is illegible as syntax. After the ...READ MORE

Jan 12, 2023 in Others by narikkadan
 • 86,360 points • 511 views
0 votes
1 answer

Copy last 3 rows, excluding the rows for which there is a "0" in column "C"

The copy inside the loop is overwriting ...READ MORE

Jan 10, 2023 in Others by narikkadan
 • 86,360 points • 594 views
0 votes
1 answer

Weird Date change when copying a Worksheet into a new workbook

Try  this: Dim wb ...READ MORE

Jan 10, 2023 in Others by narikkadan
 • 86,360 points • 517 views
0 votes
1 answer

Find the serial number with criteria

Use the filter function: =FILTER($C$11:$C$39;($H$11:$H$39=MAXIFS($H$11:$H$39;$N$11:$N$39;4))*($N$11:$N$39=4)) Maybe you have to ...READ MORE

Jan 10, 2023 in Others by narikkadan
 • 86,360 points • 1,126 views
0 votes
1 answer

Trying to apply Solver with Macros

The  MaxMinVal was when you wanted to ...READ MORE

Jan 10, 2023 in Others by narikkadan
 • 86,360 points • 494 views
0 votes
1 answer

How to improve VBA Code for Monte Carlo Simulation?

Try this: Option Explicit Sub MC_Sim() ...READ MORE

Jan 10, 2023 in Others by narikkadan
 • 86,360 points • 956 views
0 votes
1 answer

Textjoin with adjacent headers and rows with a twist

Try the following formula- =TEXTJOIN(" ",1,FILTER($A$1:$C$1,A2:C2<>"")&":"&FILTER(A2:C2,A2:C2<>"")) To make it ...READ MORE

Jan 10, 2023 in Others by narikkadan
 • 86,360 points • 683 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.