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,081 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
683 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,202 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
720 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 22 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 23 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,296 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
812 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,018 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,707 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,913 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
738 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,720 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
993 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
646 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
682 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
861 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,544 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
767 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
587 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,280 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,919 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
889 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
653 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,601 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
732 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,927 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
930 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,452 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,772 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,037 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,842 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
626 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
883 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,524 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
483 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
684 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,273 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,473 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,842 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
926 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,221 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,518 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
662 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
915 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
700 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
747 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,386 views
0 votes
1 answer

Which is better normal desktop window or MDI like excel and chronos

How people interact with your system entirely ...READ MORE

Nov 4, 2022 in Others by narikkadan
• 63,600 points
609 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,453 views