Trending questions in Others

0 votes
1 answer

Number format in excel: Showing % value without multiplying with 100

You just need to select Custom from ...READ MORE

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

How to download SQL data in excel format using asp.net

Solution Download Open XML Download Close XML Library. import this Namespaces using System.IO; using System.Data; using ...READ MORE

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

How to automatically nest rows of an Excel spreadsheet using level values?

More grouping levels have been added to ...READ MORE

Nov 21, 2022 in Others by narikkadan
 • 86,360 points • 963 views
0 votes
0 answers

Excel: How to Sort or filter text by specific word or words?

Even if the term is used in ...READ MORE

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

artificial intelligence is associated with which generation

Artificial Intelligence is associated with fifth-generation computer ...READ MORE

Feb 7, 2022 in Others by Edureka
 • 12,710 points • 13,362 views
0 votes
1 answer

Excel graphics with ggplot2

Excel's pseudo-3D charts are choked full of ...READ MORE

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

Referencing an Excel file, workbook, worksheet in C#

Try the following code. using System; using System.Data; using Excel ...READ MORE

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

Disable Ctrl+D for particular workbook

When you click CTRL+D, it will now ...READ MORE

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

Apache POI - watermark in Excel - different appearance in Excel and LibreOffice

There is nothing that apache poi could ...READ MORE

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

Excel: Search for a list of strings within a particular string using array formulas?

If a match is detected, this will ...READ MORE

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

Shape Names In Excel

Try this: Option Explicit Sub Button1_Click() ...READ MORE

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

Hyperlink changes from # to %20-%20 when clicked in Excel

This is a known issue with MS Excel. Basically, ...READ MORE

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

Format an Excel Sheet in Python

The below code will help you refer ...READ MORE

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

Formula for inserting a thumbnail picture into excel cell, based on another cell's value

Here is a really excellent tutorial on ...READ MORE

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

How to look in all folders in directory to change file extensions of excel file?

Loop Through All Subfolders Using VBA Dim strCurrentFileExt ...READ MORE

Nov 24, 2022 in Others by narikkadan
 • 86,360 points • 826 views
0 votes
2 answers

Disable AWS S3 Management Console

Yes, it is possible to disable the ...READ MORE

Jun 20, 2023 in Others by Khan Sarfaraz
• 700 points • 1,176 views
0 votes
0 answers

Strikethrough in Excel VBA

When I enter the second date in ...READ MORE

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

Microsoft Excel: Formula bar says "Calculations!" instead of the equation used

By right-clicking the Retirement Planner sheet tab ...READ MORE

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

Use R to create chart in Excel sheet

Here is a solution utilizing the XLConnect ...READ MORE

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

How to reduce a huge excel file

I have a short, straightforward *.XLS file ...READ MORE

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

Concatenate columns using LEFT and RIGHT in EXCEL

It's conceivable that the Concat/Concatenate function isn't ...READ MORE

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

How do I align a UserForm next to the active cell?

Answer to Q1 - Yes, it's correct. In ...READ MORE

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

Rich text format (with formatting tags) in Excel to unformatted text

This function ought to be helpful if ...READ MORE

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

Is there any way in python to auto-correct spelling mistake in multiple rows of an excel files of a single column?

Use Spellchecker for doing your stuff: import pandas ...READ MORE

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

How to keep one variable constant with other one changing with row in excel

Use this form: =(B0+4)/$A$0 Since you are dragging across ...READ MORE

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

Excel SUMIFS() using string with greater/less than symbols

Put an = in front to let Excel know ...READ MORE

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

How to "Print" Excel Sheet on Custom Page Size like Din A1?

Try turning the pdf file into an ...READ MORE

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

How do I insert a WebP-image (".jpg") in Excel using VBA?

It's not currently on the list of ...READ MORE

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

Using office scripts to read superScripts characters from a cell in excel online

My understanding is that superscript and subscript ...READ MORE

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

Excel VBA - Delete empty rows

Try this: sub foo() dim r As ...READ MORE

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

Excel - IF combined with Index Match

Try: =IFERROR(IF(ISNUMBER(O2),VLOOKUP(A2,Sheet2!$C$2:$E$10,3,FALSE),""),"") =IFERROR(IF(ISNUMBER(O2),INDEX(Sheet2!$E$2:$E$10,MATCH(A2,Sheet2!$C$2:$C$10,0)),""),"") where the first "" means that O2 is not a number, ...READ MORE

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

In excel how do I reference the current row but a specific column?

Put a $ symbol in front of ...READ MORE

Oct 15, 2022 in Others by narikkadan
 • 86,360 points • 2,450 views
0 votes
0 answers

Combining MID and LEFT Functions in Excel 2019

I currently have a course name and ...READ MORE

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

How to read single Excel cell value

You need to cast it to a ...READ MORE

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

Excel web query to login into a website

To be recognized by the web server ...READ MORE

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

Excel Power Pivot/Data Model

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

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

Opening or downloading an excel file from aspx web page fails: It doesn't open in application

In regards to your first edit, the ...READ MORE

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

Excel - function to convert first letter of each word to uppercase

there are two methods to do this: Method ...READ MORE

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

Force download excel file not working on web server

Change the content type to Content-Type: application/vnd.ms-excel Or try ...READ MORE

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

Convert PDF to Excel in Java

You can convert a PDF document to ...READ MORE

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

Determine if calculation between 2 date time values is < 72 Hours in excel

Actually, Excel is quite accommodating in this ...READ MORE

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

Saving style of the header of StyleFrame.object to_excel

The correct way to style the headers ...READ MORE

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

Using "If cell contains #N/A" as a formula condition.

Input the following formula in C1: =IF(ISNA(A1),B1,A1*B1) Screenshots: When #N/A: When not ...READ MORE

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

Excel offset where reference is to another worksheet

Solution:  =OFFSET((INDIRECT(ADDRESS(1,1,,,"Sheet2")),ROW(),0,,) References: OFFSET(starting point, num of rows, num ...READ MORE

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

Paste special issue, From Excel to Word

Since the table in the word document ...READ MORE

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

Using standard deviation function in excel for a specific criteria?

Use this: =STDEV(IF((A1:A1000>=-0.5)*(A1:A1000<=0.5),A1:A1000)) Depending on one's version this may ...READ MORE

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

Spell check an Excel sheet in VBA

Use this code to check the whole ...READ MORE

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

Comparing two Excel files in R and returning different titles

Solution: library(tidyverse) dat <- read_xlsx("Book1.xlsx") dat2 <- read_xlsx("Book2.xlsx") book1_output <- anti_join(dat,dat2, ...READ MORE

Oct 14, 2022 in Others by narikkadan
 • 86,360 points • 2,413 views
+1 vote
1 answer

Excel macro to make selected range absolute or relative reference?

Try  this: Sub ConverReferenceType() On ...READ MORE

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

How to remove gridlines on select cells in Google Sheets?

The google sheets don't have an exact ...READ MORE

Nov 20, 2022 in Others by narikkadan
 • 86,360 points • 798 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.