Recent questions tagged excel-formula

0 votes
1 answer

How to remove data within a multi-line cell that comes after a few line breaks

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

Excel formula returning multiple values according to two criterias

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

Automatically adding the date/time to a cell when another cell is updated AND clearing it when this cell is empty

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

In =RTD(ProgID,Server,String1,[String2],...), passing array for String2, String3 and so on

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

Need a formula that will pull the specific value that matches a unique code from a set of data and produce another table of that specific data

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

Excel VBA If range.value = something then fills Columns G

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

Calculate 3 days back but skipping weekends

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

Calculate the rank based on the two or Three criteria

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

Split and group values in excel

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

How to multi level sort an array in excel, using formulas? I am aware about the way, using SORT button on DATA tab

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

VBA code to take some string components, search them inside a workbook and replace the components with the cell addresses found

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

Vlookup error when lookup value cell has been populated with formula

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

Excel, AVERAGEIFS, Date discrepancy

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

Excel function to dynamically SUM UP data based on matching rows and columns

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

Excel VBA userform paste text in expanded format (not just to one cell)

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

Excel: Is it possible to reorder the data in 2 columns to match up if they have a certain number of characters / a string in common?

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

EXCEL: Auto number rows until value in cell

Jan 20, 2023 in Others by Kithuzzz
 • 38,000 points • 1,509 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,522 views
0 votes
1 answer

Excel If duplicate agree paste the value

Jan 19, 2023 in Others by Kithuzzz
 • 38,000 points • 1,282 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,906 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,590 views
0 votes
1 answer

Find and adjacent cell with criteria

Jan 17, 2023 in Others by Kithuzzz
 • 38,000 points • 1,315 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,248 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,559 views
0 votes
1 answer

Insert formula in multiple excel sheets

Jan 17, 2023 in Others by Kithuzzz
 • 38,000 points • 1,097 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,602 views
0 votes
1 answer

Count the sum of difference between two cells

Jan 15, 2023 in Others by Kithuzzz
 • 38,000 points • 1,402 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,232 views
0 votes
1 answer

Excel - External link to multiple workbooks

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

Excel - Stack Data based in Condition

Jan 14, 2023 in Others by Kithuzzz
 • 38,000 points • 1,325 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,288 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 • 992 views
0 votes
1 answer

Delimiters in Excel VBA Regex Patterns, filter something but not others

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

Crawling through multiple excel files, match and copy data to master file

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

Look up value in dictionary and put the value in cell - Excel

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

Excel VBA - Using Error Traps where Another Routine is Called

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

Find the serial number with criteria

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

How to improve VBA Code for Monte Carlo Simulation?

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

Textjoin with adjacent headers and rows with a twist

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

Why this Excell formula that take the value of a cell and concatenate to the value or another cell is not working?

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

How to make lambda function working on excel365?

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

Is there a way to test a formula result in excel and type it only once, all within one cell and not using a user defined function?

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

Filter/Extract a text from excel sheet having similar values

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

VBA code for dragging down contents of a cell

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

VBA How to extract the date and time of arrival of a answered email

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

Map-like array function in Excel?

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

Excel pace formula gives incorrect answers

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

Want to merge two column that contains mobile number into one based on the condition that mobile no should be 10 digits

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

FilterOn and DynamicCriteria allowed values for MS Graph Excel Filter Criteria

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

Date format conversion in Excel

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