excel-formula - List Questions

EN VI

Posts (0)

Questions (10)

Best Solution Bot

How to formula if with multi conditions in Excel?

This works ... =IF(A2="","",IF(AND(B2="IN",C2

Tags: excel, excel-formula, excel-2010

Best Solution Bot

Excel - How to insert blank rows between data using dynamic array formula?

You could try using EXPAND() function: =TOCOL(EXPAND(A1:A5,,2,"")) Or, =TOCOL(EXPAND(A1:A5,,MAX(A1:A5)/2,""))

Tags: excel, excel-formula, dynamic-arrays

Best Solution Bot

Excel Conditional Formatting for cells that re equal to 0 formats also blank cells?

You can use this formula for the red part: =(D1=0)*(D1"") It returns true if the cell isn't empty and the value = 0. (Btw: like this the condition is international ... you could use AND or ISNUMERIC...

Tags: excel, excel-formula, conditional-formatting

Best Solution Bot

Excel - Trying to get names from a box on the right to automatically appear in another box when a different box has a value in it?

Well, if I have understood correctly, the following formula should work as per the given conditions: • Formula used in cell C21 =LET(_Data, C3:C19,_Names, $J3:$J7,FILTER(_Names,1-ISNA(XMATCH(TEXTBEF...

Tags: excel, excel-formula, formula

Best Solution Bot

Excel formula problem with sumifs with multiple search values in one if?

If I have understood correctly, from your OP then you would need a formula like this: • Formula used in cell E5 =SUM(SUMIFS(D5:D24,C5:C24,SEQUENCE(ROWS(UNIQUE(C5:C24)),,100,100))) In German Versio...

Tags: excel, excel-formula

Best Solution Bot

Excel - Wondering how to fill a cell with multiple criteria from other ranges?

Try something along the lines of: • Formula used in cell C12 =LET(_N, $B12:$B25, IF(TAKE(1-ISNA(XMATCH(TEXTAFTER($J2:$J25,"-"),C2:C11)),ROWS(_N)),_N,"")) Or, not using the B12:B25 as reference to...

Tags: excel, excel-formula

Best Solution Bot

search within certain columns, but output all columns - excel?

Try something along the lines of using TAKE() function , with reference to my last answer: =LET( w,WRAPROWS(TOCOL(Sheet1:Sheet2!A:C,1),3), FILTER(w,BYROW(ISNUMBER(SEARCH("foo",TAKE(w,,2))...

Tags: excel, excel-formula

Best Solution Bot

Excel - WORKDAY.INTL formula not working as intended?

WORKDAY.INTL() is working as intended. In WORKDAY.INTL() function 1 represents a non-workday and 0 represents a workday. That said, 29th Feb'24 is Thursday and you have made it non-working day, hence...

Tags: excel, excel-formula, wps

Best Solution Bot

EXCEL - Listing top 20 items from a range?

Another way as commented above: =LET(α, A2:A368, TAKE(UNIQUE(SORTBY(α,COUNTIF(α,α),-1)),20)

Tags: excel, excel-formula

Best Solution Bot

Excel - Find minimum value in 2nd column of month in first column?

Try using the following formula: =MIN(TOCOL(B2:B7/(TEXT(E2,"me")=TEXT(A2:A7,"me")),2)) Or, Using AGGREGATE() =AGGREGATE(15,6,B2:B7/(TEXT(E2,"me")=TEXT(A2:A7,"me")),1) Or using MINIFS() =MINIFS(B...

Tags: excel, excel-formula, array-formulas

Pinned Posts

Top 5 Best High CPM Ads Networks For Publishers In 2023

Tags: ads, Publishers, Ads Networks

HawkHost Coupon 2023 – Hawk Hosting Discount Code Up to 40% Lifetime Update Every Day

Tags: Server, host, cloud