Trending questions in Others

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
 • 63,600 points • 449 views
0 votes
0 answers

Bootstrap modal: is not a function

When I call my model in windows ...READ MORE

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

Excel VBA : HOW TO PRINT THE TEXT IN A CELL (like Wrap Text)

Use a LineFeed character to create a ...READ MORE

Oct 27, 2022 in Others by narikkadan
 • 63,600 points • 1,224 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
 • 63,600 points • 691 views
0 votes
1 answer

Excel shared formula expansion

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

Nov 7, 2022 in Others by narikkadan
 • 63,600 points • 732 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 • 28 views
0 votes
1 answer

How to add Conditional Formatting in Excel for a Range of Values

Three distinct rules are required, one for ...READ MORE

Oct 24, 2022 in Others by narikkadan
 • 63,600 points • 1,312 views
0 votes
0 answers

I am doing the monataring tools setup using ansible

ERROR! the role 'prometheus' was not found ...READ MORE

Nov 23, 2022 in Others by ramanji
edited Mar 4 • 30 views
0 votes
1 answer

Trying to create an enclosing bookmark after pasting a picture from Excel into Word using VBA

Try this: Sub IMPORT_TO_WORD() Dim ws1 As Worksheet, ws2 ...READ MORE

Oct 30, 2022 in Others by narikkadan
 • 63,600 points • 1,044 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
 • 63,600 points • 1,946 views
0 votes
1 answer

Xamarin iOS app displaying white blank screen on iPad after update to Xcode 11

Assuming you have your iPad Pro connected ...READ MORE

Nov 4, 2022 in Others by gaurav
 • 23,260 points • 1,726 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
 • 63,600 points • 819 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
 • 63,600 points • 761 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
 • 63,600 points • 1,009 views
0 votes
1 answer

How do you calculate the Quintile for groups of rows in Excel?

Use this formula: =MAX(1,ROUNDUP(10*PERCENTRANK($C:$C,$C2,4),0)) To divide into whichever many ...READ MORE

Oct 17, 2022 in Others by narikkadan
 • 63,600 points • 1,571 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
 • 63,600 points • 653 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,260 points • 689 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 • 871 views
+1 vote
1 answer

How to use VBA in Excel for Google Search?

Try this: Private Const LicenseRegistration As String = ...READ MORE

Oct 7, 2022 in Others by narikkadan
 • 63,600 points • 1,946 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
 • 63,600 points • 780 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
 • 63,600 points • 601 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
 • 63,600 points • 1,292 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 • 899 views
0 votes
1 answer

How do I create a hyperlink from Word to Excel specific cell, without macros/vba?

All you have to do is copy ...READ MORE

Oct 15, 2022 in Others by narikkadan
 • 63,600 points • 1,622 views
0 votes
1 answer

Copy Text from Range in Excel into Word Document

Here are some articles that may help: Control ...READ MORE

Nov 6, 2022 in Others by narikkadan
 • 63,600 points • 663 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
 • 63,600 points • 755 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 • 1,479 views
0 votes
1 answer

Excel Issue- custom format for Turkish currency

What about: #.##0,00 [$₺-tr-TR] Where #.##0,00 € would do for ...READ MORE

Oct 10, 2022 in Others by narikkadan
 • 63,600 points • 1,814 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
 • 63,600 points • 1,942 views
0 votes
1 answer

Calculate monthly average from daily data without PivotTable

Assuming you have the months in column D enter ...READ MORE

Oct 3, 2022 in Others by narikkadan
 • 63,600 points • 2,078 views
0 votes
1 answer

"The underlying connection was closed: An unexpected error occurred on a send." With SSL Certificate

The solution for this for me was ...READ MORE

Feb 18, 2022 in Others by Rahul
 • 9,680 points • 11,892 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
 • 63,600 points • 939 views
0 votes
1 answer

How do I specify a variable Excel range?

Try this: =SUM(OFFSET(A1,0,1,1,3)) To break it down: OFFSET(reference cell, ...READ MORE

Oct 30, 2022 in Others by narikkadan
 • 63,600 points • 898 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
 • 63,600 points • 2,300 views
0 votes
1 answer

Using VLOOKUP()

Vlookup takes the lookup value first, so ...READ MORE

Nov 5, 2022 in Others by narikkadan
 • 63,600 points • 634 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
 • 63,600 points • 1,541 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
 • 63,600 points • 1,491 views
0 votes
0 answers

Converting feet & inches (e.g., "5 ft 1 in") to decimal feet using VBA or Excel

I have a database with a few ...READ MORE

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

Understanding How Excel Processes Array Functions

An array formula is a formula that can ...READ MORE

Nov 8, 2022 in Others by gaurav
 • 23,260 points • 492 views
0 votes
1 answer

'npm' is not recognized as internal or external command, operable program or batch file

To your existing lines of code, include ...READ MORE

Feb 10, 2022 in Others by Rahul
 • 9,680 points • 12,169 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
 • 63,600 points • 1,865 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
 • 63,600 points • 2,243 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
 • 63,600 points • 946 views
0 votes
1 answer

How to Import Excel Worksheet into Microsoft Project?

Solution: Wizard's preliminary settings: New map As a new project Tasks, ...READ MORE

Oct 14, 2022 in Others by narikkadan
 • 63,600 points • 1,535 views
0 votes
1 answer

Excel formula to calculate contribution

For several component numbers, you may obtain ...READ MORE

Oct 17, 2022 in Others by narikkadan
 • 63,600 points • 1,409 views
0 votes
0 answers

Excel to Tally Import with multiples Cost categories

In Tally, I want to import Journal ...READ MORE

Nov 2, 2022 in Others by Kithuzzz
 • 38,000 points • 717 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
 • 63,600 points • 927 views
+1 vote
0 answers

Google spreadsheet direct download link for only ONE sheet as excel

If a Google Spreadsheet, for example, just ...READ MORE

Nov 2, 2022 in Others by Kithuzzz
 • 38,000 points • 672 views
0 votes
0 answers

Data Driven Framework -- how to read and write in excel sheet using Selenium WebDriver with java

I'm using this code to read something, ...READ MORE

Oct 31, 2022 in Others by Kithuzzz
 • 38,000 points • 761 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
 • 63,600 points • 1,476 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.