Recent questions tagged excel

0 votes
1 answer

Concatenate columns using LEFT and RIGHT in EXCEL

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

Parsing from Excel multisheet file: List comprehension between columns

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

In a excel formula I need to create a list of names on one sheet based upon criteria/data of another sheet

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

VBA to protect and unprotect in given range in sheet

Nov 24, 2022 in Others by narikkadan
 • 86,360 points • 3,502 views
0 votes
1 answer

How to keep one variable constant with other one changing with row in excel

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

Prompt message if Excel column has some value in asp.net c#

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

How to look in all folders in directory to change file extensions of excel file?

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

PHPExcel file cannot open file because the file format or file extension is not valid

Nov 24, 2022 in Others by Kithuzzz
 • 38,000 points • 6,834 views
0 votes
1 answer

How can I store the data of an open excel workbook in a collection using BluePrism?

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

How to insert a new row in the specified cell only, of Excel sheet using c#?

Nov 24, 2022 in Others by Kithuzzz
 • 38,000 points • 3,228 views
0 votes
1 answer

How to use Excel VLOOKUP function with words that begin with the letters AB

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

How can i add cells if condition is met

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

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

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

Excel formula to replace or stubstitute only text that starts with a certain letter

Nov 21, 2022 in Others by Kithuzzz
 • 38,000 points • 948 views
0 votes
1 answer

Trouble pasting a Word equation into Excel

Nov 21, 2022 in Others by Kithuzzz
 • 38,000 points • 960 views
0 votes
1 answer

Using "If cell contains #N/A" as a formula condition.

Nov 21, 2022 in Others by Kithuzzz
 • 38,000 points • 983 views
0 votes
1 answer

Excel Formula with Nested IF/LEFT/AND Functions

Nov 21, 2022 in Others by Kithuzzz
 • 38,000 points • 1,521 views
0 votes
1 answer

Generate VCards from Excel using VBA

Nov 21, 2022 in Others by Kithuzzz
 • 38,000 points • 1,323 views
0 votes
1 answer

How to automatically nest rows of an Excel spreadsheet using level values?

Nov 21, 2022 in Others by Kithuzzz
 • 38,000 points • 1,208 views
0 votes
1 answer

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

Nov 21, 2022 in Others by Kithuzzz
 • 38,000 points • 2,347 views
0 votes
1 answer

Cell character counting formula?

Nov 21, 2022 in Others by Kithuzzz
 • 38,000 points • 817 views
0 votes
1 answer

How to fix a circular reference error by if condition in excel file?

Nov 21, 2022 in Others by Kithuzzz
 • 38,000 points • 1,246 views
0 votes
1 answer

Excel - function to convert first letter of each word to uppercase

Nov 21, 2022 in Others by Kithuzzz
 • 38,000 points • 948 views
0 votes
1 answer

Excel: Cross-sheet reference not working

Nov 20, 2022 in Others by Kithuzzz
 • 38,000 points • 9,712 views
0 votes
1 answer

Return empty cell from formula in Excel

Nov 20, 2022 in Others by Kithuzzz
 • 38,000 points • 6,967 views
0 votes
1 answer

How to remove gridlines on select cells in Google Sheets?

Nov 20, 2022 in Others by Kithuzzz
 • 38,000 points • 979 views
0 votes
1 answer

In MS Excel what formula can be used to calculate growth when CAGR for the period is already given?

Nov 20, 2022 in Others by Kithuzzz
 • 38,000 points • 1,537 views
0 votes
1 answer

Convert Word doc, docx and Excel xls, xlsx to PDF with PHP

Nov 20, 2022 in Others by Kithuzzz
 • 38,000 points • 1,962 views
0 votes
1 answer

Saving style of the header of StyleFrame.object to_excel

Nov 20, 2022 in Others by Kithuzzz
 • 38,000 points • 1,045 views
0 votes
1 answer

How can solve this Solver Excel like problem in R?

Nov 20, 2022 in Others by Kithuzzz
 • 38,000 points • 1,420 views
0 votes
1 answer

Pass multiple Excel cell values to Power Automate

Nov 20, 2022 in Others by Kithuzzz
 • 38,000 points • 1,971 views
0 votes
1 answer

Paste special issue, From Excel to Word

Nov 20, 2022 in Others by Kithuzzz
 • 38,000 points • 977 views
0 votes
1 answer

Excel SUMIFS() using string with greater/less than symbols

Nov 20, 2022 in Others by Kithuzzz
 • 38,000 points • 1,072 views
0 votes
1 answer

How to clear contents of an Excel Workbook through vba

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

Spell check an Excel sheet in VBA

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

Adding column to Excel using Apache POI

Nov 19, 2022 in Others by Kithuzzz
 • 38,000 points • 3,046 views
0 votes
1 answer

Sending excel data to Tally

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

How to read single Excel cell value

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

Referencing an Excel file, workbook, worksheet in C#

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

Camel case converter in an excel

Nov 19, 2022 in Others by Kithuzzz
 • 38,000 points • 4,859 views
0 votes
1 answer

Hyperlink changes from # to %20-%20 when clicked in Excel

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

Rails - Export records to downloadable excel file using axlsx gem (Keep MVC)

Nov 19, 2022 in Others by Kithuzzz
 • 38,000 points • 3,023 views
0 votes
1 answer

How to merge columns in Excel but keep data on other columns

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

Nov 17, 2022 in Others by Kithuzzz
 • 38,000 points • 2,513 views
0 votes
1 answer

Is it possible to round to different decimal places in excel based on the range?

Nov 17, 2022 in Others by Kithuzzz
 • 38,000 points • 1,100 views
0 votes
1 answer

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

Nov 17, 2022 in Others by Kithuzzz
 • 38,000 points • 2,615 views
0 votes
1 answer

Excel Consolidate Data not working - Data does not merge

Nov 17, 2022 in Others by Kithuzzz
 • 38,000 points • 2,860 views
0 votes
1 answer

Python Excel Writer (xlswriter) Insert Image from URL

Nov 17, 2022 in Others by Kithuzzz
 • 38,000 points • 2,647 views
0 votes
1 answer

Export many small DataFrames to a single Excel worksheet

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

Is there a way to transfer MSWord numbering bullets to MSExcel column?

Nov 17, 2022 in Others by Kithuzzz
 • 38,000 points • 779 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.