Trending questions in Others

0 votes
1 answer

How to Clear Table Style in Office Scripts?

Excel tables on the web are constantly ...READ MORE

Dec 25, 2022 in Others by narikkadan
 • 86,360 points • 2,961 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 • 2,441 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,783 views
0 votes
0 answers

Calendar React JS

I have a homework to make a ...READ MORE

Jan 27, 2023 in Others by Tejashwini
 • 5,380 points • 1,543 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 • 2,431 views
0 votes
1 answer

Excel shortcut for month day year short date [closed]

What about Ctrl-1 + Tab + Tab + ...READ MORE

Jan 3, 2023 in Others by narikkadan
 • 86,360 points • 2,556 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 • 1,383 views
0 votes
1 answer

Excel cannot open the file because the file format or file extension is not valid - PHP Maatwebsite

Try this: if (ob_get_length() == 0 ) { ...READ MORE

Dec 19, 2022 in Others by narikkadan
 • 86,360 points • 3,158 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,725 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,417 views
0 votes
1 answer

How many sheets are there in Excel Workbook by default?

It is 3. As stated officially by ...READ MORE

Jan 7, 2023 in Others by narikkadan
 • 86,360 points • 2,363 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 • 1,149 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 • 1,228 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,745 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 • 1,307 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,939 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
 • 86,360 points • 2,073 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
 • 86,360 points • 1,715 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 • 1,367 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
 • 86,360 points • 1,739 views
0 votes
1 answer

Adding formulas to excel spreadsheet using python

You can create any formula that Excel ...READ MORE

Dec 17, 2022 in Others by narikkadan
 • 86,360 points • 3,203 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 • 1,164 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

Jan 17, 2023 in Others by narikkadan
 • 86,360 points • 1,854 views
0 votes
1 answer

How to return a result from a VBA function

You must associate the value with the ...READ MORE

Nov 4, 2022 in Others by narikkadan
 • 86,360 points • 5,052 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 • 1,242 views
0 votes
0 answers

SEO friendly url using php

I wanted to use php to make ...READ MORE

Feb 18, 2022 in Others by Kichu
 • 19,040 points • 1,909 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
 • 86,360 points • 1,971 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 • 1,144 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
 • 86,360 points • 2,352 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,616 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
 • 86,360 points • 1,960 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
 • 86,360 points • 1,598 views
0 votes
1 answer

Convert excel file to jpg in c#

You can use Aspose : http://www.aspose.com/community/files/51/.net-components/aspose.cells-for-.net/category1129.aspx For example : http://www.aspose.com/docs/display/cellsnet/Converting+Worksheet+to+Image Sample ...READ MORE

Dec 27, 2022 in Others by narikkadan
 • 86,360 points • 2,722 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
 • 86,360 points • 1,673 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
 • 86,360 points • 1,538 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 • 1,233 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
 • 86,360 points • 1,666 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 • 1,272 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
 • 86,360 points • 1,704 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
 • 86,360 points • 1,785 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
 • 86,360 points • 1,783 views
0 votes
1 answer

Calculating a Rolling IRR in Excel

I'm assuming a little bit here, but ...READ MORE

Jan 3, 2023 in Others by narikkadan
 • 86,360 points • 2,382 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
 • 86,360 points • 1,513 views
0 votes
1 answer

Copy formula from Excel to Notepad++

If you go to Formulas card, inside Formulas Auditing section there ...READ MORE

Dec 13, 2022 in Others by narikkadan
 • 86,360 points • 3,281 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
 • 86,360 points • 1,376 views
0 votes
1 answer

How to change two different date format into single date format in excel

With data in A2, in B2 enter: =IF(ISNUMBER(A2),A2,DATE(LEFT(A2,4),MID(A2,6,2),RIGHT(A2,2))) and apply your format ...READ MORE

Dec 24, 2022 in Others by narikkadan
 • 86,360 points • 2,802 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

Jan 17, 2023 in Others by narikkadan
 • 86,360 points • 1,763 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
 • 86,360 points • 1,453 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

Jan 17, 2023 in Others by narikkadan
 • 86,360 points • 1,750 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
 • 86,360 points • 1,614 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.