Trending questions in Others

0 votes
1 answer

Excel VBA If range.value = something then fills Columns G

Try this: Sub IFSomething() With ...READ MORE

Jan 23, 2023 in Others by narikkadan
 • 63,600 points • 607 views
0 votes
1 answer

Repercute value on other sheet with "auto-detect"

Try in K9: =INDEX(IFNA(VLOOKUP(C9:C; Sheet2!B:H; 7; 0))) READ MORE

Jan 29, 2023 in Others by narikkadan
 • 63,600 points • 339 views
0 votes
1 answer

Excel VBA userform paste text in expanded format (not just to one cell)

It should work if you simply supply ...READ MORE

Jan 21, 2023 in Others by narikkadan
 • 63,600 points • 678 views
0 votes
1 answer

Append same text to every cell in a column in Excel

Solution All your data is in column A ...READ MORE

Oct 17, 2022 in Others by narikkadan
 • 63,600 points • 4,830 views
0 votes
1 answer

How to multi level sort an array in excel, using formulas? I am aware about the way, using SORT button on DATA tab

Use SORTBY, e.g. =SORTBY(A2:B5,A2:A5,1,B2:B5,1) Or simply&nb ...READ MORE

Jan 22, 2023 in Others by narikkadan
 • 63,600 points • 631 views
0 votes
1 answer

Excel: Is it possible to reorder the data in 2 columns to match up if they have a certain number of characters / a string in common?

Try this: =LET(files,A1:A4, URLs,B1:B4, f,BYROW(files,LAMBDA(r,TEX ...READ MORE

Jan 21, 2023 in Others by narikkadan
 • 63,600 points • 674 views
0 votes
1 answer

Split and group values in excel

variant using scripting.dictionary: Sub test() Dim ...READ MORE

Jan 22, 2023 in Others by narikkadan
 • 63,600 points • 629 views
0 votes
1 answer

Windows 10 IE is not working with old VBA code

I discovered the answer. The issue was ...READ MORE

Dec 24, 2022 in Others by narikkadan
 • 63,600 points • 1,866 views
0 votes
1 answer

Is there any way to change input type="date" format?

To answer your question, it is impossible ...READ MORE

Feb 18, 2022 in Others by Aditya
 • 7,680 points • 15,191 views
0 votes
1 answer

Need a formula that will pull the specific value that matches a unique code from a set of data and produce another table of that specific data

VLOOKUP will work: vlookup =VLOOKUP(G2,$A$2:$D$11,3,FALS ...READ MORE

Jan 23, 2023 in Others by narikkadan
 • 63,600 points • 564 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
 • 63,600 points • 896 views
0 votes
1 answer

Attributing the value of a cell based on another corresponding cell

Put in cell B1 of Sheet1: =INDEX(Sheet2!B:B;MATCH(A1;Sheet2!A:A;0)) Drag it ...READ MORE

Jan 23, 2023 in Others by narikkadan
 • 63,600 points • 545 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
 • 63,600 points • 926 views
0 votes
1 answer

Separate full address into street address, city, state, zip, country in excel

This macro contains the functions Split() and IsNumeric(), it's all ...READ MORE

Jan 6, 2023 in Others by narikkadan
 • 63,600 points • 1,266 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
 • 63,600 points • 961 views
0 votes
1 answer

Calculate the rank based on the two or Three criteria

=LET(d, A4:C18, ...READ MORE

Jan 23, 2023 in Others by narikkadan
 • 63,600 points • 525 views
0 votes
0 answers

I have a problem hosting a project made in Next.js

I have Next.js project. When I connect ...READ MORE

Jan 27, 2023 in Others by Tejashwini
 • 3,820 points • 363 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
 • 63,600 points • 899 views
0 votes
1 answer

In =RTD(ProgID,Server,String1,[String2],...), passing array for String2, String3 and so on

Since WorksheetFunction.RTD() method (https://learn.microsoft.com/en-us/office/vba/api/excel.worksheetfunction.rtd) signature (i.e.: how many parameters it is ...READ MORE

Jan 23, 2023 in Others by narikkadan
 • 63,600 points • 506 views
0 votes
1 answer

Given a column of int64, make a REST call for each value, return results to a single table

It would be best if you read. ...READ MORE

Jan 21, 2023 in Others by narikkadan
 • 63,600 points • 588 views
0 votes
1 answer

How do I get it to select a single row based on the value?

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

Jan 20, 2023 in Others by narikkadan
 • 63,600 points • 630 views
0 votes
1 answer

Vlookup error when lookup value cell has been populated with formula

Your formula returns 4 characters. =LEFT(M8,FIND(" ",M8)-1) will return ...READ MORE

Jan 22, 2023 in Others by narikkadan
 • 63,600 points • 537 views
0 votes
1 answer

Laravel - Connection could not be established with host smtp.gmail.com [ #0]

While using the Laravel project directory, edit ...READ MORE

Feb 22, 2022 in Others by Aditya
 • 7,680 points • 14,940 views
0 votes
0 answers

Why is my console.log(persons.includes(newNameObject)) returning as false, when newNameObject already exists in the array?

I am working on a simple react ...READ MORE

Jan 27, 2023 in Others by Tejashwini
 • 3,820 points • 339 views
0 votes
1 answer

VBA, Loop through sheets not detecting parameters?

Rewriting to prevent in addition to removing ...READ MORE

Jan 24, 2023 in Others by narikkadan
 • 63,600 points • 444 views
0 votes
1 answer

VBA copy data from other file - problem with file name change

To look for the source file, use ...READ MORE

Jan 20, 2023 in Others by narikkadan
 • 63,600 points • 619 views
0 votes
1 answer

VBA code to take some string components, search them inside a workbook and replace the components with the cell addresses found

First, look up all ABC_* values in ...READ MORE

Jan 22, 2023 in Others by narikkadan
 • 63,600 points • 513 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
 • 63,600 points • 937 views
0 votes
1 answer

VBA Code Help - Need to add a line for each missing date and copy data from cells below

All you have to do is copy ...READ MORE

Jan 20, 2023 in Others by narikkadan
 • 63,600 points • 589 views
0 votes
1 answer

How to extract text before the last "," in excel formula?

Using FILTERXML() • Formula used in cell B1 =FILTERXML("<m><b>"&SUBSTITUTE(A1,", ","</b><b>")&"</b></m>","//b[last()-1]") You can ...READ MORE

Jan 20, 2023 in Others by narikkadan
 • 63,600 points • 577 views
0 votes
1 answer

Multiple Select Case Statements in a Single Procedure

Here's a slightly different structuring that will ...READ MORE

Jan 24, 2023 in Others by narikkadan
 • 63,600 points • 396 views
0 votes
1 answer

Macro that deletes all asterisk signs from cells

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

Jan 22, 2023 in Others by narikkadan
 • 63,600 points • 479 views
0 votes
1 answer

EXCEL: Auto number rows until value in cell

You can utilize SEQUENCE if you have ...READ MORE

Jan 20, 2023 in Others by narikkadan
 • 63,600 points • 567 views
0 votes
0 answers

VBA Excel MID Function Array

In order to calculate a UPC Check ...READ MORE

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

Read .xls file with Python pandas read_excel not working, says it is a .xlsb file

Try: import openpyxl xls = pd.ExcelFile('data.xls', engine='openpyxl') df = pd.read_excel(xls) Recently, ...READ MORE

Dec 17, 2022 in Others by narikkadan
 • 63,600 points • 2,032 views
0 votes
1 answer

Calculate 3 days back but skipping weekends

For Office 365, assuming the Date and Project A ranges are A2:A12 and C2:C12 respectively: =LET( ...READ MORE

Jan 23, 2023 in Others by narikkadan
 • 63,600 points • 419 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
 • 63,600 points • 888 views
0 votes
1 answer

Comparing data in Excel

A quick and mildly dirty VBA approach. ...READ MORE

Jan 20, 2023 in Others by narikkadan
 • 63,600 points • 536 views
0 votes
1 answer

Why is a Variant parameter changing its type on function call

Remove parentheses If SaveSettings Then SaveFormSettings FormReferen This will ...READ MORE

Jan 22, 2023 in Others by narikkadan
 • 63,600 points • 446 views
0 votes
1 answer

Ms-access vba - read from excel and also update that excel

Here is the code that works without ...READ MORE

Dec 28, 2022 in Others by narikkadan
 • 63,600 points • 1,512 views
0 votes
1 answer

Excel, AVERAGEIFS, Date discrepancy

When defining a range, you are unable ...READ MORE

Jan 22, 2023 in Others by narikkadan
 • 63,600 points • 428 views
0 votes
1 answer

PMT function in Javascript

Try the following settings to better understand ...READ MORE

Dec 13, 2022 in Others by narikkadan
 • 63,600 points • 2,158 views
0 votes
1 answer

How can I preserve the format while exporting data from excel to evernote

The contents for an Evernote note are ...READ MORE

Jan 5, 2023 in Others by narikkadan
 • 63,600 points • 1,151 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
 • 63,600 points • 932 views
0 votes
1 answer

Excel 365 Formulas - How to save LAMBDA function permanently (for all existing and new files)?

Try creating a template for excel to ...READ MORE

Jan 5, 2023 in Others by narikkadan
 • 63,600 points • 1,145 views
0 votes
1 answer

Excel convert multiple columns to dataset based on unique timestamp

F2 =UNIQUE($B$2:$B$20) G2 =FILTER($C$2:$C$20;($B$2:$B$20=$F2)*($A ...READ MORE

Jan 17, 2023 in Others by narikkadan
 • 63,600 points • 606 views
0 votes
1 answer

How can a column be set to display multiple spaces and tabs (white space) in a cell?

By entering your "code" in Word and ...READ MORE

Jan 19, 2023 in Others by narikkadan
 • 63,600 points • 512 views
0 votes
1 answer

Excel: Formula for compound interest for monthly deposits where deposits increase every year

It's possible that I don't understand how ...READ MORE

Nov 26, 2022 in Others by narikkadan
 • 63,600 points • 2,839 views
0 votes
1 answer

WAMP error: Forbidden You don't have permission to access /phpmyadmin/ on this server

Change the file content of c:\wamp\alias\phpmyadmin.conf to ...READ MORE

Feb 23, 2022 in Others by Aditya
 • 7,680 points • 14,734 views
0 votes
1 answer

FilterOn and DynamicCriteria allowed values for MS Graph Excel Filter Criteria

The filtering criteria applied to a column ...READ MORE

Jan 8, 2023 in Others by narikkadan
 • 63,600 points • 975 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.