Recent questions tagged excel

0 votes
1 answer

DATEDIF Excel - output incorrect

Dec 28, 2022 in Others by Kithuzzz
 • 38,000 points • 816 views
0 votes
1 answer

How to Convert nested JSON into excel in nodejs

Dec 28, 2022 in Others by Kithuzzz
 • 38,000 points • 3,423 views
0 votes
1 answer

Excel Formula - Calculating Total Percentage

Dec 28, 2022 in Others by Kithuzzz
 • 38,000 points • 623 views
0 votes
1 answer

Imitate Excel style gradient color effect (red, yellow, green) in gt::data_color()

Dec 28, 2022 in Others by Kithuzzz
 • 38,000 points • 867 views
0 votes
1 answer

Ms-access vba - read from excel and also update that excel

Dec 28, 2022 in Others by Kithuzzz
 • 38,000 points • 1,737 views
0 votes
1 answer

Excel file download using java - Error : File is corrupted

Dec 28, 2022 in Others by Kithuzzz
 • 38,000 points • 2,902 views
0 votes
1 answer

Excel COUNTIFS with merged cell

Dec 26, 2022 in Others by Kithuzzz
 • 38,000 points • 1,546 views
0 votes
1 answer

Dynamic chart range using INDIRECT: That function is not valid (despite range highlighted)

Dec 26, 2022 in Others by Kithuzzz
 • 38,000 points • 1,262 views
0 votes
1 answer

Excel formula to convert EST date time into IST date time?

Dec 26, 2022 in Others by Kithuzzz
 • 38,000 points • 991 views
0 votes
1 answer

Convert excel file to jpg in c#

Dec 26, 2022 in Others by Kithuzzz
 • 38,000 points • 1,695 views
0 votes
1 answer

Excel Connect data points with line is DISABLED

Dec 26, 2022 in Others by Kithuzzz
 • 38,000 points • 2,287 views
0 votes
1 answer

How can I count the rows with data in an Excel sheet?

Dec 26, 2022 in Others by Kithuzzz
 • 38,000 points • 866 views
0 votes
1 answer

Division formula in excel

Dec 26, 2022 in Others by Kithuzzz
 • 38,000 points • 580 views
0 votes
1 answer

What is the character code for new line break in excel

Dec 26, 2022 in Others by Kithuzzz
 • 38,000 points • 915 views
0 votes
1 answer

Activating a Specific Cell in Excel Using VBA Results to Error 400

Dec 26, 2022 in Others by Kithuzzz
 • 38,000 points • 855 views
0 votes
1 answer

Can I insert a file into Excel without creating a reference?

Dec 26, 2022 in Others by Kithuzzz
 • 38,000 points • 661 views
0 votes
1 answer

How to avoid using Select in Excel VBA

Dec 25, 2022 in Others by Kithuzzz
 • 38,000 points • 841 views
0 votes
0 answers

Excel VBA: Open Hyperlinks in a loop and copy paste download link in a sheet

Dec 25, 2022 in Others by Kithuzzz
 • 38,000 points • 1,617 views
0 votes
1 answer

How to find the last row in a column using openpyxl normal workbook?

Dec 25, 2022 in Others by Kithuzzz
 • 38,000 points • 7,463 views
0 votes
1 answer

Calculating the week number of a year in Excel

Dec 25, 2022 in Others by Kithuzzz
 • 38,000 points • 804 views
0 votes
1 answer

How to subtract date only format "mm/dd" in excel?

Dec 25, 2022 in Others by Kithuzzz
 • 38,000 points • 1,149 views
0 votes
1 answer

Get random value in the range of plus/minus 10% of a cell value in Excel

Dec 25, 2022 in Others by Kithuzzz
 • 38,000 points • 1,191 views
0 votes
1 answer

Excel countif entire row in a table

Dec 25, 2022 in Others by Kithuzzz
 • 38,000 points • 1,215 views
0 votes
1 answer

How to Clear Table Style in Office Scripts?

Dec 25, 2022 in Others by Kithuzzz
 • 38,000 points • 1,081 views
0 votes
1 answer

How to draw wedge shape with outline in Excel VBA?

Dec 25, 2022 in Others by Kithuzzz
 • 38,000 points • 886 views
0 votes
0 answers

Insert multiple rows when range contains specific text

Dec 24, 2022 in Others by Kithuzzz
 • 38,000 points • 739 views
0 votes
1 answer

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

Dec 24, 2022 in Others by Kithuzzz
 • 38,000 points • 1,222 views
0 votes
1 answer

Compare Two columns If 2 cells are Matching

Dec 24, 2022 in Others by Kithuzzz
 • 38,000 points • 886 views
0 votes
1 answer

Windows 10 IE is not working with old VBA code

Dec 24, 2022 in Others by Kithuzzz
 • 38,000 points • 2,136 views
0 votes
1 answer

How to use relative names in Excel VBA

Dec 24, 2022 in Others by Kithuzzz
 • 38,000 points • 675 views
0 votes
1 answer

Using excel I need to open PPT and create ".gif" image of a ."pdf" and save it

Dec 24, 2022 in Others by Kithuzzz
 • 38,000 points • 704 views
0 votes
1 answer

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

Dec 24, 2022 in Others by Kithuzzz
 • 38,000 points • 1,939 views
+1 vote
1 answer

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

Dec 24, 2022 in Others by Kithuzzz
 • 38,000 points • 1,368 views
0 votes
1 answer

How to create exponential growth in excel over a year

Dec 24, 2022 in Others by Kithuzzz
 • 38,000 points • 941 views
0 votes
1 answer

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

Dec 24, 2022 in Others by Kithuzzz
 • 38,000 points • 1,153 views
0 votes
1 answer

How to add column filters to Excel worksheet using XLWINGS?

Dec 22, 2022 in Others by Kithuzzz
 • 38,000 points • 2,764 views
0 votes
1 answer

Calculating accuracy within excel

Dec 22, 2022 in Others by Kithuzzz
 • 38,000 points • 2,854 views
0 votes
1 answer

Excel there was a problem sending the command to the program

Dec 22, 2022 in Others by Kithuzzz
 • 38,000 points • 1,021 views
0 votes
1 answer

How to get the excel file name / path in VBA

Dec 22, 2022 in Others by Kithuzzz
 • 38,000 points • 780 views
0 votes
1 answer

How to connect ms excel-2007 with mysql.

Dec 22, 2022 in Others by Kithuzzz
 • 38,000 points • 695 views
0 votes
1 answer

Unable to convert text to Numbers

Dec 22, 2022 in Others by Kithuzzz
 • 38,000 points • 884 views
0 votes
1 answer

Non-exact Vlookup with multiple search criteria - Microsoft Excel

Dec 22, 2022 in Others by Kithuzzz
 • 38,000 points • 588 views
0 votes
1 answer

Excel to CSV with UTF8 encoding

Dec 22, 2022 in Others by Kithuzzz
 • 38,000 points • 1,302 views
0 votes
1 answer

Excel - VLOOKUP vs. INDEX/MATCH - Which is better?

Dec 22, 2022 in Others by Kithuzzz
 • 38,000 points • 798 views
0 votes
1 answer

IfError with else, does this function exist in Excel?

Dec 22, 2022 in Others by Kithuzzz
 • 38,000 points • 1,455 views
0 votes
1 answer

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

Dec 19, 2022 in Others by Kithuzzz
 • 38,000 points • 1,016 views
0 votes
1 answer

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

Dec 19, 2022 in Others by Kithuzzz
 • 38,000 points • 6,433 views
0 votes
1 answer

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

Dec 19, 2022 in Others by Kithuzzz
 • 38,000 points • 1,465 views
0 votes
1 answer

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

Dec 19, 2022 in Others by Kithuzzz
 • 38,000 points • 1,855 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?

Dec 19, 2022 in Others by Kithuzzz
 • 38,000 points • 1,987 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.