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 • 567 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
 • 63,600 points • 429 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,331 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 • 735 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 • 767 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 • 942 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,996 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,863 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 • 472 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 • 854 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,973 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,573 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 • 894 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 • 568 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 • 611 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,654 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,554 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,464 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 • 732 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,835 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,504 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 • 563 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,380 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 • 602 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 • 552 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 • 2,002 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 • 530 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,462 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 • 719 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 • 781 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,490 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 • 454 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 • 772 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,305 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,469 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 • 602 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 • 677 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,093 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,702 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 • 716 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 • 917 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,963 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 • 522 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 • 521 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 • 516 views
0 votes
1 answer

Is there a way to search the iOS app store online?

Apple finally made it possible to just use ...READ MORE

Sep 21, 2022 in Others by rajatha
 • 7,680 points • 4,075 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,064 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,099 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,593 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 • 421 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.