Trending questions in Others

0 votes
1 answer

Excel shared formula expansion

You can use Linq I would start ...READ MORE

Nov 7, 2022 in Others by narikkadan
 • 86,360 points • 1,252 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,119 views
0 votes
1 answer

How to merge two cells in excel with same field name

Insert 2 new columns, G & H. Enter ...READ MORE

Oct 7, 2022 in Others by narikkadan
 • 86,360 points • 2,581 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,067 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,489 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,065 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 • 975 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,059 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,085 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,342 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,080 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,287 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
 • 23,580 points • 1,153 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,153 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 • 974 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 • 2,934 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 • 839 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,484 views
0 votes
1 answer

How can I convert excel to PDF by Libreoffice and keep all format from excel file?

"Times New Roman" typeface does not have ...READ MORE

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

Excel formatting DD-MMM-YYYY, must be in this format

There is no special structure for months ...READ MORE

Oct 10, 2022 in Others by narikkadan
 • 86,360 points • 2,371 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,382 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,497 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,232 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,275 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,106 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 • 804 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,535 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,445 views
0 votes
1 answer

Excel remaining days count from today until due date minus weekends?

The problem is that you are not ...READ MORE

Nov 14, 2022 in Others by narikkadan
 • 86,360 points • 797 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,438 views
0 votes
0 answers

can u help me to check this code, maybe something is missing or something

//Sensor Ultrasonic #include <NewPing.h> #define TRIGGER_PIN  4  // Arduino ...READ MORE

Nov 26, 2022 in Others by Riki
edited Mar 4, 2025 • 283 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,083 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,085 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
 • 23,580 points • 1,117 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,213 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,247 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,207 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,028 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,717 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 • 2,850 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 • 2,776 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 • 1,995 views
0 votes
1 answer

Copy Text from Range in Excel into Word Document

To copy text from a range in ...READ MORE

Nov 6, 2022 in Others by narikkadan
 • 86,360 points • 1,064 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,357 views
0 votes
0 answers

Excel AutoComplete and AutoFill keyboard shortcut

Is there a keyboard shortcut for Excel ...READ MORE

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

How to use Excel VLOOKUP function with words that begin with the letters AB

For title naming, I have a list ...READ MORE

Nov 24, 2022 in Others by Kithuzzz
 • 38,000 points
edited Mar 4, 2025 • 310 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,078 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,066 views
0 votes
0 answers

Unable to add window -- token null is not valid; is your activity running?

I am trying to put a feature ...READ MORE

May 18, 2022 in Others by Kichu
 • 19,040 points • 8,402 views
0 votes
1 answer

How to use goal seek function in Excel user function?

In the Microsoft Excel Object-Sheet1(Sheet1), we can ...READ MORE

Oct 28, 2022 in Others by narikkadan
 • 86,360 points • 1,419 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.