Trending questions in Others

0 votes
1 answer

Calculating the week number of a year in Excel

Here is my excel formula. =IF(AND(A1>=DATE(YEAR(A1),1,1),A1< ...READ MORE

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

How to remove Blank Rows using EPPlus Excel Package Plus

It is checking the last row if ...READ MORE

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

How use File("/sdcard/myfile") without READ_EXTERNAL_STORAGE on android 11?

Why are u screeching for SD related ...READ MORE

Jun 16, 2023 in Others by Akashy mulchand Ani
edited Mar 5, 2025 • 1,905 views
0 votes
1 answer

Formula to convert KG,MB,GB,TB to GB in excel

Use this array formula: =LEFT(A1,MIN(IFERROR(FIND({"KB","MB","GB","TB"},A1),1E+99))-1)/INDEX({1048576,1024,1,0.0009765625},MATCH(RIGHT(A1,2),{"KB","MB","GB","TB"},0)) & "GB" Being an ...READ MORE

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

Excel Formula - Calculating Total Percentage

You just need the AVERAGE of all ...READ MORE

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

Drawing an excellent cow

If you are on Linux and have cowsay installed ...READ MORE

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

Can I insert a file into Excel without creating a reference?

You can easily embed a PDF into ...READ MORE

Dec 27, 2022 in Others by narikkadan
 • 86,360 points • 1,074 views
0 votes
0 answers

Is it possible to create Pivot Chart with source data as Pivot Table using Apache POI?

Using apache POI separately, I can make ...READ MORE

Dec 15, 2022 in Others by Kithuzzz
 • 38,000 points • 1,551 views
0 votes
1 answer

What does the " @ " symbol mean in Excel formula (outside a table)

Excel has recently introduced a huge feature ...READ MORE

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

Search for number and degree symbol

The Instr and Like operators are not mutually excluding which means ...READ MORE

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

How to lock data in excel sheet using POI, leaving cells without any data / the rest of the sheet unlocked

If the cells in a row have ...READ MORE

Sep 24, 2022 in Others by narikkadan
 • 86,360 points • 5,119 views
0 votes
1 answer

Excel-VBA - How to identify Target range (more than 1 cell) is deleted in a Worksheet_Change function?

You misunderstand the purpose of the function ...READ MORE

Sep 23, 2022 in Others by narikkadan
 • 86,360 points • 5,153 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
 • 86,360 points • 2,970 views
0 votes
1 answer

Excel - VLOOKUP vs. INDEX/MATCH - Which is better?

Since it is much more adaptable and ...READ MORE

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

How to reference Microsoft.Office.Interop.Excel dll?

Use NuGet (VS 2013+): The NuGet package manager ...READ MORE

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

Calculate Monthly Highest Selling Product - MS Excel

Use a Pivot Table to summarize the ...READ MORE

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

Convert column in excel date format (DDDDD.tttt) to datetime using pandas

Given # s = df['date'] s 0 ...READ MORE

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

Using excel I need to open PPT and create ".gif" image of a ."pdf" and save it

It appears happier if you get a ...READ MORE

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

How to get the excel file name / path in VBA

Use FullName, for example: strFileFullName = ThisWorkbook.FullName ...READ MORE

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

Calculating the mean and std on excel file using python

Use pandas to do this: import pandas as pd df = ...READ MORE

Nov 4, 2022 in Others by narikkadan
 • 86,360 points • 3,283 views
0 votes
1 answer

Convert text date/time to a real date time in excel

For a date conversion: =DATEVALUE(TEXT(A1,"MM/DD/YYYY")) For a time conversion: =TIMEVALUE(TEXT(A1,"HH:MM:SS")) For ...READ MORE

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

Excel: VLOOKUP from a different Sheet

The worksheet name must be included in ...READ MORE

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

How to use Excel VLOOKUP function with words that begin with the letters AB

If you lookup "AB" in Excel, it ...READ MORE

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

Identify cell that don't contain "formula"

Select the range you wish to test, ...READ MORE

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

How can I store the data of an open excel workbook in a collection using BluePrism?

To do what you want is like ...READ MORE

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

How to increment row value in an index function in excel?

Try this- =INDEX($F$27:$F$40,COLUMN(A$1)) It will automatically increase the row ...READ MORE

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

How to Convert Excel Cell Values Into Individual PNG Files?

This will: create a chart add an image to ...READ MORE

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

How to connect ms excel-2007 with mysql.

Try this: Function runQuery() Dim cn As Object Dim rs ...READ MORE

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

Reading multiple Excel files and merge them sheet-wise

This will analyse each Excel and combine ...READ MORE

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

Excel data validation list

We can use nested if - if ...READ MORE

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

Excel Power Query import (same file but with different month name)

Use the name manager function in Excel ...READ MORE

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

Using C# to find drawn arrows in Excel

There are 28 different varieties of arrow ...READ MORE

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

How to use relative names in Excel VBA

It appears you are looking for Range.Offset() http://msdn.microsoft.com/en-us/library/office/ff840060%28v=office.15%29.aspx However, you ...READ MORE

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

Division formula in excel

You may use this Array formula in ...READ MORE

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

How to Freeze Top Row and Apply Filter in Excel Automation with C#

Try this: // Fix first row workSheet.Activate(); workSheet.Application.ActiveWindow.SplitRow = 1; workSheet.Application.ActiveWindow.FreezePanes ...READ MORE

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

How to download and setup sqlplus for running sql commands?

Installing SQLPlus on Windows: Step 1: First browse ...READ MORE

Nov 7, 2022 in Others by gaurav
 • 23,580 points • 3,043 views
0 votes
1 answer

How to freeze the top row and the first column using XlsxWriter?

You can use worksheet.freeze_panes() to achieve this . There ...READ MORE

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

Excel Formula calculating the starting date of a given calendar week

The number of days to take into ...READ MORE

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

How to get Bitmap from an Uri?

Try using the following lines of code ...READ MORE

Feb 18, 2022 in Others by Aditya
 • 7,680 points • 14,279 views
0 votes
1 answer

How do I avoid repeating long formulas in Excel when working with comparisons?

Try this: =IFERROR(EXP(LN(REALLY_LONG_FORMULA – threshold)) + threshold, 0) The ...READ MORE

Dec 15, 2022 in Others by narikkadan
 • 86,360 points • 1,334 views
0 votes
0 answers

Subtotal and Sum gives different result

I'm totally at a loss with this ...READ MORE

Jan 7, 2023 in Others by Kithuzzz
 • 38,000 points
edited Mar 4, 2025 • 371 views
0 votes
1 answer

Non-exact Vlookup with multiple search criteria - Microsoft Excel

Use the array function: =INDEX(A$2:A$100,MATCH(9^99,SEARCH(B2,A$2:A$100)*SEARCH(C2,A$2:A$100))) This will work with Ctrl+Shift+Enter but not ...READ MORE

Dec 23, 2022 in Others by narikkadan
 • 86,360 points • 982 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,730 points • 14,726 views
0 votes
0 answers

Insert multiple rows when range contains specific text

I am trying to have a macro ...READ MORE

Dec 24, 2022 in Others by Kithuzzz
 • 38,000 points • 962 views
0 votes
1 answer

Convert PDF to XLS

To ensure that data import makes sense, ...READ MORE

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

How can i get name box from excel?

You could add a VBA function to ...READ MORE

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

How to create Dropdown list in excel using php

Try this: $objValidation = $objPHPExcel->getActiveSheet()->getCell('B'.$i)->getDataValidation(); $objValidation->setType( PHPExcel_Cell_DataValidation::TYPE_LIST ); $objValidation->setErrorStyle( PHPExcel_Cell_DataValidation::STYLE_INFORMATION ...READ MORE

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

Ionic capacitor app shows only white blank screen in ios

Try it: In capacitor.config.json file, we have ...READ MORE

Sep 21, 2022 in Others by rajatha
 • 7,680 points • 4,905 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
 • 86,360 points • 4,859 views
0 votes
1 answer

What would I have to add to this VBA Code to keep Undo Button working after it runs?

VBA eliminates Excel's undo function. Though it ...READ MORE

Dec 16, 2022 in Others by narikkadan
 • 86,360 points • 1,199 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.