Trending questions in Others

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
• 63,600 points
1,105 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,235 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
• 63,600 points
454 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
697 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
740 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 34 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,319 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 37 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,962 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,053 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,743 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
825 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
770 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,586 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,015 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
666 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
881 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
696 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,958 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
608 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
785 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,299 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
910 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,930 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,630 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,843 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
670 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
762 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,099 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,492 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,949 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
950 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
910 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,202 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,312 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
643 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,548 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,500 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
498 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
699 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,883 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
959 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,255 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,549 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,416 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
936 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
721 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
767 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
677 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,490 views