Trending questions in Others

0 votes
1 answer

Find function to locate result of a formula, in a cell

There are several attributes to the Find ...READ MORE

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

Excel formula: Correct syntax of SUM with ROW?

A few explanations of why your formula ...READ MORE

Nov 10, 2022 in Others by narikkadan
 • 86,360 points • 1,405 views
0 votes
1 answer

Add some word to all or some rows in Excel?

Solution: Select All cells that want to change. Right ...READ MORE

Nov 11, 2022 in Others by narikkadan
 • 86,360 points • 1,363 views
0 votes
1 answer

SQL - The conversion of a varchar data type to a datetime data type resulted in an out-of-range value

 I ran into the same problem due ...READ MORE

Feb 23, 2022 in Others by Aditya
 • 7,680 points • 12,610 views
0 votes
1 answer

Excel formula to check date within this week and last week

Assuming the first date in A2 try this formula ...READ MORE

Sep 29, 2022 in Others by narikkadan
 • 86,360 points • 3,268 views
0 votes
1 answer

Logical calculation in Excel

Excel logical functions - overview. Microsoft Excel ...READ MORE

Nov 8, 2022 in Others by gaurav
 • 24,280 points • 1,472 views
0 votes
1 answer

Excel does not show hidden sheet but if i unzip it, then there are 2 worksheets

I now know that an Excel worksheet ...READ MORE

Nov 12, 2022 in Others by narikkadan
 • 86,360 points • 1,302 views
0 votes
1 answer

Excel get percentage of difference between numbers?

Find the percentage of change between two ...READ MORE

Nov 8, 2022 in Others by gaurav
 • 24,280 points • 1,469 views
0 votes
1 answer

Transposing columns to rows in Excel

Don't know solution but, I am in ...READ MORE

Nov 2, 2022 in Others by Mantas
edited Mar 5, 2025 • 2,388 views
0 votes
1 answer

XLOOKUP Formula Issue Horizontal & vertical lookup

Actually, your ranges are wrong. To correct ...READ MORE

Nov 5, 2022 in Others by narikkadan
 • 86,360 points • 1,583 views
0 votes
1 answer

Repeated excel rows based on a cell with multiple values

You can use this query: let ...READ MORE

Oct 20, 2022 in Others by narikkadan
 • 86,360 points • 2,274 views
0 votes
1 answer

=CONCATENATE() function giving a #VALUE! error (EXCEL 2013)

You can use the following: =A1&","&B1 TEXTJOIN would also ...READ MORE

Nov 12, 2022 in Others by narikkadan
 • 86,360 points • 1,276 views
0 votes
1 answer

Converting .pdf files to excel (.xls)

It is not always possible and typically ...READ MORE

Oct 30, 2022 in Others by narikkadan
 • 86,360 points • 1,834 views
0 votes
1 answer

Excel formula for Euclidean distance

Euclidean Norm of a vector of size ...READ MORE

Oct 9, 2022 in Others by narikkadan
 • 86,360 points • 2,741 views
0 votes
1 answer

Find occurrence count of a number in Excel

First split those integer values into their ...READ MORE

Oct 30, 2022 in Others by narikkadan
 • 86,360 points • 1,825 views
0 votes
1 answer

Converting all tabs of excel sheet to PDF

Using VBA, try it like this, for ...READ MORE

Sep 26, 2022 in Others by narikkadan
 • 86,360 points • 3,316 views
0 votes
1 answer

How to open a huge excel file efficiently

A good example is using PIA's/Interop or ...READ MORE

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

How to programmatically distinguish Excel 2019 from 2016?

Using the output of the MS Office ...READ MORE

Nov 11, 2022 in Others by narikkadan
 • 86,360 points • 1,297 views
0 votes
1 answer

Obtaining Excel worksheet reference by worksheet name via C#

Instead of using Excel.Workbook.Sheets collection, it's easier to access Excel.Workbook.Worksheet collection, ...READ MORE

Nov 10, 2022 in Others by narikkadan
 • 86,360 points • 1,332 views
0 votes
1 answer

Multiple find and replace in MS Word from a list in MS Excel

If I understand you correctly, you want ...READ MORE

Oct 28, 2022 in Others by narikkadan
 • 86,360 points • 1,890 views
0 votes
1 answer

Is there a way to hide excel formula using Apache POI

In Excel, hiding formulae is a feature ...READ MORE

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

How to use VLOOKUP function in MS Excel

Here is the formula for cell G2: ...READ MORE

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

Create Excel file and save as PDF.

Office 2013 still has the Interop library and ...READ MORE

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

Excel formula to average selected cells based on certain criteria

Try: =AVERAGE(IF(X:X=A1,Z:Z)) With Ctrl+Shift+Enter. READ MORE

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

How to calculate percentage of an autosum field in excel

The fact that I was using the ...READ MORE

Nov 11, 2022 in Others by narikkadan
 • 86,360 points • 1,271 views
0 votes
1 answer

Excel to IBM DB2 Connection

Try using the IBM DB2 for I ...READ MORE

Sep 29, 2022 in Others by narikkadan
 • 86,360 points • 3,165 views
0 votes
1 answer

Convert text to number in Google Sheets & Excel

Try: =INDEX(IF(REGEXMATCH(A1:A4&""; "M"); REGEXEXTRACT(A1:A4; "\d+.\d+|\d+")*1000000; IF(REGEXMATCH(A1:A4&""; "k"); ...READ MORE

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

Is there a reason why these bars wont line up in my excel chart?

STEPS Hover your mouse over any of the ...READ MORE

Nov 8, 2022 in Others by narikkadan
 • 86,360 points • 1,367 views
0 votes
1 answer

Excel sumif function with conditions

Try SUMIFS. =sumifs(table1[sum time (sec)],Table1[type],1, Table1[Date],K3, Table1[Time],K4, Table1[Sum Time ...READ MORE

Nov 11, 2022 in Others by narikkadan
 • 86,360 points • 1,239 views
0 votes
1 answer

Copy the Excel RANK formula without changing the end reference

Placing $ before the cell references makes ...READ MORE

Nov 8, 2022 in Others by gaurav
 • 24,280 points • 1,354 views
0 votes
1 answer

(Excel) Data Entry Form inputting data into table

Solution  Fill in all the fields in your ...READ MORE

Oct 15, 2022 in Others by narikkadan
 • 86,360 points • 2,395 views
0 votes
0 answers

PHP Read Online Excel File Without Download The File

I am creating web stock apps. I ...READ MORE

Nov 2, 2022 in Others by Kithuzzz
 • 38,000 points • 1,612 views
0 votes
1 answer

Displaying a portion of a table in a separate worksheet

If you are using Excel 2013 or ...READ MORE

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

Find duplicates in a column

If any cells in column "F" contain ...READ MORE

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

Excel chart a line per category

Pivot charts, in my opinion, are the ...READ MORE

Nov 15, 2022 in Others by narikkadan
 • 86,360 points • 1,012 views
0 votes
1 answer

What is the application name of Microsoft Excel?

The name and path of Excel can ...READ MORE

Nov 5, 2022 in Others by narikkadan
 • 86,360 points • 1,436 views
0 votes
0 answers

Format an Excel column (or cell) as Text in C#?

When I copy values from a data ...READ MORE

Oct 31, 2022 in Others by Kithuzzz
 • 38,000 points • 1,661 views
0 votes
1 answer

Excel Formula Meaning of $

It's an absolute reference: it means don't treat ...READ MORE

Nov 5, 2022 in Others by narikkadan
 • 86,360 points • 1,417 views
0 votes
1 answer

Password Protecting an Excel file in C#

Try this: using Microsoft.Office.Interop.Excel //create your spreadsheet here... WorkbookObject.Password = ...READ MORE

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

Excel VBA remove blank rows from specific range

I have tried to avoid .select  Option Explicit Sub CombineData() ...READ MORE

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

How to multiply by a percentage range in Excel

The following would yield an array from ...READ MORE

Nov 8, 2022 in Others by narikkadan
 • 86,360 points • 1,254 views
0 votes
1 answer

Correct use of transactions in SQL Server

A transaction in SQL Server is a sequential ...READ MORE

Nov 7, 2022 in Others by gaurav
 • 24,280 points • 1,329 views
0 votes
1 answer

Download file from URL in Excel 2019 (it works on Excel 2007)

The Sub Code looks fine. Check the ...READ MORE

Oct 7, 2022 in Others by narikkadan
 • 86,360 points • 2,631 views
0 votes
1 answer

How to use data validation and 'no filter' in excel

eventually succeeded in resolving this. Effectively, Filter() ...READ MORE

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

Codeigniter convert excel file to pdf

This is a basic php script for ...READ MORE

Sep 27, 2022 in Others by narikkadan
 • 86,360 points • 3,074 views
0 votes
1 answer

Avoiding index & match #N/A value

Use IFERROR to set an alternative value if the ...READ MORE

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

How to do Data driven testing in Selenium without excel file or Database

Try this: Yes you can , just give ...READ MORE

Oct 16, 2022 in Others by narikkadan
 • 86,360 points • 2,229 views
0 votes
1 answer

NodeJS Amazon AWS S3 getObject how to send file in API response to download

Server Side const aws = require('aws-sdk'); router.get('/getfilefroms3', async (req, ...READ MORE

Mar 24, 2022 in Others by gaurav
 • 24,280 points • 11,167 views
0 votes
1 answer

Are there any Linear Regression Function in SQL Server?

I know of none, to the best ...READ MORE

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

how to select a statistical range in an excel

The lowest 5% and top 5% will ...READ MORE

Nov 4, 2022 in Others by narikkadan
 • 86,360 points • 1,394 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.