Trending questions in Others

0 votes
0 answers

Hi can someone explain the five phases of IT project methodology management for me as follows :

Hi can someone explain the five phases ...READ MORE

Dec 28, 2022 in Others by anonymous
edited Mar 4, 2025 • 499 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 • 2,006 views
0 votes
1 answer

Trouble pasting a Word equation into Excel

Use this: Sub ExpandEqn(MyText As String) ...READ MORE

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

Excel: Median of even number of values with a condition

The LARGE function, COUNT function, and TRUNC ...READ MORE

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

How to simplify adding multiple countifs formula in excel

If the Excel version you are using ...READ MORE

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

.doc to pdf using python

A simple example using comtypes, converting a single ...READ MORE

Sep 25, 2022 in Others by narikkadan
 • 86,360 points • 4,513 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 • 2,100 views
0 votes
1 answer

Excel MATCH function is not working on an array but works once directed to the matched value

According to the definition here: support.microsoft.com/en-us/office/… if you do ...READ MORE

Nov 17, 2022 in Others by narikkadan
 • 86,360 points • 2,140 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
 • 86,360 points • 3,516 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 • 3,900 views
0 votes
1 answer

Loop formula in excel vba

You can use an IF statement to ...READ MORE

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

Creating a function in excel VBA to calculate the average point in a circular set of numbers

I used the following code to determine ...READ MORE

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

Calculate slope and intercept value for logarithmic trendline as excel

You missed Math.log() for ln() in Excel. ...READ MORE

Nov 8, 2022 in Others by narikkadan
 • 86,360 points • 2,555 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 • 2,249 views
0 votes
1 answer

How to fix a circular reference error by if condition in excel file?

Circular reference in this context refers to ...READ MORE

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

Generate VCards from Excel using VBA

Solution  Create a class called CContact with getters ...READ MORE

Nov 21, 2022 in Others by narikkadan
 • 86,360 points • 1,931 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 • 3,591 views
0 votes
0 answers

Unable to add window -- token null is not valid; is your activity running?

I am trying to put a feature ...READ MORE

May 18, 2022 in Others by Kichu
 • 19,040 points • 9,971 views
0 votes
1 answer

Calculate time difference in hours between two dates and times

Simply subtract the two dates to get ...READ MORE

Nov 4, 2022 in Others by narikkadan
 • 86,360 points • 2,679 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,690 points • 13,834 views
0 votes
0 answers

Convert Excel to PDF programmatically

I am using (docker, deploy using k8s....). How ...READ MORE

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

How can solve this Solver Excel like problem in R?

More details and explanations are required so ...READ MORE

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

How to update an existing excel .ods file?

It cannot be altered unless the original ...READ MORE

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

"Advance" an Excel formula via keyboard shortcut while in edit mode?

As requested, you can carry out the ...READ MORE

Dec 10, 2022 in Others by narikkadan
 • 86,360 points • 1,290 views
0 votes
1 answer

Remove formulas from all worksheets in Excel using VBA

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

Oct 3, 2022 in Others by narikkadan
 • 86,360 points • 3,955 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 • 2,430 views
0 votes
0 answers

In Excel Sheet how to Eliminate or Remove, Filter and copy the selected records defined in another sheet using dynamic array list (VBA Module)

 I'm attempting to generate an Excel sheet ...READ MORE

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

How can i add cells if condition is met

Both the AND function and nested if ...READ MORE

Nov 24, 2022 in Others by narikkadan
 • 86,360 points • 1,704 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 • 2,132 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 • 2,215 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 • 2,302 views
0 votes
0 answers

Creating a chart in Excel that ignores #N/A or blank cells

A dynamic data series will be used ...READ MORE

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

How to convert Ods file to Data Set C#

You can see the answer here: READ MORE

Oct 8, 2022 in Others by narikkadan
 • 86,360 points • 3,733 views
0 votes
0 answers

Unable to access the jenkins in browser

I have installed jenkins in a linux ...READ MORE

Dec 20, 2022 in Others by Edureka
edited Mar 4, 2025 • 580 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 • 2,033 views
0 votes
1 answer

How to merge columns in Excel but keep data on other columns

VLOOKUP indeed can be used here, combined ...READ MORE

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

Prompt message if Excel column has some value in asp.net c#

I believe it is wise to use ...READ MORE

Nov 24, 2022 in Others by narikkadan
 • 86,360 points • 1,673 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,886 views
0 votes
1 answer

Excel VLOOKUP where the key is not in the first column

INDEX/MATCH will do it in any direction of ...READ MORE

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

How to insert info into online excel spreadsheet with python selenium

I recently discovered one of my options, ...READ MORE

Oct 24, 2022 in Others by narikkadan
 • 86,360 points • 3,005 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,966 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 • 2,690 views
0 votes
0 answers

Conditional statement (truth table) formula on Excel

What is the formula for p=>q? READ MORE

Nov 27, 2022 in Others by Kithuzzz
 • 38,000 points • 1,558 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 • 2,334 views
0 votes
0 answers

Tamil content not found in excel

I downloaded an excel document in Tamil. ...READ MORE

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

Is there a way in Microsoft Excel to give specific bins different bin widths when making a histogram plot?

Excel built-in histogram tool only allows equal ...READ MORE

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

Countifs formula using weekday function

Use SUMPRODUCT: =SUMPRODUCT(((WEEKDAY(TODAY())>= 3)*(WEEKDAY(TODAY())<=6)*(INT(AG10:AG100)=INT(TODAY()-1)))+((WEEKDAY(TODAY())=2)*(INT(AG10:AG100)>=INT(TODAY()-3))*(INT(AG10:AG100)<=INT(TODAY()-1)))) If the Dates in AG ...READ MORE

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

Excel Conditional Formatting based on Adjacent Cell Value

The row number used in the formula ...READ MORE

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

Parsing from Excel multisheet file: List comprehension between columns

You can use read_excel with parameter sheetname=None for return all sheets ...READ MORE

Nov 25, 2022 in Others by narikkadan
 • 86,360 points • 1,565 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
 • 86,360 points • 3,338 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.