Trending questions in Others

0 votes
1 answer

Excel VBA advanced filter to exclude data

Try this: Sub advanced_filter() Dim ...READ MORE

Dec 10, 2022 in Others by narikkadan
 • 86,360 points • 1,964 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,628 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,147 views
0 votes
1 answer

HTTP Error 403.14 - Forbidden - The Web server is configured to not list the contents of this directory

Try keeping this into your web config ...READ MORE

Feb 11, 2022 in Others by Rahul
 • 9,690 points • 14,705 views
0 votes
1 answer

How to get the JasperReports into Excel format with proper alignment

Remove at least one parameter: exporter.setParameter(JRXlsExporterParameter.IS_COLLAPSE_ROW_SPAN,Boolean.TRUE) Note that JRXlsExportParameter is deprecated the correct ...READ MORE

Sep 21, 2022 in Others by narikkadan
 • 86,360 points • 5,149 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,409 views
0 votes
1 answer

How to insert a picture into Excel at a specified cell position with VBA

Try this: With xlApp.ActiveSheet.Pictures.Insert(PicPath) With ...READ MORE

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

How to add Indian Rupee Currency symbol in Google Spreadsheet

To apply a custom currency format to ...READ MORE

Nov 8, 2022 in Others by gaurav
 • 23,580 points • 3,053 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,879 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,110 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,236 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,047 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,405 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,651 views
0 votes
1 answer

Exporting HTML Table to Excel Extension Issues

In my application, I'm experiencing a similar ...READ MORE

Nov 14, 2022 in Others by narikkadan
 • 86,360 points • 2,752 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,232 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 • 4,971 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,065 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,176 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,615 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,299 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,345 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,382 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,169 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,457 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,535 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,268 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 • 841 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 • 960 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,341 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 • 4,931 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,746 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,190 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 • 338 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 • 944 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,520 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 • 929 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,244 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,565 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,228 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,005 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 • 2,870 views
0 votes
0 answers

VBA SQL Connection to Excel from Word returns no records

Trying to figure out how to read ...READ MORE

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

Standard deviation only for data that meets two conditions in Excel

I would say: =STDEV.S(IF((A2:A11="A")*(B2:B11="Z1"),C2:C11,"")) ...READ MORE

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

How to remove or delete comments in excel worksheet?

Get a range, then clear comments: Worksheets("MySheet").Activate ActiveSheet.UsedRange.ClearComments I ...READ MORE

Dec 11, 2022 in Others by narikkadan
 • 86,360 points • 1,314 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 • 3,950 views
0 votes
1 answer

Excel concatenate function with multiple conditions

Use this : =TEXTJOIN(", ";TRUE;IF((Table69[Spec]=$B$1)*(Table69[Sl ...READ MORE

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