Please help me convert simple formula for auto increment with condition - =Arrayformula(if(D2:D="",,countifs(D2:D, D2:D, row(D2:D), "<="&row(D2:D)))) I'v
I don't know a lot in Excel but I want to add Multiple prefixes in Excel and let them loop until the number of cells ends. I used this Formula, but it picks the
how can I add rows in excel according to the cell value (as per example below). https://i.stack.imgur.com/q8MQG.png i want to add column D if column A contain '
Microsoft has announced many new array functions (https://techcommunity.microsoft.com/t5/excel-blog/announcing-new-text-and-array-functions/ba-p/3186066), inclu
I have a sheet where column B contains a list of Folders in R:\Jobs. The folder name is also the 'Job Name'. I use VBA to create a formula in Column F that look
Wordy title but I was interviewed on this question, couldn't derive the answer and really would love to better understand array usage in excel. Question: You ha
I have two columns in excel, one with a date and one with a rating 'low, medium, high'. I'm trying to write a formula to put in a third column that checks: If A
Suppose we have 2 cells, one contains zero and the other is empty, see the range A2:A3 in the figure: If they pass a FILTER we get two zeros as a result, see t
I have a list of unsigned 32-bit unsigned integers that actually are supposed to represent 32-bit signed integers. For example 62714 = binary 1111010011111010 =
I wish to find a way to find the three largest AuM values for each category and the Owner: I found the n-th largest AuM per category using the Large-formula co
I am looking for a formula to Count Specific date in Text String. My answers work with words, but if I use wildcards it doesn't work. W33 is the sample text bel
I have two sheets; Sheet1 & Sheet2 and want to link the format from A1 Sheet1 to A1 Sheet2, i.e. Sheet2 A1 should match the formatting of Sheet1 A1 I don't
ID Value Valid MAX Group3 2 NO 8 Group3 8 YES 8 Group1 4 YES 4 Group4 2 NO 1 Group4 3 NO 1 Group4 1 YES 1 Group1 2 YES 4 Group1
Let's say I wanted to find the average number of calls per day. Normally, I can use the formula =COUNT(A2:A15)/SUM(1/(COUNTIF(A2:A15,A2:A15))) for the table bel
I have two tables on two sheets - let's say tblFruits1 and tblFruits2. Both have a column "Name". Apple - for example - exists on both lists. The lists might ha
I am trying to figure out a formula that will count each row in a range, that contains any cell that is not empty. For example Item 1|Item 2|Item 3 Cat 1
Given this rule to follow: And I have some value to check from this: Where cell AA727 is a result of some calculations which I already formatted into a number
I have the above cells and i want to substract each individual row . i.e. 137.61-137.61, 132.88-270.49 and print each one of the results on the respective row
I want to count the results of a FILTER in excel. Usually I do something like IF( IFERROR( SUM( FILTER( range, condition)
I have a grid which lists the Period (Start - End), and a list of Downtimes. The downtimes are then sorted (to ensure chronological order based on the start tim