Trending questions in Others

0 votes
1 answer

Is there an excel function to tell if a cell has a dependency?

I think there is no built-in function ...READ MORE

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

Multiple columns of excel only shown as 1 column

Data is separated into CSV (Comma Separated ...READ MORE

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

How to gentrate Unique Id in ReactJs

You can use useId to create a ...READ MORE

Feb 8, 2023 in Others by Damonlang
 • 1,230 points • 407 views
0 votes
1 answer

How to show a row in excel if there is a X

FILTER Function: "filters" a range of data ...READ MORE

Feb 2, 2023 in Others by narikkadan
 • 63,600 points • 429 views
0 votes
1 answer

Copy the time to the next row of another column

Try this: Sub CopyCurrentTime() Dim currentRow As Integer currentRow = ...READ MORE

Jan 30, 2023 in Others by narikkadan
 • 63,600 points • 555 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
 • 63,600 points • 1,285 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,546 views
0 votes
1 answer

SSIS Excel Connection Manager failed to Connect to the Source

It seems like the 32-bit version of ...READ MORE

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

Excel formula to calculate MIN in table filtered

Try this: =SUBTOTAL(105;B2:B7) READ MORE

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

Divide a range of values for each unique value

With the next available row as the ...READ MORE

Feb 2, 2023 in Others by narikkadan
 • 63,600 points • 386 views
0 votes
1 answer

How can I find and replace text in Word using Excel VBA?

Try this code Option Explicit Const wdReplaceAll = 2 Sub ...READ MORE

Oct 15, 2022 in Others by narikkadan
 • 63,600 points • 5,131 views
0 votes
1 answer

2D rotation of an object along a custom axis

Use this: Option Explicit Type ObjLocData ...READ MORE

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

Extracting info from hyperlink

This will offer you an example of ...READ MORE

Feb 2, 2023 in Others by narikkadan
 • 63,600 points • 363 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
 • 63,600 points • 1,226 views
0 votes
1 answer

How to convert an XML file to an Excel file?

Create a CSV file that is in ...READ MORE

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

How do I create an Excel (.XLS and .XLSX) file in C# without installing Microsoft Office?

You can use OLEDB to create and ...READ MORE

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

How do I show the computations after S/N 1048576 in a separate sheet

Add: If xRg.Row = xRg.Parent.Rows.Count Then ...READ MORE

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

How to convert pdf file to excel file using python

Just specify your whole output path instead ...READ MORE

Nov 4, 2022 in Others by narikkadan
 • 63,600 points • 4,232 views
0 votes
1 answer

Pivoting 4x4 into 16x1

Try this: df <- tibble::tribble( ~ID, ~sit1, ...READ MORE

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

Sum the total of a column in excel and paste the sum to a different workbook

Get Column Sum From Closed Workbook Option Explicit Sub ...READ MORE

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

Want to create a chronological row # then reset based on font color

Use this function to test the font ...READ MORE

Feb 2, 2023 in Others by narikkadan
 • 63,600 points • 312 views
0 votes
1 answer

How to link two excel sheet in same excel file

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

Jan 29, 2023 in Others by narikkadan
 • 63,600 points • 483 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 • 38,088 views
0 votes
1 answer

Automatically adding the date/time to a cell when another cell is updated AND clearing it when this cell is empty

You are looking for an IsEmpty check in your ...READ MORE

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

My VBA macro slows down dramatically with each use

You have a function called ExportRange that ...READ MORE

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

How to expend the code to transfer data from one spreadsheet to another based on multiple criteria

 The progress bar is unnecessary. Option Explicit Sub VTest2() ...READ MORE

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

When a row is added to one sheet, automatically add a row to another sheet

Use the VLOOKUP function. Your Spreadsheet 2's first column will ...READ MORE

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

VBA How To Paste With Blank One Column Over?

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

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

Iterate thru specific controls in a form using a loop

The textbox numbers you want to iterate ...READ MORE

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

Public variable for captura path in vba excel

An assignment statement (as ruta = ActiveWorkbook) ...READ MORE

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

Excel VBA: Trying to read all files in folder based on cell input and output to another cell

Your array has no capacity for data ...READ MORE

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

How to print the next row every time a function runs? (openpyxl)

Verify the indentation. I executed the sample ...READ MORE

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

Can not get bubble sort to run in excel's developer mode

Bubble Sort a Single-Column Range A Quick Fix Option ...READ MORE

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

How do I find top row visible on Sheet in Excel

Try this: ? Activewindow.VisibleRange.Row READ MORE

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

Conditional Formating in Excel comparing dates between cells

To get a date from your strings, ...READ MORE

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

How can I perform a reverse string search in Excel without using VBA?

This one is tested and does work ...READ MORE

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

How to do multiple transpose in excel vba

Use Dictionary object Sub test2() With New ...READ MORE

Jan 22, 2023 in Others by narikkadan
 • 63,600 points • 697 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,600 points • 1,818 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

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

VBA Change Cell colors based on value, and it can deal with single cell and multiple cells changes

Before looping through all of the cells ...READ MORE

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

Get inserted image to adjust the row height in Excel

Try this: 'just find Photo1 cell and select ...READ MORE

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

Apache POI Excel row color is only black and doesn't change

Use this: style.setFillPattern(CellStyle.SOLID_FOREGROUND); In combination with: style.setFillForegroundColor(IndexedColors.AQUA.getIndex()); Sets the background color ...READ MORE

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

Microsoft Open XML Read Excel file using SAX method row by row and finding cell data

I faced a comparable challenge. A bespoke ...READ MORE

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

Excel formula returning multiple values according to two criterias

Unique Column Cells With Two-Column Duplicates =LET(rCol,F2:F16,uCol1,G2:G16,uCol2,H2:H16, ...READ MORE

Jan 26, 2023 in Others by narikkadan
 • 63,600 points • 486 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,600 points • 3,723 views
0 votes
1 answer

Changing code to adjust number of charts on each powerpoint slide VBA

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

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