Trending questions in Others

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
• 63,600 points
529 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
• 63,600 points
730 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,260 points
2,305 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
746 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
• 63,600 points
691 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
• 63,600 points
836 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
• 63,600 points
451 views
0 votes
1 answer

Cannot detect strikeout data from excel using apache poi

You must first obtain the RichTextString, then ...READ MORE

Dec 10, 2022 in Others by narikkadan
• 63,600 points
896 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
• 63,600 points
1,947 views
0 votes
1 answer

How do I get an Excel range using row and column numbers in VSTO / C#?

Use: int countRows = xlWorkSheetData.UsedRange.Rows.Count; int countColumns = xlWorkSheetData.UsedRange.Columns.Count; object[,] ...READ MORE

Nov 17, 2022 in Others by narikkadan
• 63,600 points
1,815 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
• 63,600 points
595 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
• 63,600 points
551 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
• 63,600 points
711 views
0 votes
1 answer

How to use an increment an average formula by more than one row in excel?

I believe OFFSET makes it simpler, for ...READ MORE

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

How do delete an specific page in a word document using Excel VBA?

Check the code below. I eliminated the ...READ MORE

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

ExcelJS wrapText in Table columns

I implemented a workaround by detecting what ...READ MORE

Sep 30, 2022 in Others by narikkadan
• 63,600 points
3,905 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
• 63,600 points
551 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
• 63,600 points
1,807 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
• 63,600 points
534 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
• 63,600 points
558 views
0 votes
1 answer

What is the better API to Reading Excel sheets in java - JXL or Apache POI

Here are the things where both APIs ...READ MORE

Oct 9, 2022 in Others by narikkadan
• 63,600 points
3,452 views
0 votes
1 answer

How to return a result from a VBA function

You must associate the value with the ...READ MORE

Nov 4, 2022 in Others by narikkadan
• 63,600 points
2,325 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
• 63,600 points
492 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
• 63,600 points
1,953 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
• 63,600 points
435 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
• 63,600 points
750 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
• 63,600 points
1,418 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
• 63,600 points
678 views
0 votes
1 answer

Excel VSTO - cm/inches to point conversion not accurate

You may convert centimetres to points in ...READ MORE

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

Excel Lookup function for text

Use a simple VLOOKUP() function like: =VLOOKUP(E2,$A$2:$B$6,2,FALSE) You can also use ...READ MORE

Dec 13, 2022 in Others by narikkadan
• 63,600 points
580 views
0 votes
1 answer

How to remove values from drop-down if value deleted from validation list

Try this code: Private Sub Worksheet_Change(ByVal Target As ...READ MORE

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

How to modify Powerpoint Chart ChartData by Excel VBA

Example: Code: Set pptApp = GetObject(, "PowerPoint.Application") Set pptPres = ...READ MORE

Oct 16, 2022 in Others by narikkadan
• 63,600 points
3,061 views
0 votes
1 answer

Excel/Python: How to group names alphabetically section wise such that each group has equal number of Alphabets?

Here is a flimsy answer. The number ...READ MORE

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

Calculate the mean from excel sheet for specific rows

Generate a list for each means you ...READ MORE

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

Excel If Functions with Multiple Conditions

Use this: =IF(C3<=0,"Green",IF(C3<500,"Silver",IF(C3<=1499,"Gold","Platinum"))) I added <=0 just in case you have ...READ MORE

Dec 13, 2022 in Others by narikkadan
• 63,600 points
508 views
0 votes
1 answer

Integrating address verification based on pincode and vice versa for Indian Pincode

The other website you pointed to () ...READ MORE

Dec 13, 2022 in Others by narikkadan
• 63,600 points
502 views
0 votes
1 answer

Add user-defined function (UDF) to built-in category in Excel

Use Application.MacroOptions This example adds a user-defined macro ...READ MORE

Dec 15, 2022 in Others by narikkadan
• 63,600 points
411 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,260 points
2,080 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
• 63,600 points
2,031 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
• 63,600 points
3,605 views
0 votes
1 answer

Excel VBA code window opened cropped and can't view code

So it turns out after some online ...READ MORE

Dec 13, 2022 in Others by narikkadan
• 63,600 points
475 views
0 votes
1 answer

Excel is saying zero is not equal to zero

It is a floating point error. Increase ...READ MORE

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

Excel number format: scale number by ten thousand or hundred thousand

In the MSExcel spreadsheet, Right Click on ...READ MORE

Oct 18, 2022 in Others by narikkadan
• 63,600 points
2,877 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
• 63,600 points
1,538 views