Trending questions in Others

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 • 314 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,720 points • 464 views
0 votes
1 answer

Unable to download excel file from src/assets in development/qa/prod environment for angular application

Try this: this.HttpClient.get("./assets/sample.xlsx",{responseType: "blob"}).subscribe((res:any) => ...READ MORE

Nov 12, 2022 in Others by narikkadan
 • 63,720 points • 3,572 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 • 306 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,720 points • 494 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,720 points • 490 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,720 points • 402 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,720 points • 528 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,720 points • 786 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,720 points • 520 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,720 points • 564 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,720 points • 563 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,720 points • 864 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,720 points • 1,722 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,720 points • 1,159 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,720 points • 802 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,720 points • 407 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,720 points • 446 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,720 points • 352 views
0 votes
1 answer

Convert Excel's "41014" date to actual date in PHP or JavaScript

PHPExcel Date handling code: public static function ExcelToPHP($dateValue ...READ MORE

Oct 24, 2022 in Others by narikkadan
 • 63,720 points • 4,323 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,720 points • 389 views
0 votes
1 answer

Excel Connect data points with line is DISABLED

By replicating the data series and substituting ...READ MORE

Dec 27, 2022 in Others by narikkadan
 • 63,720 points • 1,561 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 • 14,998 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,720 points • 509 views
0 votes
1 answer

How to clear TextField Entered Text automatically in Flutter?

Hi@akhtar, You can control the TextField in your ...READ MORE

Sep 10, 2020 in Others by MD
 • 95,460 points • 37,720 views
0 votes
1 answer

CodeIgniter: Unable to connect to your database server using the provided settings Error Message

 I'm assuming there is something wrong with ...READ MORE

Feb 16, 2022 in Others by Soham
 • 9,710 points • 15,074 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,720 points • 4,599 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,020 points • 353 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,720 points • 355 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,720 points • 482 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,720 points • 824 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,720 points • 820 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,720 points • 380 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,720 points • 723 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,720 points • 461 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,720 points • 459 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,720 points • 1,430 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,720 points • 1,066 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,720 points • 316 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,720 points • 434 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,720 points • 1,862 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,720 points • 302 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,720 points • 519 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,720 points • 809 views
0 votes
1 answer

Trying to run different macros based on value of cell in a range

This demonstrates one approach to loop through ...READ MORE

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

How to make a auto counter to print pages

This will loop through all of those ...READ MORE

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

How to access entire row by cell address or value in excel?

You may accomplish all of this by ...READ MORE

Dec 28, 2022 in Others by narikkadan
 • 63,720 points • 1,356 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,720 points • 1,006 views
0 votes
1 answer

How to sum the value of 2 rows with vlookup by only using 1 formula?

 Try in Excel Online: • Formula used in cell C3 =SUM(SCAN(0,M3:N3,LAMBDA(x,y,VLOOKUP(y,P3:Q12,2,0)))) Works ...READ MORE

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

How to add if this cell = 0 skip and go next

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

Jan 20, 2023 in Others by narikkadan
 • 63,720 points • 354 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.