Trending questions in Others

0 votes
1 answer

What does "collect2: error: ld returned 1 exit status" mean?

 The ld returned 1 exit status error ...READ MORE

Feb 22, 2022 in Others by Aditya
 • 7,660 points • 33,111 views
0 votes
1 answer

manifest merger failed with multiple errors, see logs

The initial process would be to open ...READ MORE

Feb 8, 2022 in Others by Soham
 • 9,700 points • 19,771 views
0 votes
1 answer

Web API Error - This request has been blocked; the content must be served over HTTPS

 If your web app is being hosted ...READ MORE

Feb 16, 2022 in Others by Aditya
 • 7,660 points • 17,735 views
0 votes
1 answer

Rename package in Android Studio

In Android Studio, you can do this: ...READ MORE

Feb 23, 2022 in Others by Aditya
 • 7,660 points • 16,670 views
0 votes
1 answer

How do I use the Indirect Function in Excel VBA to incorporate the equations in a VBA Macro Function

Try this: Sub Test() Dim str As String: str ...READ MORE

1 day ago in Others by narikkadan
 • 48,200 points • 20 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

1 day ago in Others by narikkadan
 • 48,200 points • 17 views
0 votes
1 answer

Excel If duplicate agree paste the value

With Office 365: =LET( nm,A2:A5, ...READ MORE

1 day ago in Others by narikkadan
 • 48,200 points • 13 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

1 day ago in Others by narikkadan
 • 48,200 points • 13 views
0 votes
1 answer

How to make a auto counter to print pages

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

1 day ago in Others by narikkadan
 • 48,200 points • 13 views
0 votes
0 answers

VBA Export as PDF and Save to Location with name as per a Cell in the worksheet

It will save under the name I ...READ MORE

15 hours ago in Others by Kithuzzz
 • 26,220 points • 12 views
0 votes
0 answers

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

In order to make an excel worksheet ...READ MORE

15 hours ago in Others by Kithuzzz
 • 26,220 points • 11 views
0 votes
1 answer

Formula to remove every middle name in a cell in Excel

Use this: =IFERROR(LEFT(A1,FIND(" ",A1)-1),A1) What does it do? Finds the ...READ MORE

1 day ago in Others by narikkadan
 • 48,200 points • 9 views
0 votes
1 answer

VBA Help on Splitting Worksheet

In this bit of code: ws1.Range("a:a").Copy Range("a:a") Intersect(.UsedRange, .Columns(i)).Copy ...READ MORE

1 day ago in Others by narikkadan
 • 48,200 points • 9 views
0 votes
1 answer

Excel VBA search based on cell values into folders and sub-folders to get the file path and data

This will create a listing of all ...READ MORE

1 day ago in Others by narikkadan
 • 48,200 points • 9 views
0 votes
0 answers

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

I have something that will automatically produce ...READ MORE

15 hours ago in Others by Kithuzzz
 • 26,220 points • 9 views
0 votes
1 answer

Underlining Headers from WPF Datagrid when printing using Excel print function

Try this: worksheet.Cells[1, i] = dgCountyEOY.Columns[i - 1].Header; ...READ MORE

1 day ago in Others by narikkadan
 • 48,200 points • 8 views
0 votes
0 answers

Comparing data in Excel

I have exported CSV files from a ...READ MORE

15 hours ago in Others by Kithuzzz
 • 26,220 points • 7 views
0 votes
0 answers

EXCEL: Auto number rows until value in cell

It's probably extremely simple, but I'm having ...READ MORE

15 hours ago in Others by Kithuzzz
 • 26,220 points • 7 views
0 votes
0 answers

Blazor - ClosedXml - excel cannot open the file beacause the file format or extension is not valid

I'm attempting to export some information from ...READ MORE

15 hours ago in Others by Kithuzzz
 • 26,220 points • 7 views
0 votes
0 answers

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

I'm working on a method to extract ...READ MORE

16 hours ago in Others by Kithuzzz
 • 26,220 points • 4 views
0 votes
0 answers

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

I'm using the code below to copy ...READ MORE

16 hours ago in Others by Kithuzzz
 • 26,220 points • 4 views
0 votes
0 answers

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

I want the new line to transfer ...READ MORE

16 hours ago in Others by Kithuzzz
 • 26,220 points • 4 views
0 votes
0 answers

Using VBA Workbook_SheetChange only works in one direction

I'm attempting to use Excel's Workbook SheetChange ...READ MORE

16 hours ago in Others by Kithuzzz
 • 26,220 points • 4 views
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

3 days ago in Others by narikkadan
 • 48,200 points • 34 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

3 days ago in Others by narikkadan
 • 48,200 points • 29 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

3 days ago in Others by narikkadan
 • 48,200 points • 25 views
0 votes
1 answer

Consolidate orders to single row counting number of orders and averaging the result

Try this: Sub aveCount() Dim rng As Range Dim cl ...READ MORE

3 days ago in Others by narikkadan
 • 48,200 points • 22 views
0 votes
1 answer

Find and adjacent cell with criteria

Using FILTER() & MAXIFS() • Formula used in cell F2 =FILTER($A$2:$D$12,(MAXIFS(D2:D12,B2:B12,2,C2:C12,4)=D2:D12)*(B2:B12=2)*(C2:C12=4)) Another alternative is ...READ MORE

3 days ago in Others by narikkadan
 • 48,200 points • 21 views
0 votes
1 answer

Conditions in Excel: skip cells with dates without a year

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

3 days ago in Others by narikkadan
 • 48,200 points • 19 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

3 days ago in Others by narikkadan
 • 48,200 points • 19 views
0 votes
1 answer

Insert formula in multiple excel sheets

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

3 days ago in Others by narikkadan
 • 48,200 points • 18 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

3 days ago in Others by narikkadan
 • 48,200 points • 17 views
0 votes
1 answer

Modifying CSV files from a local folder-VBA

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

3 days ago in Others by narikkadan
 • 48,200 points • 14 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

5 days ago in Others by narikkadan
 • 48,200 points • 19 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

5 days ago in Others by narikkadan
 • 48,200 points • 48 views
0 votes
1 answer

I Get "object required" error when using getElementByID

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

5 days ago in Others by narikkadan
 • 48,200 points • 34 views
0 votes
1 answer

Is there a hierarchy inferring algorithm available in python?

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

5 days ago in Others by narikkadan
 • 48,200 points • 31 views
0 votes
1 answer

How to set formula in Excel with POI?

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

5 days ago in Others by narikkadan
 • 48,200 points • 31 views
0 votes
1 answer

Count the sum of difference between two cells

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

5 days ago in Others by narikkadan
 • 48,200 points • 25 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

5 days ago in Others by narikkadan
 • 48,200 points • 21 views
0 votes
1 answer

Horizontal Loop

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

5 days ago in Others by narikkadan
 • 48,200 points • 20 views
0 votes
1 answer

Error populating email body from word documents

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

5 days ago in Others by narikkadan
 • 48,200 points • 17 views
0 votes
2 answers

'flutter' is not recognized as an internal or external command, operable program or batch file.

You have to Add flutter sdk path ...READ MORE

Aug 2, 2020 in Others by c49
 • 38,977 views
0 votes
1 answer

VBA Insert row instead of copy

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

6 days ago in Others by narikkadan
 • 48,200 points • 28 views
0 votes
1 answer

Excel VBA move pivot item to last position

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

6 days ago in Others by narikkadan
 • 48,200 points • 25 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

6 days ago in Others by narikkadan
 • 48,200 points • 24 views
0 votes
1 answer

Paste a value from a drop-down list

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

6 days ago in Others by narikkadan
 • 48,200 points • 22 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

6 days ago in Others by narikkadan
 • 48,200 points • 22 views
0 votes
1 answer

Excel - External link to multiple workbooks

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

6 days ago in Others by narikkadan
 • 48,200 points • 21 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

6 days ago in Others by narikkadan
 • 48,200 points • 17 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.