Recent questions tagged excel

0 votes
1 answer

How to add if this cell = 0 skip and go next

Jan 20, 2023 in Others by Kithuzzz
 • 38,000 points • 1,239 views
0 votes
1 answer

VBA Export as PDF and Save to Location with name as per a Cell in the worksheet

Jan 20, 2023 in Others by Kithuzzz
 • 38,000 points • 3,617 views
0 votes
1 answer

Comparing data in Excel

Jan 20, 2023 in Others by Kithuzzz
 • 38,000 points • 1,338 views
0 votes
1 answer

EXCEL: Auto number rows until value in cell

Jan 20, 2023 in Others by Kithuzzz
 • 38,000 points • 1,524 views
0 votes
1 answer

How do I get it to select a single row based on the value?

Jan 20, 2023 in Others by Kithuzzz
 • 38,000 points • 1,511 views
0 votes
1 answer

Blazor - ClosedXml - excel cannot open the file beacause the file format or extension is not valid

Jan 20, 2023 in Others by Kithuzzz
 • 38,000 points • 2,841 views
0 votes
1 answer

How to extract text before the last "," in excel formula?

Jan 20, 2023 in Others by Kithuzzz
 • 38,000 points • 1,532 views
0 votes
1 answer

VBA copy data from other file - problem with file name change

Jan 20, 2023 in Others by Kithuzzz
 • 38,000 points • 1,444 views
0 votes
1 answer

VBA Code Help - Need to add a line for each missing date and copy data from cells below

Jan 20, 2023 in Others by Kithuzzz
 • 38,000 points • 1,413 views
0 votes
1 answer

Using VBA Workbook_SheetChange only works in one direction

Jan 20, 2023 in Others by Kithuzzz
 • 38,000 points • 2,423 views
0 votes
1 answer

Excel If duplicate agree paste the value

Jan 19, 2023 in Others by Kithuzzz
 • 38,000 points • 1,293 views
0 votes
1 answer

How can a column be set to display multiple spaces and tabs (white space) in a cell?

Jan 19, 2023 in Others by Kithuzzz
 • 38,000 points • 1,408 views
0 votes
1 answer

How to make a auto counter to print pages

Jan 19, 2023 in Others by Kithuzzz
 • 38,000 points • 1,385 views
0 votes
1 answer

Trying to run different macros based on value of cell in a range

Jan 19, 2023 in Others by Kithuzzz
 • 38,000 points • 1,508 views
0 votes
1 answer

How do I use the Indirect Function in Excel VBA to incorporate the equations in a VBA Macro Function

Jan 19, 2023 in Others by Kithuzzz
 • 38,000 points • 2,326 views
0 votes
1 answer

Formula to remove every middle name in a cell in Excel

Jan 19, 2023 in Others by Kithuzzz
 • 38,000 points • 1,922 views
0 votes
1 answer

VBA Help on Splitting Worksheet

Jan 19, 2023 in Others by Kithuzzz
 • 38,000 points • 1,381 views
0 votes
1 answer

Underlining Headers from WPF Datagrid when printing using Excel print function

Jan 19, 2023 in Others by Kithuzzz
 • 38,000 points • 1,286 views
0 votes
1 answer

Excel VBA search based on cell values into folders and sub-folders to get the file path and data

Jan 19, 2023 in Others by Kithuzzz
 • 38,000 points • 3,176 views
0 votes
1 answer

Excel convert multiple columns to dataset based on unique timestamp

Jan 17, 2023 in Others by Kithuzzz
 • 38,000 points • 1,599 views
0 votes
1 answer

Find and adjacent cell with criteria

Jan 17, 2023 in Others by Kithuzzz
 • 38,000 points • 1,333 views
0 votes
1 answer

How to sum the value of 2 rows with vlookup by only using 1 formula?

Jan 17, 2023 in Others by Kithuzzz
 • 38,000 points • 1,575 views
0 votes
1 answer

Consolidate orders to single row counting number of orders and averaging the result

Jan 17, 2023 in Others by Kithuzzz
 • 38,000 points • 1,263 views
0 votes
1 answer

Spill formula to lookup matching row data in one sheet with column data in another and evaluate corresponding cells

Jan 17, 2023 in Others by Kithuzzz
 • 38,000 points • 1,571 views
0 votes
1 answer

Conditions in Excel: skip cells with dates without a year

Jan 17, 2023 in Others by Kithuzzz
 • 38,000 points • 1,346 views
0 votes
1 answer

Insert formula in multiple excel sheets

Jan 17, 2023 in Others by Kithuzzz
 • 38,000 points • 1,107 views
0 votes
1 answer

Is it possible to get data from a webpage in real-time to an excel file?

Jan 17, 2023 in Others by Kithuzzz
 • 38,000 points • 1,619 views
0 votes
1 answer

Modifying CSV files from a local folder-VBA

Jan 17, 2023 in Others by Kithuzzz
 • 38,000 points • 2,030 views
0 votes
1 answer

Getting a specific value from a dictionary in a function

Jan 17, 2023 in Others by Kithuzzz
 • 38,000 points • 1,555 views
0 votes
1 answer

Horizontal Loop

Jan 15, 2023 in Others by Kithuzzz
 • 38,000 points • 1,449 views
0 votes
1 answer

Count the sum of difference between two cells

Jan 15, 2023 in Others by Kithuzzz
 • 38,000 points • 1,418 views
0 votes
1 answer

Is there a hierarchy inferring algorithm available in python?

Jan 15, 2023 in Others by Kithuzzz
 • 38,000 points • 1,268 views
0 votes
1 answer

How to set formula in Excel with POI?

Jan 15, 2023 in Others by Kithuzzz
 • 38,000 points • 2,044 views
0 votes
1 answer

I Get "object required" error when using getElementByID

Jan 15, 2023 in Others by Kithuzzz
 • 38,000 points • 2,367 views
0 votes
1 answer

How to check if a cell is empty in a range variable?

Jan 15, 2023 in Others by Kithuzzz
 • 38,000 points • 2,233 views
0 votes
1 answer

PermissionError: [WinError 32] The process cannot access the file because it is being used by another process: (Open Excel File) in Python

Jan 15, 2023 in Others by Kithuzzz
 • 38,000 points • 13,561 views
+1 vote
1 answer

Automatically move an entire row of reference cell when one cell is moved or manipulated

Jan 15, 2023 in Others by Kithuzzz
 • 38,000 points • 1,245 views
0 votes
1 answer

Error populating email body from word documents

Jan 15, 2023 in Others by Kithuzzz
 • 38,000 points • 3,287 views
0 votes
1 answer

Using Visual Basic to pull data from within a range to use in an Excel function

Jan 14, 2023 in Others by Kithuzzz
 • 38,000 points • 1,408 views
0 votes
1 answer

Excel VBA move pivot item to last position

Jan 14, 2023 in Others by Kithuzzz
 • 38,000 points • 1,733 views
0 votes
1 answer

Paste a value from a drop-down list

Jan 14, 2023 in Others by Kithuzzz
 • 38,000 points • 1,483 views
0 votes
1 answer

Excel - External link to multiple workbooks

Jan 14, 2023 in Others by Kithuzzz
 • 38,000 points • 1,199 views
0 votes
1 answer

VBA Insert row instead of copy

Jan 14, 2023 in Others by Kithuzzz
 • 38,000 points • 1,758 views
0 votes
1 answer

Excel - Stack Data based in Condition

Jan 14, 2023 in Others by Kithuzzz
 • 38,000 points • 1,338 views
0 votes
1 answer

Color specific cell in an xlsx with python

Jan 14, 2023 in Others by Kithuzzz
 • 38,000 points • 3,483 views
0 votes
1 answer

Insert Excel rows for each x in adjacent country columns to prepare Oracle Calendar Event Coverage uploadsheet

Jan 14, 2023 in Others by Kithuzzz
 • 38,000 points • 1,302 views
0 votes
1 answer

How do I run a VBA Sub routine continuously when working in a Workbook and not only when the Workbook is opened?

Jan 14, 2023 in Others by Kithuzzz
 • 38,000 points • 1,486 views
0 votes
1 answer

EXCEL-Function to find how many people does the oldest female live with

Jan 13, 2023 in Others by Kithuzzz
 • 38,000 points • 1,447 views
0 votes
1 answer

How to validate values entered in a multiline Excel cell?

Jan 13, 2023 in Others by Kithuzzz
 • 38,000 points • 1,002 views
0 votes
1 answer

How can I scrape a excel file from a website and divide it in different parts?

Jan 13, 2023 in Others by Kithuzzz
 • 38,000 points • 1,561 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.