Search results

Try, [E3]: =IF(B3<>"",IF(ISNUMBER(SEARCH("cable",B3))+ISNUMBER(SEARCH("tray",B3))=1,"Meter","No"),"")

Please be noted that all answers based on the Post #1 attached file. Any addition question different from that will become a new question. Ae per the forum rule: "one post one question". You should need post a new thread for your new question. This post is closed.

Then, use =IF(B5<>"", IF(AND(ISNUMBER(SEARCH({"patel","native"},B5))),"No","Yes"),"") or, =IF(B5<>"", IF(ISERR(SEARCH("patel",B5)*SEARCH("native",B5)),"Yes","No"),"")

You are welcome. Regards Bosco

If you accept helper columns as per your attachment. Then, try this, 1] Helper column_1, H3 formula copied down: =IF(COUNTIFS(B$3:B3,B3,C$3:C3,C3)=1,IF(COUNTIFS(C$3:C3,C3)=1,MAX(H$2:H2)+1,0),"") 2] Helper column_2, I3 formula copied down: =IF(H3=0,MAX(I$2:I2)+1,0) 3] Formula result, J3...

Or, In E5, formula copied down: =IF(B5<>"", IF(AND(ISNUMBER(SEARCH({"patel","native"},B5))),"No","Yes"),"")

Try, In B2, revised formula (with highlighted red) copied across right: =IFERROR(FILTERXML("<a><b>"&SUBSTITUTE(SUBSTITUTE(SUBSTITUTE($A2,"2022 - ","2022___"),"2023 - ","2023___"),"___","</b><b>")&"</b></a>","//b["&COLUMN(A$1)+INT((COLUMN(A$1)-1)/2)+1&"]"),"")

Try, In B1, enter formula: =IFERROR(MATCH(1,1*(A1={"a","b","c","d"}),0),0) or =IFERROR(MATCH(1,1*(A1={"a","b","c"}),0),0)

Try this single formula solution for your Excel 2019. Get list of unique brands if Group is "com" and Type is "Pack". 1] Criteria of Group "com" in cell F1 2] Criteria of Type "Pack" in cell F2 3] List of Unique Brand F4, formula copied down...

You give us only one (1) source data and 11 formula results as per above. In order avoid to any misunderstanding. Please write down "What is your expected result?" for us to work. Thanks

Sorry visible error

Hi, @Peter Bartholomew, Please see your attached image: The OP repeated Requirement, saying: Need space Before and After " /" But He used the sign of " /" So, What is the Requirement?o_O " /" or " / " ? Regards

Please stick on your post#1 file. Other than that, we consider it is a new question. This post is closed. Regards

=FILTER($J$3#,YEAR($J$3#)=0+Table!$C$11) =YEAR($J$3#) return a list of year in NUMBER e.g. ........2022,2022 But =Table!$C$11 return a TEXT e.g. "2022" So, Add a 0, enforce TEXT convert to NUMBER, the formula become>> =0+Table!$C$11 return a NUMBER e.g. 2022 Then...

Try, =FILTER($J$3#,YEAR($J$3#)=0+Table!$C$11) Regards

=N("Text") return 0, e.g., =N("A") return 0 =N(Number) return number, e.g., =N(5) return 5 Adopt it for the purpose of the Testing upper row data "Text or Number?" and for copied down formula used. Regards

Try, 1] In "Balance" G4, formula copied down: =IF((DAY(B4)=1)+(A4-N(A3)=1)+(B4-N(B3)<0),E4-F4,G3+E4-F4) 2] In "Lead time" H4, formula copied down: =IF((DAY(B4)=1)+(A4-N(A3)=1)+(B4-N(B3)<0),1,B4-B3)

Or, you can google and check for "Conditional Formatting"

You are welcome :)

Try to work out your expected result in manual to your post #1 file. Don't use any formula please. Then, post back your file to us for check. Thanks

Please Google and look into Vlookup or Index+Match function for your case, which are the LOOKUP family. Remark: LOOKUP family has, Lookup, Vlookup, Hlookup, Index+Match, Offset, Indirect+Match and the newest Xlookup for Excel 2021 and office365. Regards

Good catch, please find the revised as in: 1] In K2 revised formula copied down, and copied formula to column O: =IF(ROW($A1)<=SUM($C$2:$C$13),INDEX($B$2:$B$13,INT(MOD((ROW($A1)-1)/I$2,COUNTIF($B$2:$B$13,"?*")))+1),"") 2] G2, formula not required array entry. 3] Please see revised file

This look like a homework assignment of you. However, this is a way how to reach your target. 1. Set up a Database format Lookup table include Look up range (name of employee) and the Result range (time). 2. Set up a Database format Criteria and Expected output, of which in single criteria...

If B4:B13 have formulae and contain formula blank. In G2, try to use this copy down formula instead: =IF(ROW(A1)<=SUM($C$2:$C$13),INDEX($B$2:$B$13,MOD(ROW(A1)-1,COUNTIF($B$2:$B$13,"?*"))+1),"")

Try to set up as per attached file. 1] Give criteria of "Min. repeated number of times" :1, 3 and 9 2] Result of "repeated number of 1" in G2 formula: =IF(ROW(A1)<=SUM($C$2:$C$13),INDEX($B$2:$B$13,MOD(ROW(A1)-1,COUNTA($B$2:$B$13))+1),"") 3] Result of "repeated number of 3" in K2 formula and...