Search results

Happy Birthday SM Dada. Have a wonderful year. Regards,

Hi Thomas, Good Day... See if this works: =IF(COUNTBLANK(B2:D2)>2,"No Data",IF(AND(OR(B2="",C2="",D2=""),OR(B2=C2,D2=C2,D2=B2)),"Okay",IF(OR(ISTEXT(B2),ISTEXT(C2),ISTEXT(D2)),"Okay","Not Okay"))) Regards,

Hi Nebu, Congrats and well-done. Regards,

Hi, Not quite :) COUNTIF(s) requires a range weather it is normal range or a Table. We can not wrap list of dates with YEAR function within COUNTIF due to nature of COUNTIF. However SUMPRODUCT allows this: =SUMPRODUCT(SIGN(YEAR(Table1[Entry Date])=2016)) Regards,

Hi Mithil, Good Day... Another way is to make a simple table, and then use a simple VLOOKUP: =IFERROR(IF(VLOOKUP(A1,$F$1:$G$14,2,0)="Metropolitan",1000,""),"") See the attached sample. Regards,

Hi Marc & SirJB7 Glad to see your wishes. Blessings to you Masters.

Hi Marc, Well done, Congrats. Keep sharing and keep helping us. Regards,

Hi Sachin, Many thanks for the wishes and remembrance. Take Care & Regards,

Hi, One more: =IF(SUM(COUNTIF('Table 1'!A2,"*"&{"PW","DW","SPE"}&"*")),'Table 1'!A2,"") Regards,

Hi, Or the simple SUMIF: =SUMIF(Sheet2!$A$1:$A$2,A1,Sheet2!$B$1:$B$2) Regards,

Hi, Other than what posted above, you can remove the times by using Find & Replace option, then apply sort, see the following steps: 1) Select your range 2) Go to Find & Replace (Ctrl+H) 3) Find what: single space and * 4) Leave blank the Replace with filed 5) Replace all 6) Change the format...

Hi Chihiro (Pivot King), Congrats for another speedy k. Regards,

Hi John, Check this: =INDEX(Rate!$D$7:$J$23,MATCH(F5,Rate!$D$7:$D$23,0),MATCH(H5,Rate!$D$6:$J$6,0)) Red Part updated. Regards,

Hi, If there is no blank, you can use this version too: A2:A14 supposed your range, enter this in B2 for most common value: =INDEX(A2:A14,MODE(MATCH(A2:A14,A2:A14,0))) and this for count: =COUNTIF(A2:A14,B2) or combined version: =INDEX(A2:A14,MODE(MATCH(A2:A14,A2:A14,0)))&" - Count...

Hi SirJB7 Actually, when I joined this forum (in July-14) I followed and saw your various posts but never seen you online since yesterday. So I am glad to see you back in action (I mean posting). :) Regards,

Welcome back SirJB7, Glad to see you back in action.

Hi Sam, SUM is not necessary :) 1) =IFERROR((($N115+$N116)/$N120)*$J114,0) 2) =IFERROR(($N115+$N116)/$N120*$J114,0) Regards,

Hi, Please check the option "Which files" and try selecting xl? It should work Regards,

Hi, Use RDBMerge add-in, it is very useful / fast and easy to use: https://www.rondebruin.nl/win/addins/rdbmerge.htm Before merging, change your sheet names temporarily to something like: Cash Cash2 Cash3 Then in the field "Merge all files with a name that contains" enter the following name...

Hi, Formula way to highlight if there are 4 digit number and cell does not contain advance paid: =AND(LOOKUP(9^9,MID(A1,ROW(INDIRECT("1:"&LEN(A1)-3)),4)+0),COUNTIF(A1,"<>*advance paid*")) Regards,

Hi Rahul, See this link for code and other alternative ways: https://excel.tips.net/T008843_Printing_Odd_or_Even_Pages.html Regads,

Hi, Text to column should work if you do this way: Next > Next > Date > MDY > Finish Regards,

Hi @Sreehari Good day... Pivot is best for this, but if you really want to do this with formulas, see the attached example using @AhmedAbbas file. Regards,

Hi Haris, Good day... So many views and no reply that means you have missed something or your query is not crystal clear to anyone. I suggest to get some idea from here: http://chandoo.org/wp/excel-dashboards/ You will find so many links for dashboard just google "chandoo excel dashboard"...

Hi, I think it is because of the nature of IFERROR function. Regards,