Search results

Try, =TEXT(LEN(A2)-FIND(".",A2&"."),"0;;;")

Try, In D12, formula copied across and down: =SUM(ISNUMBER(OFFSET($C$2,MATCH($C12,$C$3:$C$8,0),6,,25))*(OFFSET($C$2,MATCH($C12,$C$3:$C$8,0)+2,6,,25)=D$11)) Or, =SUM(OFFSET($C$2,MATCH($C12,$C$3:$C$8,0),6,,25)*(OFFSET($C$2,MATCH($C12,$C$3:$C$8,0)+2,6,,25)=D$11)) Remark: please confirm which...

Open a new thread for your new question. This post is closed.

Basically you need 2 Vlookup and Iferror functions for multiple tables lookup & sum, something like: In F2, formula copied down: =SUM(IFERROR(VLOOKUP(A2,A$2:B$15,2,0),0),IFERROR(VLOOKUP(A2,C$2:D$15,2,0),0)) Regards

Or this, result as same as mohamed's formula. =MAX(0,MIN(B5,B$2)-MAX(A5,A$2))

What is your Excel version?

Here is my modified table layout In Cell A16, which have a dropdown list created by Data Validation, for you to select Project A or B or C ....... Then, 1] B17, formula copied across right : =SUM(N(OFFSET($A$2,MATCH($A$16,$A$3:$A$6,0),{2,9,10}+(COLUMNS($B$1:B$1)-1)*24))) 2] B18, formula...

1] You don't know how to handle the basic Offset function. 2] I remove the Sum function and test the Offset function =OFFSET('2020 Project Load(Budgeted)'!$AKQ$12,,(COLUMNS($E$12:E12)-1)*24,,1) And It always return A,0....... , but I think you wanted return 5,5,....... 3] Without any...

Always upload a file to state what you have? and what do you want? with expected results in few example lines. Regards

Then, try this =LOOKUP(9^9,'FROM WEB'!F1:F1000/('FROM WEB'!B1:B1000=B4)/('FROM WEB'!H1:H1000=E4))

You want format date with all CAPS, but you would not using custom number format. You would need to use an in cell TEXT function to enforce UPPER, e.g. in H2 formula copied down: =UPPER(TEXT(F2, "d mmm yy"))

Up load a file to us, saying what you have and what you want? Giving around 10 rows data.

Try, In F4, formula copied down: =LOOKUP(9^9,'FROM WEB'!F:F/('FROM WEB'!B:B=B4)/('FROM WEB'!H:H=E4))

Formula of using IF function+ OR function In cell F2 enter formula and copied down =IF(OR(B2="not interested",B2="voicemail"),A2,"") Or, another way to give you the same result: =IF(OR(B2={"not interested","voicemail"}),A2,"") =IF((B2="not interested")+(B2="voicemail"),A2,"") Regards

This can be used by a simply VLOOKUP function 1] You just set up a Result Table with header as same as the Source Table 2] Criteria of week is in cell M1, you enter number 1 to 33 (This example I enter 17) Then 3] In L3, formula copied across right...

Or, In J6, formula copied across and down: =IF(C6="","",DOLLARDE(C6,60))

Or, try this formula way to remove the 1st character In E2, formula copied down: =0+SUBSTITUTE(D2,LEFT(D2),"") Then, using Column E data for your calculation.

@vletm Yes, with my MS Excel 2021, I can see the @ sign It also work after do you named step by step. I think the formula copy/paste from web by the OP and resulted "#NOME?" , because his Excel version does not support the @ sign .

In addition to our Vletm's explanation. 1] Maybe your Excel do not support this @ sign 2] @ sign is popularly knows as Implicit intersection operator to support Dynamic Array formula method. It can be found in Excel 2019 & Office 365. So, In your K2 formula...

Maybe, In C2, formula copies across right and down: =IFERROR(OFFSET(INDIRECT("'"&$B2&"'!A500"),MATCH($A2,INDIRECT("'"&$B2&"'!$A500:A600"),0)-1,AGGREGATE(15,6,COLUMN($A$1:$AZ$1)/(INDIRECT("'"&$B2&"'!A500:AZ500")="R Mat"),COLUMN(A$1))-1),"")

1] What's wrong with your column B formula results? 2] What's your column B expected results?

This formula work for Excel 2010 and up In B2, formula copied across right and down: =TRIM(MID(SUBSTITUTE(", "&SUBSTITUTE(SUBSTITUTE($A2,", and",",")," and",","),", ",REPT(" ",50)),COLUMN(A1)*50,50))

Try, AC4 formula copied down: =VLOOKUP(LEFT(Basic!U4,FIND(" ",Basic!U4&" ")-1),Setting!$B$2:$D$6,2+AND(ISNUMBER(MATCH(D4,Setting!$J$2:$J$16,0)),ISNUMBER(MATCH(Basic!V4,Setting!$F$2:$F$23,0))),)

Maybe, D8, formula copied across right: =IF(D4>=$D$2,OFFSET($D$6,,MONTH(D4)-MONTH($D$2)),"")

Or, =SUM(COUNTIF(B:B,{"P","OD"}))