Search results

...off topic... Hi @Niranjanrajrishi Please use Code tags, I have informed you twice via PM. Regards,

Thanks JJV, Duly noted :) Blessings to you too Sir

Hi, You can also check this add in: https://www.rondebruin.nl/win/addins/rdbmerge.htm User friendly for merging multiple files into one, but this needs to be run every time you want to combine the files. Regards,

Hi to all, One more: =COUNTIF($A$3:$A$19,ROW(A1)) Regards,

Hi Sam, Try this {array formula} in BB14: =IFERROR(INDEX($V$8:$AZ$8,,SMALL(IF(($V$10:$AZ$45=BB$13)*($A$10:$A$45=$BB$12),COLUMN($V$1:$AZ$1)-21),ROW(A1))),"") {array formula needs to be entered with a key combination of Ctrl+Shift+Enter} Regards, Ops: didn't noticed Chihiro replied a few...

Hi to all, Congrats Bosco, welcome to the team. Thanks Hui for the news. Regards,

Hi, Just add another condition: =IF(O6="","NA",IF((O6-M6)>15,"YES","NO")) Bold part updated. Regards,

Hi, One more way with Find & Replace option: 1) Select your range 2) Press Ctrl+H (Find & Replace) 3) Find what: *salespeople/ 4) Leave blank Replace with field 5) Replace all Regards,

Hi Asad, Your question is not clear and there is no date less than today's date i.e 30th Nov 2017. Please upload file with manually entered expected results. Regards,

Hi Tripp, Or you can use the COUNTIFS like this: =COUNTIFS(A1:A10,">=1/1/2015",A1:A10,"<=31/12/2015") Regards,

Hi Naresh, Replace your LEFT & RIGHT formula with SUBSTITUTE like Bosco did: =SUM(INDEX(ROW(INDIRECT(SUBSTITUTE(A1," to ",":"))),)) Regards,

Hi Chihiro, Pleasure to see your posts, welcome to the team and many Congratulations... Thanks Hui for the news. Regards,

Hi all, A very simple and friendly way to rename multiple files with Macro (Excel Batch Renamer) https://strugglingtoexcel.com/2014/01/01/excel-batch-renamer/ Regards,

Happy Birthday :)

Hi, Will this work? =SUM(COUNTIF(INDIRECT("N7:O7"),{"A","UV","PV","R","TR"})) Regards,

Hi Alan and all, Good day... If you have 2010+ you can use Aggregate function with just enter. in D20: =IFERROR(AGGREGATE(15,6,1/($C$11:$ACP$11=$B20)*$C$9:$ACP$9,COLUMNS($A$1:A$1)),0) in D33: =IFERROR(AGGREGATE(14,6,1/($C$11:$ACP$11=$B33)*$C$9:$ACP$9,COLUMNS($A$1:A$1)),0) copy down and...

Hi, One more: =LOOKUP(2,1/(SEARCH(list!$A$1:$A$5,A2)),list!$A$1:$A$5) Regards,

Hi Dinesh, Glad it helped... Thanks for the feedback, keep visiting. Regards,

Hi Dinesh, If you are okay with formula based solution, try this in cell U2 and copy down: =IF(COUNTIFS(R2,"TP -*",G2,"<>L3_MIGRATION /",G2,"<>L1_CORE /",G2,"<>L3_WG1_BDF /",G2,"<>L3_USR_ERP /"),"FUT",IF(COUNTIFS(R2,"<>TP -*",G2,"<>L3_MIGRATION /",G2,"<>L1_CORE /",G2,"<>L3_WG1_BDF...

Genius.... Never would've thought in a million years.

Happy Birthday Haseeb bhai :)

Hi, Try this then: =IFERROR(IF(SEARCH("Metropolitan",VLOOKUP(A1,$F$1:$G$14,2,0)),1000,""),"") Regards,

Hi Sajjid, You can also use EDATE function: =EDATE(B1,-1)-1 -1 is for 1 month back -1 is for 1 day back. Format the cell as required. Regards,