Trending questions in Others

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,477 views
0 votes
1 answer

Python/Openpyxl: change cell A1 in all excel worksheets within a workbook to equal the name of the worksheet tab

You made a mistake when you used ...READ MORE

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

How can I format bytes a cell in Excel as KB, MB, GB etc?

In Excel's formatting features, computations are not ...READ MORE

Nov 15, 2022 in Others by narikkadan
• 86,360 points
2,545 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,143 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,323 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,044 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,221 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
700 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
818 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 251 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
982 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
2,787 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,615 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
836 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,184 views
0 votes
1 answer

Excel formula gives error when write using Apache-poi library in Java

I tested some sample code. The cell ...READ MORE

Nov 5, 2022 in Others by narikkadan
• 86,360 points
2,908 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,413 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,157 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,080 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
810 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,366 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,321 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
2,915 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,255 views
0 votes
1 answer

Convert image (jpg) to base64 in Excel VBA?

Heres a function. Can't remember where I ...READ MORE

Sep 27, 2022 in Others by narikkadan
• 86,360 points
4,552 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,053 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,106 views
0 votes
1 answer

Print chosen worksheets in excel files to pdf in python

In the simplest form: import win32com.client o = win32com.client.Dispatch("Excel.Application") o.Visible ...READ MORE

Sep 24, 2022 in Others by narikkadan
• 86,360 points
4,652 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,322 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
4,760 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,056 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,300 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
831 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
955 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,602 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,643 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
951 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
950 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,326 views
0 votes
1 answer

How to get password of the Amazon aws rds user?

Follow these procedures to update the master ...READ MORE

Mar 9, 2022 in Others by gaurav
• 23,580 points

edited Jun 20, 2023 by Khan Sarfaraz 13,119 views
0 votes
1 answer

Excel how to fill all selected blank cells with text

Do the following to place the same ...READ MORE

Dec 16, 2022 in Others by narikkadan
• 86,360 points
931 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,142 views
0 votes
1 answer

Excel VLOOKUP between two sheets failing

Try this: =VLOOKUP(A2,'1'!$A$2:$E$811,5,0) I altered "1"! $A$2:$A$811 to '1'! ...READ MORE

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

How many is too many columns (safely) in Excel?

I'll just share a story with you. ...READ MORE

Dec 16, 2022 in Others by narikkadan
• 86,360 points
907 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,178 views
0 votes
1 answer

Excel formula that combines MATCH, INDEX and OFFSET

Try this: =INDEX((OFFSET(SheetA!F:F,0,SheetA!A1)),MATCH(SheetB!C4, ...READ MORE

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

HLOOKUP in Excel Formula

If you want to switch up the ...READ MORE

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

How to break area chart in excel

Add an extra row between your areas. READ MORE

Dec 17, 2022 in Others by narikkadan
• 86,360 points
843 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,265 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,157 views