Trending questions in Others

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,322 views
0 votes
1 answer

Is there a way to lock cells after editing an excel sheet that's on sharepoint?

The Excel Web version (which, based on ...READ MORE

Oct 3, 2022 in Others by narikkadan
 • 86,360 points • 2,805 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,452 views
0 votes
1 answer

ActiveWorkbook.SaveAs excel 2013 1004 error

Error reproduction: I was able to reproduce the ...READ MORE

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

How can I use a command button in excel to set the value of multiple cells in one click?

Try this: Private Scan As Integer Private Sub CommandButton1_Click() ...READ MORE

Oct 24, 2022 in Others by narikkadan
 • 86,360 points • 1,907 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 • 989 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 • 1,542 views
0 votes
1 answer

Deleting Empty rows in Excel using VBA

On Error Resume Next worksheet.Columns("A:A").SpecialCells(xlCellTypeBlanks).EntireRow.Delete On Error GoTo 0 When ...READ MORE

Oct 7, 2022 in Others by narikkadan
 • 86,360 points • 2,609 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,307 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,530 views
0 votes
1 answer

How to express absolute cell references in Excel R1C1-style formulas?

If the formulas are in Column K ...READ MORE

Oct 15, 2022 in Others by narikkadan
 • 86,360 points • 2,247 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 • 1,473 views
0 votes
0 answers

mysql said: Cannot connect: invalid settings. xampp

I changed the root password to test ...READ MORE

May 23, 2022 in Others by Kichu
 • 19,040 points • 8,545 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 • 425 views
0 votes
1 answer

Xcode 12.4 “Unsupported OS version” after iPhone iOS update 14.7

This might be a temporary solution but ...READ MORE

Nov 4, 2022 in Others by gaurav
 • 24,860 points • 2,269 views
0 votes
1 answer

Currency conversion:number to words excel

Try looking for javascript solutions to use ...READ MORE

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

Create charts in excel sheet [ in same sheet along with data C#]

Unfortunately, it's not that simple. Use the ...READ MORE

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

Convert Feet to meters in excel with macro for entire column

You can convert Feet to Kilometers using ...READ MORE

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

Frequency Array formula EXCEL not calculating

You obtain the same outcome, which suggests ...READ MORE

Oct 31, 2022 in Others by narikkadan
 • 86,360 points • 1,519 views
0 votes
0 answers

How to insert dropdown or checkbox in Excel using Javascript API?

I'm following the doc (https://dev.office.com/reference/add-ins/excel/excel-add-ins-reference-overview) to build ...READ MORE

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

Merge and export Excel/Word/PDF to PDF

Use GroupDocs.Merger for .NET API to merge Word, Excel, ...READ MORE

Oct 3, 2022 in Others by narikkadan
 • 86,360 points • 2,739 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
 • 86,360 points • 1,339 views
0 votes
1 answer

How to show caller image on iOS native ui call by using callkit framework?

Apple's CallKit is a framework introduced with iOS ...READ MORE

Nov 4, 2022 in Others by gaurav
 • 24,860 points • 2,239 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
 • 86,360 points • 1,540 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 • 1,330 views
0 votes
1 answer

Using VLOOKUP()

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

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

Convert three letter country codes to full country names

Just create a list to be used in ...READ MORE

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

Indent table pasted from Excel into Word

It is feasible to pick up the ...READ MORE

Oct 30, 2022 in Others by narikkadan
 • 86,360 points • 1,516 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 • 475 views
0 votes
2 answers

what is azure cloud?

Azure Cloud is Microsoft's cloud computing platform, ...READ MORE

Aug 9, 2023 in Others by Khan Sarfaraz
• 700 points • 1,512 views
0 votes
1 answer

what is prolog in artificial intelligence

It's aa good ques READ MORE

May 13, 2022 in Others by anonymous
edited Mar 5, 2025 • 11,228 views
0 votes
1 answer

Quadratic and cubic regression in Excel

You need to use an undocumented trick ...READ MORE

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

aws s3 replace file atomically

Simply upload your new file on top ...READ MORE

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

How do I calculate Interest rate (R) from EMI formula if I know EMI, Principal (P) and Time (N)?

Try this: #include <iostream> #include <cmath> #include <boost/date_time/posix_time/posix_time.hpp> #include <boost/thread/thread.hpp> #define TOLERANCE ...READ MORE

Oct 21, 2022 in Others by narikkadan
 • 86,360 points • 1,866 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
 • 24,860 points • 1,076 views
0 votes
1 answer

Using Java to create PDF graphs based on Excel formulas

The Apache POI project, an API for ...READ MORE

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

How do I protect all worksheet in an Excel workbook with a single click?

VBA Code : Dim ws as Worksheet Dim pwd ...READ MORE

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

Export HTML Table to Excel- Doesn't Open in Office 2010

We had the same issue too many ...READ MORE

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

Subtotal in result row returns 0 in excel table

Syntax SUBTOTAL(function_num,ref1,[ref2],...) The SUBTOTAL function syntax has the following ...READ MORE

Sep 25, 2022 in Others by narikkadan
 • 86,360 points • 2,982 views
0 votes
1 answer

Excel TRIM Function Bug

Line feed (ascii 10), it appears, is ...READ MORE

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

Convert word document to excel

n essence, I had to change the ...READ MORE

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

Excel Automation Anywhere

In Automation Anywhere, the Excel command is ...READ MORE

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

Excel Formula to convert from cm to inches and feet & round off to two digits

Use the TEXT function to format, and ...READ MORE

Oct 15, 2022 in Others by narikkadan
 • 86,360 points • 2,075 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, 2025 • 396 views
0 votes
1 answer

Adding Signature Line Word-Excel

Since there doesn't appear to be a ...READ MORE

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

Display a table (in the html/Excel spreadsheet meaning) in a iOS app in Swift

Here is the answer to your question: ...READ MORE

Oct 29, 2022 in Others by narikkadan
 • 86,360 points • 1,438 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 • 1,226 views
0 votes
1 answer

Excel - Unable to open https// <<PATH>> Cannot download the information you requested ---- How to disable

You can find the answer to your ...READ MORE

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

Many cells to a single reference in excel

Use conditional formatting to hide the A's ...READ MORE

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

Print Excel Worksheet/Workbook

I'm attempting to make a C# Winform ...READ MORE

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