Trending questions in Others

0 votes
1 answer

Is there a function to unhide columns in excel through python

Excel file : df.to_excel('demofile.xlsx',index=False) import openpyxl py = openpyxl.load_workbook('demofile.xlsx') exlsheet = ...READ MORE

Oct 18, 2022 in Others by narikkadan
• 63,600 points
2,579 views
0 votes
1 answer

Excel Formula with Nested IF/LEFT/AND Functions

Use this: =IF(SUMPRODUCT(--(LEFT(G3,1)={"1","2","3"}))>0,"998", ...READ MORE

Nov 21, 2022 in Others by narikkadan
• 63,600 points
1,069 views
0 votes
1 answer

Excel - How can I get the average of cells where the value in one column is X and the value in another column is Y?

Use AVERAGEIFS ... =AVERAGEIFS(C2:C13,A2:A13,"Yellow Typ ...READ MORE

Nov 11, 2022 in Others by narikkadan
• 63,600 points
1,534 views
0 votes
1 answer

Control cell value from another cell in Excel

You may accomplish this by using two ...READ MORE

Nov 10, 2022 in Others by narikkadan
• 63,600 points
1,557 views
0 votes
1 answer

How to extract Bills receivable data to excel from tally by ODBC?

To obtain the company's receivable bills, you ...READ MORE

Nov 12, 2022 in Others by narikkadan
• 63,600 points
1,465 views
0 votes
1 answer

Average TIME Calculation differs between Excel and PowerBI

They are calculating different things. In Power ...READ MORE

Sep 21, 2022 in Others by narikkadan
• 63,600 points
3,704 views
0 votes
1 answer

Microsoft.Office.Interop.Excel for Office 2007

Each client must install the  2007 Microsoft ...READ MORE

Nov 5, 2022 in Others by narikkadan
• 63,600 points
1,749 views
0 votes
1 answer

Excel delete row if column contains value from to-remove-list

Given sheet 2: ColumnA ------- apple orange You can flag the rows ...READ MORE

Nov 6, 2022 in Others by narikkadan
• 63,600 points
1,695 views
0 votes
1 answer

Apache POI. Setup data filters in Excel

It's already enabled in Apache POI 3.7. ...READ MORE

Oct 21, 2022 in Others by narikkadan
• 63,600 points
2,384 views
0 votes
1 answer

(Excel) If cell is greater than <condition> then minus <number>

The IF function to calculate B5 (amount ...READ MORE

Nov 7, 2022 in Others by narikkadan
• 63,600 points
1,634 views
0 votes
1 answer

How to open an Excel file in C#?

You must have Microsoft Visual Studio Tools ...READ MORE

Nov 13, 2022 in Others by narikkadan
• 63,600 points
1,372 views
0 votes
0 answers

How to apply Filter and and copy filter results to another sheet using C# and Excel Interop

I want to apply a filter to ...READ MORE

Nov 27, 2022 in Others by Kithuzzz
• 38,000 points
805 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
• 63,600 points
1,065 views
0 votes
1 answer

Test or check if sheet exists

Some people don't like this strategy because ...READ MORE

Oct 27, 2022 in Others by narikkadan
• 63,600 points
2,101 views
0 votes
1 answer

How can I convert excel file to pdf using TCPDF?

PHPExcel can only read charts from Excel2007 ...READ MORE

Oct 21, 2022 in Others by narikkadan
• 63,600 points
2,361 views
0 votes
1 answer

In MS Excel what formula can be used to calculate growth when CAGR for the period is already given?

If those are true CAGR's, then just ...READ MORE

Nov 20, 2022 in Others by narikkadan
• 63,600 points
1,059 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
797 views
0 votes
1 answer

Is there a way to remove password in a Excel file (.xls) using shell in Linux with known password?

Dig into the Excel documentation for the ...READ MORE

Nov 7, 2022 in Others by narikkadan
• 63,600 points
1,612 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
• 63,600 points
1,093 views
0 votes
1 answer

Sending excel data to Tally

You can use Requests to send the ...READ MORE

Nov 19, 2022 in Others by narikkadan
• 63,600 points
1,080 views
0 votes
1 answer

Import online excel file in google spreadsheet?

The function is: /** * Convert Excel file ...READ MORE

Nov 26, 2022 in Others by narikkadan
• 63,600 points
774 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
• 63,600 points
773 views
0 votes
1 answer

Excel Formula - if values in columns all contain X then return

You can use the AND function: = IF(AND(A3="OK";B3="OK";C3="OK");"everything ...READ MORE

Nov 4, 2022 in Others by narikkadan
• 63,600 points
1,709 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
• 63,600 points
841 views
0 votes
1 answer

How to create and download excel document using asp.net

First, download the Open XML Format SDK 2.0. It comes ...READ MORE

Oct 3, 2022 in Others by narikkadan
• 63,600 points
3,106 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
• 63,600 points
730 views
0 votes
1 answer

I have filtered my Excel data and now I want to number the rows. How do I do that?

Solution Filter your data. Select the cells you want ...READ MORE

Nov 14, 2022 in Others by narikkadan
• 63,600 points
1,250 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
726 views
0 votes
0 answers
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
• 63,600 points
707 views
0 votes
1 answer

When doing a MERGE in Oracle SQL, how can I update rows that aren't matched in the SOURCE?

I see you asked it a long ...READ MORE

Nov 7, 2022 in Others by gaurav
• 23,260 points
1,556 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
• 63,600 points
881 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
• 63,600 points
785 views
0 votes
1 answer

How to clear contents of an Excel Workbook through vba

When the range you're referring to doesn't ...READ MORE

Nov 19, 2022 in Others by narikkadan
• 63,600 points
998 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
• 63,600 points
1,045 views
0 votes
1 answer

Hosting Microsoft Edge via WebView2Loader.dll with Excel VBA

Here's an API to communicate with Chromium ...READ MORE

Sep 29, 2022 in Others by narikkadan
• 63,600 points
3,241 views
0 votes
1 answer

Excel dropdown with name/value pairs

Solution Define a range to use as the ...READ MORE

Oct 7, 2022 in Others by narikkadan
• 63,600 points
2,846 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
681 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
• 63,600 points
862 views
0 votes
1 answer

Convert table in a jpg image to excel using python

I believe you must execute OCR (optical ...READ MORE

Oct 16, 2022 in Others by narikkadan
• 63,600 points
2,442 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
• 63,600 points
1,622 views
0 votes
1 answer

'Microsoft.Office.Interop.Excel.Range' does not contain a definition for 'get_Default'

You are using C# version 4, the ...READ MORE

Oct 16, 2022 in Others by narikkadan
• 63,600 points
2,434 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
• 63,600 points
1,179 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
• 63,600 points
701 views
0 votes
1 answer

How to hide and unhide the columns of an excel sheet using asp.net

Use this. For Row: worksheet_sub.Row(i).Height = 0; For Column: ...READ MORE

Oct 29, 2022 in Others by narikkadan
• 63,600 points
1,862 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
• 63,600 points
692 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
629 views
0 votes
1 answer

Excel VBA to change background image of shape by clicking on shape

You need to keep track of what ...READ MORE

Sep 23, 2022 in Others by narikkadan
• 63,600 points
3,410 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
• 63,600 points
928 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
617 views