Most answered questions in Others

0 votes
1 answer

How to draw wedge shape with outline in Excel VBA?

According to https://learn.microsoft.com/en-us/office/vba/api/excel.adjustments: Because each adjustable shape has a ...READ MORE

Dec 25, 2022 in Others by narikkadan
 • 63,620 points • 328 views
0 votes
1 answer

How do I merge multiple excel files to a single excel file

You copy a worksheet from before each ...READ MORE

Dec 24, 2022 in Others by narikkadan
 • 63,620 points • 623 views
0 votes
1 answer

Compare Two columns If 2 cells are Matching

Although I find it difficult to follow ...READ MORE

Dec 24, 2022 in Others by narikkadan
 • 63,620 points • 555 views
0 votes
1 answer

Windows 10 IE is not working with old VBA code

I discovered the answer. The issue was ...READ MORE

Dec 24, 2022 in Others by narikkadan
 • 63,620 points • 1,332 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
 • 63,620 points • 250 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
 • 63,620 points • 290 views
0 votes
1 answer

How to change two different date format into single date format in excel

With data in A2, in B2 enter: =IF(ISNUMBER(A2),A2,DATE(LEFT(A2,4),MID(A2,6,2),RIGHT(A2,2))) and apply your format ...READ MORE

Dec 24, 2022 in Others by narikkadan
 • 63,620 points • 905 views
+1 vote
1 answer

Excel or Google formula to count occurrences of an 8-digit number within a text string

To match an eight-digit number, you may ...READ MORE

Dec 24, 2022 in Others by narikkadan
 • 63,620 points • 652 views
0 votes
1 answer

How to create exponential growth in excel over a year

To find an interest rate that will ...READ MORE

Dec 24, 2022 in Others by narikkadan
 • 63,620 points • 322 views
0 votes
1 answer

In excel 365 how to subtract values sequentially but skip empty cells

Try the following formula in C4 and ...READ MORE

Dec 24, 2022 in Others by narikkadan
 • 63,620 points • 497 views
0 votes
1 answer

How to add column filters to Excel worksheet using XLWINGS?

Call the API property to activate the autofilter: import xlwings ...READ MORE

Dec 23, 2022 in Others by narikkadan
 • 63,620 points • 1,755 views
0 votes
1 answer

Calculating accuracy within excel

Format the cell in Col C as ...READ MORE

Dec 23, 2022 in Others by narikkadan
 • 63,620 points • 1,846 views
0 votes
1 answer

Excel there was a problem sending the command to the program

Solution: You go to Regedit -> HKEY_CLASSES_ROOT\Excel.Sheet.12\Shell\Open : change ...READ MORE

Dec 23, 2022 in Others by narikkadan
 • 63,620 points • 471 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
 • 63,620 points • 386 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
 • 63,620 points • 335 views
0 votes
1 answer

Unable to convert text to Numbers

According to the comments, there may be ...READ MORE

Dec 23, 2022 in Others by narikkadan
 • 63,620 points • 445 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,620 points • 196 views
0 votes
1 answer

Excel to CSV with UTF8 encoding

Use of Google Spreadsheet is a straightforward ...READ MORE

Dec 23, 2022 in Others by narikkadan
 • 63,620 points • 580 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
 • 63,620 points • 272 views
0 votes
1 answer

IfError with else, does this function exist in Excel?

Next to IFERROR(), there also is the ISERROR() function, which ...READ MORE

Dec 23, 2022 in Others by narikkadan
 • 63,620 points • 351 views
0 votes
1 answer

Excel: How to use LEFT function on a Date formatted cell?

Use this: =TEXT(E1,"hh:mm:ss") READ MORE

Dec 19, 2022 in Others by narikkadan
 • 63,620 points • 372 views
0 votes
1 answer

Is there a limit on an Excel worksheet's name length?

The file format would allow worksheet names ...READ MORE

Dec 19, 2022 in Others by narikkadan
 • 63,620 points • 4,369 views
0 votes
1 answer

Excel: Group rows and add minimum and maximum from two different columns within the group

You can accomplish your goal with Power ...READ MORE

Dec 19, 2022 in Others by narikkadan
 • 63,620 points • 665 views
0 votes
1 answer

Excel cannot open the file because the file format or file extension is not valid - PHP Maatwebsite

Try this: if (ob_get_length() == 0 ) { ...READ MORE

Dec 19, 2022 in Others by narikkadan
 • 63,620 points • 1,007 views
0 votes
1 answer

How do you populate a google sheets/excel column with cells from a column in another sheet in the same document?

You have two options on chronology: sheet-by-sheet =QUERY({Sheet1!X:Z; Sheet2!X:Z; ...READ MORE

Dec 19, 2022 in Others by narikkadan
 • 63,620 points • 1,198 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
 • 63,620 points • 341 views
0 votes
1 answer

How to sum column until current row?

Use the Header as your starting point: =SUM(Table1[[#Headers],[Num ...READ MORE

Dec 19, 2022 in Others by narikkadan
 • 63,620 points • 593 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,620 points • 225 views
0 votes
1 answer

Finding the English definition of a word in VBA

In the event that the VBA Research ...READ MORE

Dec 19, 2022 in Others by narikkadan
 • 63,620 points • 534 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
 • 63,620 points • 285 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,620 points • 425 views
0 votes
1 answer

How to change the default number format in Excel?

Excel Tips, Learn Excel \ Raghu R Setting ...READ MORE

Dec 17, 2022 in Others by narikkadan
 • 63,620 points • 5,685 views
0 votes
1 answer

Return blank cell only if referred cell is blank, but return aging if date is entered

Try this: =IF(ISBLANK(AC2),"",TODAY()-AC2) The TODAY  function automatically refreshes based ...READ MORE

Dec 17, 2022 in Others by narikkadan
 • 63,620 points • 1,293 views
0 votes
1 answer

Read .xls file with Python pandas read_excel not working, says it is a .xlsb file

Try: import openpyxl xls = pd.ExcelFile('data.xls', engine='openpyxl') df = pd.read_excel(xls) Recently, ...READ MORE

Dec 17, 2022 in Others by narikkadan
 • 63,620 points • 1,410 views
0 votes
1 answer

Hiding the formula bar in Excel for a specific file

No, you cannot. Unfortunately, altering the CustomUI file ...READ MORE

Dec 17, 2022 in Others by narikkadan
 • 63,620 points • 443 views
0 votes
1 answer

How to freeze the =today() function once data has been entered

Don't enter this formula: =TODAY() Instead use  Ctrl + ; This will put a "frozen" ...READ MORE

Dec 17, 2022 in Others by narikkadan
 • 63,620 points • 1,034 views
0 votes
1 answer

Stop power query from loading to excel sheet

You can just delete the worksheets created ...READ MORE

Dec 17, 2022 in Others by narikkadan
 • 63,620 points • 3,948 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,620 points • 194 views
0 votes
1 answer

Adding formulas to excel spreadsheet using python

You can create any formula that Excel ...READ MORE

Dec 17, 2022 in Others by narikkadan
 • 63,620 points • 1,169 views
0 votes
1 answer

Convert xls to csv without any data changes

Here are the 3 solutions I have ...READ MORE

Dec 16, 2022 in Others by narikkadan
 • 63,620 points • 672 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,620 points • 314 views
0 votes
1 answer

Filter sumproduct formula based on array

Use ISERROR(MATCH()): =SUMPRODUCT(--(ISERROR(MATCH(Sales[Area];Exceptions[Area];0)));Sales[Quantity];Sales[Price per unit]) --(ISERROR(MATCH(Sales[Area];Exceptions[Area];0))) will return 1 if the ...READ MORE

Dec 16, 2022 in Others by narikkadan
 • 63,620 points • 775 views
0 votes
1 answer

Embed picture in outlook mail body excel vba

The image needs to be added and ...READ MORE

Dec 16, 2022 in Others by narikkadan
 • 63,620 points • 4,615 views
0 votes
1 answer

Compare 2 columns in same excel sheet in pandas

Try this: import pandas as pd import numpy as ...READ MORE

Dec 16, 2022 in Others by narikkadan
 • 63,620 points • 2,180 views
0 votes
1 answer

Excel data validation list

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

Dec 16, 2022 in Others by narikkadan
 • 63,620 points • 406 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,620 points • 215 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,620 points • 266 views
0 votes
1 answer

Unhide all Hidden Excel Columns Without Individual Iteration?

I discovered that the best way to ...READ MORE

Dec 16, 2022 in Others by narikkadan
 • 63,620 points • 622 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,620 points • 374 views
0 votes
1 answer

Mat-icon doesn't export in excel sheet?

Icons have their own coding you can ...READ MORE

Dec 15, 2022 in Others by narikkadan
 • 63,620 points • 788 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.