Recent questions tagged excel-formula

0 votes
1 answer

EXCEL: Count case sensitive criteria in one column if meets criteria in another column

Feb 24, 2023 in Others by Kithuzzz
 • 38,000 points • 1,631 views
0 votes
1 answer

How to compare 2 cells with delimited items in each and output the difference in items?

Feb 23, 2023 in Others by narikkadan
 • 86,360 points • 1,700 views
0 votes
1 answer

Finding the minimum values from different columns according to the criteria and multiplying by another column

Feb 23, 2023 in Others by narikkadan
 • 86,360 points • 1,873 views
0 votes
1 answer

Excel Count unique values beetween 2 columns

Feb 23, 2023 in Others by narikkadan
 • 86,360 points • 1,663 views
0 votes
1 answer

Get column index from table header in excel

Feb 23, 2023 in Others by narikkadan
 • 86,360 points • 1,909 views
0 votes
1 answer

How to split column into two

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

Count duplicate words within string and remove if it occurs less than 10 times

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

TODAY() function not working in Microsoft Excel

Feb 20, 2023 in Others by narikkadan
 • 86,360 points • 3,132 views
0 votes
1 answer

Excel - count if multiple words are in a cell

Feb 20, 2023 in Others by narikkadan
 • 86,360 points • 1,526 views
0 votes
1 answer

Tableau For Loop a String

Feb 20, 2023 in Others by narikkadan
 • 86,360 points • 1,546 views
0 votes
1 answer

Dropdown list circular reference Excel/VBA

Feb 18, 2023 in Others by Kithuzzz
 • 38,000 points • 1,530 views
0 votes
1 answer

Concatenate or TextJoin Same Cell Multiple Times based on Value in another Cell?

Feb 18, 2023 in Others by Kithuzzz
 • 38,000 points • 1,986 views
0 votes
1 answer

Highlight closest cell value in a table

Feb 18, 2023 in Others by Kithuzzz
 • 38,000 points • 1,507 views
0 votes
1 answer

How to reference an excel sheet by variable

Feb 16, 2023 in Others by narikkadan
 • 86,360 points • 1,730 views
0 votes
1 answer

Function to filter excel table data in to a new dataset based on value defined in another table

Feb 16, 2023 in Others by narikkadan
 • 86,360 points • 2,221 views
0 votes
1 answer

VLOOKUP to find weeknumber

Feb 16, 2023 in Others by narikkadan
 • 86,360 points • 2,044 views
0 votes
1 answer

How can I automatically formulate a column while adding values ​to another? EXCEL

Feb 16, 2023 in Others by narikkadan
 • 86,360 points • 1,406 views
0 votes
1 answer

Concatenate only upper case letters?

Feb 16, 2023 in Others by Kithuzzz
 • 38,000 points • 1,677 views
0 votes
1 answer

Asset Write off calculation Automation

Feb 14, 2023 in Others by narikkadan
 • 86,360 points • 1,146 views
0 votes
1 answer

Excel: Get text between two characters

Feb 14, 2023 in Others by narikkadan
 • 86,360 points • 1,570 views
0 votes
1 answer

OR and IF function for multiple values

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

Ignore empty filter criteria in SUMPRODUCT formula

Feb 13, 2023 in Others by Kithuzzz
 • 38,000 points • 2,264 views
0 votes
1 answer

Excel formula to get certain cell if the value is between 2 numbers

Feb 11, 2023 in Others by narikkadan
 • 86,360 points • 2,346 views
0 votes
1 answer

Excel: Count distinct numerical values if string condition matches

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

Generate number by using Dynamic array (w/o VBA)

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

Index and Match multiple matches

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

Google Spreadsheet/ Excel - how to find matching values in column A, having necessary values in column M

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

Looking to create a conditional statement in excel

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

Selecting a value of a table in Excel

Feb 7, 2023 in Others by Kithuzzz
 • 38,000 points • 1,261 views
0 votes
1 answer

Is there an efficient way to do this excel function

Feb 7, 2023 in Others by Kithuzzz
 • 38,000 points • 1,583 views
0 votes
1 answer

Newbie needs Excel suggestions with a simple script

Feb 7, 2023 in Others by Kithuzzz
 • 38,000 points • 1,519 views
0 votes
1 answer

How to split only one column to multiple rows while copying rest of the columns along the way?

Feb 6, 2023 in Others by Kithuzzz
 • 38,000 points • 1,435 views
0 votes
1 answer

Autofill macro to autofill dates up to 31 days regardless of the month

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

How to build a custom column formula in Power query that will retrieve Image and load it to Excel to display that image from the specified column

Feb 5, 2023 in Others by Kithuzzz
 • 38,000 points • 2,642 views
0 votes
1 answer

How to return the last n number of values corresponding to a specific category?

Feb 5, 2023 in Others by Kithuzzz
 • 38,000 points • 1,314 views
0 votes
1 answer

Excel Vlookup function to map duplicate and get the max occurence value

Feb 4, 2023 in Others by Kithuzzz
 • 38,000 points • 2,002 views
0 votes
1 answer

Formula to count if a text is written in a cell

Feb 4, 2023 in Others by Kithuzzz
 • 38,000 points • 1,427 views
0 votes
1 answer

Power query to return true / false if multiple columns are either = or null

Feb 3, 2023 in Others by Kithuzzz
 • 38,000 points • 5,750 views
0 votes
1 answer

How can this code be modified to increase the number of months instead of days?

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

Find value in column where running total is equal to a certain percentage

Feb 3, 2023 in Others by Kithuzzz
 • 38,000 points • 1,428 views
0 votes
1 answer

Extract Text after Second Underscore in Excel from right side

Feb 3, 2023 in Others by Kithuzzz
 • 38,000 points • 3,259 views
0 votes
1 answer

Get instances of rows in excel for a particular group

Feb 2, 2023 in Others by Kithuzzz
 • 38,000 points • 1,527 views
0 votes
1 answer

How can I add a wildcard to my if formula (that also contains an or condition)

Feb 2, 2023 in Others by Kithuzzz
 • 38,000 points • 1,623 views
0 votes
1 answer

How to show a row in excel if there is a X

Feb 2, 2023 in Others by Kithuzzz
 • 38,000 points • 1,226 views
0 votes
1 answer

Defining last nine rows of data as range to copy values and transpose paste into another worksheet

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

Excel links keep crashing

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

What is the shortest formula in excel to covert text date format e.g. 17 Jan, 2023 into regular date format like 1/17/2023?

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

How to sum the next n non-empty cells in LibreOffice Calc?

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

Excel: How to set a dropdown list cell to fetch list of strings from an API JSON response

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

How to expend the code to transfer data from one spreadsheet to another based on multiple criteria

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