Trending questions in Others

0 votes
1 answer

Unable to load 'minutes' correctly from CSV into in Power Query / Pivot

Try this: #"Added Custom" = Table.AddColumn(#"PriorStepNameHere", "Hour", each ...READ MORE

Feb 3, 2023 in Others by narikkadan
 • 86,360 points • 931 views
0 votes
1 answer

Successive retrieval of defined ranges, by splitting thier names in a constant as well as a dynamic part

You can use a Select Case statement : Option Explicit Sub ...READ MORE

Feb 5, 2023 in Others by narikkadan
 • 86,360 points • 835 views
0 votes
1 answer

Is there a coalesce-like function in Excel?

To have Excel analyze the formula as ...READ MORE

Oct 21, 2022 in Others by narikkadan
 • 86,360 points • 5,461 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
 • 86,360 points • 2,259 views
0 votes
1 answer

Autofill macro to autofill dates up to 31 days regardless of the month

If you wish to utilise a single ...READ MORE

Feb 5, 2023 in Others by narikkadan
 • 86,360 points • 825 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 • 931 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
 • 86,360 points • 1,552 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
 • 86,360 points • 2,244 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 • 15,782 views
0 votes
1 answer

Find value in column where running total is equal to a certain percentage

VBA bubble sort - no changes to ...READ MORE

Feb 3, 2023 in Others by narikkadan
 • 86,360 points • 867 views
0 votes
1 answer

How do I set the default paste special in excel to paste only values

I paste the values with a keyboard ...READ MORE

Nov 6, 2022 in Others by narikkadan
 • 86,360 points • 4,703 views
0 votes
1 answer

Update an Excel sheet in real time using Python

Using xlwings, I have really discovered how ...READ MORE

Nov 13, 2022 in Others by narikkadan
 • 86,360 points • 4,404 views
0 votes
1 answer

Project ID printed for every task on the API problem

Try this: def teste(id): listID = ...READ MORE

Feb 2, 2023 in Others by narikkadan
 • 86,360 points • 891 views
0 votes
1 answer

VBA reordering columns from different workbook or sheet

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

Feb 4, 2023 in Others by narikkadan
 • 86,360 points • 800 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
 • 86,360 points • 1,056 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
 • 86,360 points • 965 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
 • 86,360 points • 1,998 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,554 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
 • 86,360 points • 988 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
 • 86,360 points • 3,793 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,625 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
 • 86,360 points • 2,016 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
 • 86,360 points • 1,146 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
 • 86,360 points • 1,144 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
 • 86,360 points • 826 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
 • 86,360 points • 819 views
0 votes
1 answer

Excel Define a range based on a cell value

Let's say that cells A1, A2, A3, ...READ MORE

Nov 8, 2022 in Others by narikkadan
 • 86,360 points • 4,531 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
 • 86,360 points • 945 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
 • 86,360 points • 1,289 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
 • 86,360 points • 1,329 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
 • 86,360 points • 1,321 views
0 votes
1 answer

Excel VBA Protect Sheet without Locking all cells

If the problem is the use of Clear then ...READ MORE

Dec 29, 2022 in Others by narikkadan
 • 86,360 points • 2,330 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
 • 86,360 points • 964 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
 • 86,360 points • 1,266 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
 • 86,360 points • 917 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
 • 86,360 points • 2,496 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
 • 86,360 points • 850 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
 • 86,360 points • 932 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
 • 86,360 points • 1,278 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
 • 86,360 points • 929 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,534 views
0 votes
1 answer

Excel - Separating text with numbers, text and brackets into separate cells

You can try FILTERXML(). READ MORE

Jan 6, 2023 in Others by narikkadan
 • 86,360 points • 1,923 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
 • 86,360 points • 1,179 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
 • 86,360 points • 1,955 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
 • 86,360 points • 1,907 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
 • 86,360 points • 1,212 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
 • 86,360 points • 906 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
 • 86,360 points • 720 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
 • 86,360 points • 1,108 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
 • 86,360 points • 710 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.