Trending questions in Others

0 votes
1 answer

Why is my code grabbing row number from the wrong Excel sheet?

I changed this: iTotalRows = source.Worksheets("Export").Range("B1:B" & Cells(Rows.Count, ...READ MORE

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

Textjoin with adjacent headers and rows with a twist

Try the following formula- =TEXTJOIN(" ",1,FILTER($A$1:$C$1,A2:C2<>"")&":"&FILTER(A2:C2,A2:C2<>"")) To make it ...READ MORE

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

Numbering/sequencing sets of same column values

You can accomplish this with countif and a sliding ...READ MORE

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

How to convert data from txt files to Excel files using python

Hi , there are few steps to ...READ MORE

Feb 16, 2022 in Others by Edureka
 • 13,690 points • 15,323 views
0 votes
1 answer

Adding column to Excel using Apache POI

The quickest way to add a column ...READ MORE

Nov 19, 2022 in Others by narikkadan
 • 86,360 points • 3,399 views
0 votes
1 answer

Date format conversion in Excel

You appear to be misunderstanding the point: ...READ MORE

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

Excel Consolidate Data not working - Data does not merge

This is so that letters cannot be ...READ MORE

Nov 17, 2022 in Others by narikkadan
 • 86,360 points • 3,444 views
0 votes
1 answer

Excel:- Comparing 2 columns and then copying value in 3rd column

There is an excel if() function for ...READ MORE

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

Dynamic chart range using INDIRECT: That function is not valid (despite range highlighted)

Similar to Sean's fantastic response, mine also ...READ MORE

Dec 27, 2022 in Others by narikkadan
 • 86,360 points • 1,749 views
0 votes
1 answer

Excel: How to analyze data in a table that contains multivalue cells

 The below formula will create a unique ...READ MORE

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

Excel Formula multiple Index Match and Average the result

If the conditions are separate and unrelated, ...READ MORE

Oct 31, 2022 in Others by narikkadan
 • 86,360 points • 4,198 views
0 votes
1 answer

How do I merge multiple excel files to a single excel file

You copy a worksheet from before each ...READ MORE

Dec 24, 2022 in Others by narikkadan
 • 86,360 points • 1,839 views
0 votes
1 answer

How can I measure time more precisely in VBA?

At the top of the script you ...READ MORE

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

How to make lambda function working on excel365?

Use this: =BYROW(SEQUENCE(5),LAMBDA(b,TEXTJOIN(",",,SEQUENCE(1,5,b)))) The second sequence is changed from ...READ MORE

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

Mat-icon doesn't export in excel sheet?

Icons have their own coding you can ...READ MORE

Dec 15, 2022 in Others by narikkadan
 • 86,360 points • 2,217 views
0 votes
1 answer

Transform Excel table columns (not all) into rows - long to wide transformation

In PQ, highlight the Group column and ...READ MORE

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

How to validate values entered in a multiline Excel cell?

Try: The formula in B1: =AND(BYROW(TEXTSPLIT(A1," "," ",1),LAMBDA(x,SUM((LEN(x)={3,7,4,4,5})ISNUMBER(-x)(MID(TAKE(x,-1),3,1)="."))))) Or, write a ...READ MORE

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

How to turn a string formula into a "real" formula?

Evaluate might suit: Function Eval(Ref As String) ...READ MORE

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

Need help to delete rows in VBA

Here is a basic macro that deletes ...READ MORE

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

Copy last 3 rows, excluding the rows for which there is a "0" in column "C"

The copy inside the loop is overwriting ...READ MORE

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

Filter/Extract a text from excel sheet having similar values

ISNUMBER(SEARCH("Maria,",SUBSTITUTE(A1:A4,"]",",")))  shows TRUE if Maria is found and false if it would ...READ MORE

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

Excel VSTO - cm/inches to point conversion not accurate

You may convert centimetres to points in ...READ MORE

Oct 31, 2022 in Others by narikkadan
 • 86,360 points • 4,109 views
0 votes
1 answer

Highlight active row/column in Excel without using VBA?

Create two formula-based rules: =ROW()=CELL("row") =COLUMN( ...READ MORE

Oct 27, 2022 in Others by narikkadan
 • 86,360 points • 4,273 views
0 votes
1 answer

How to automate split by delimiter in Excel (equivalent of =SPLIT in gSheets)

Multiple ways, one is to use FILTERXML():   Formula in B2: =TRANSPOSE(FILTERXML("<t><s>"&SUBSTITUTE(A2," ...READ MORE

Dec 29, 2022 in Others by narikkadan
 • 86,360 points • 1,567 views
0 votes
1 answer

ASP.NET generated excel file has different format than extension

You must include the xlsx file extension. The ...READ MORE

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

MS Excel TRUE/FALSE Formula Not Returning Expected Result

The reason for this is that the 'words' ...READ MORE

Nov 8, 2022 in Others by gaurav
 • 23,580 points • 3,744 views
0 votes
1 answer

Trying to apply Solver with Macros

The  MaxMinVal was when you wanted to ...READ MORE

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

Broken external links in Excel : a leading "file:///" scheme appended to paths can't be evaluated in formulas

If not already done, save and close ...READ MORE

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

Excel: Group rows and add minimum and maximum from two different columns within the group

You can accomplish your goal with Power ...READ MORE

Dec 19, 2022 in Others by narikkadan
 • 86,360 points • 1,919 views
0 votes
1 answer

Excel Formula: Count cells where value is date

Dates in Excel are just formatted numbers, ...READ MORE

Dec 11, 2022 in Others by narikkadan
 • 86,360 points • 2,299 views
0 votes
1 answer

Map-like array function in Excel?

In Excel-365 you can directly use ABS() function with array of ...READ MORE

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

Weird Date change when copying a Worksheet into a new workbook

Try  this: Dim wb ...READ MORE

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

In excel 365 how to subtract values sequentially but skip empty cells

Try the following formula in C4 and ...READ MORE

Dec 24, 2022 in Others by narikkadan
 • 86,360 points • 1,722 views
0 votes
1 answer

Get random value in the range of plus/minus 10% of a cell value in Excel

Why not just use RANDBETWEEN(B2*0.9, B2*1.1) if ...READ MORE

Dec 25, 2022 in Others by narikkadan
 • 86,360 points • 1,678 views
0 votes
1 answer

Make certain characters in an Excel cell subscript Python

With Xlwings, you may accomplish this by ...READ MORE

Dec 13, 2022 in Others by narikkadan
 • 86,360 points • 2,194 views
0 votes
1 answer

Excel plot time series frequency with continuous xaxis

Excel has a few oddities that must ...READ MORE

Nov 7, 2022 in Others by narikkadan
 • 86,360 points • 3,749 views
0 votes
1 answer

How to subtract date only format "mm/dd" in excel?

I suppose Excel has handled December 21 ...READ MORE

Dec 25, 2022 in Others by narikkadan
 • 86,360 points • 1,674 views
0 votes
1 answer

Want to merge two column that contains mobile number into one based on the condition that mobile no should be 10 digits

In Excel 2013 this formula can be ...READ MORE

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

DYNAMIC EXCEL REPORT - Make Excel Formula automatically add itself when new rows added

This is your formula: =COUNTIF(Sheet1!$A$2:$B$15,Sheet2!B1) Chan ...READ MORE

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

How can find location of value in a square using excel

For the cell address: =LET(ζ,B4:F11,BASE(MIN(IF(ζ=M ...READ MORE

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

Excel VBA - Using Error Traps where Another Routine is Called

Macro1 is illegible as syntax. After the ...READ MORE

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

Excel countif entire row in a table

Try this: =COUNTIF(B:B,"my citeria") so if your Column ...READ MORE

Dec 25, 2022 in Others by narikkadan
 • 86,360 points • 1,643 views
0 votes
1 answer

Insert picture into Excel cell

You can add the image into a ...READ MORE

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

A value which should be judged by a scale gets bad judgement sometimes

Only the period (.) is accepted by ...READ MORE

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

Stop Excel from automatically converting certain text values to dates

I've discovered that getting the desired result ...READ MORE

Dec 29, 2022 in Others by narikkadan
 • 86,360 points • 1,468 views
0 votes
1 answer

SQL query to select dates between two dates

you should put those two dates between ...READ MORE

Nov 7, 2022 in Others by gaurav
 • 23,580 points • 3,706 views
0 votes
1 answer

Exporting HTML Table to Excel Extension Issues

In my application, I'm experiencing a similar ...READ MORE

Nov 14, 2022 in Others by narikkadan
 • 86,360 points • 3,358 views
0 votes
1 answer

Excel to CSV with UTF8 encoding

Use of Google Spreadsheet is a straightforward ...READ MORE

Dec 23, 2022 in Others by narikkadan
 • 86,360 points • 1,678 views
0 votes
1 answer

How to get password of the Amazon aws rds user?

Follow these procedures to update the master ...READ MORE

Mar 9, 2022 in Others by gaurav
 • 23,580 points
edited Jun 20, 2023 by Khan Sarfaraz • 14,155 views
0 votes
1 answer

Python Excel Writer (xlswriter) Insert Image from URL

Use this: url = "..../picture.jpg" data = urllib.request.urlopen(url).read() file = ...READ MORE

Nov 17, 2022 in Others by narikkadan
 • 86,360 points • 3,185 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.