Hi Irfan Try this. Hope it helps. Sunny
Hi Irfan I was unable to reproduce the error in Excel 2010 but it occurred in Excel 2013. No idea why a different version should trigger this er...
I had use SUBSTITUTE to cater for all scenarios (I hope I got it all covered) Just in case there is a SPACE in front of a text in cell A1 eg. " Hel...
Hi Forrest You have a good weekend too. Do let us know the outcome. Sunny
Hi Melinda Thanks for your compliments. Sunny
Hi Melinda Glad you liked it. Hope you will find a lot of use with it. Sunny
Try this =IF(ISBLANK(A1),"Del Key",IF(LEN(SUBSTITUTE(A1," ",""))=0,"Space Key","")) It will show Del Key if A1 is deleted with the DELETE key ...
Hi Amy Glad you like the macro. The code LastSrc = ws.Cells(Rows.Count, "B").End(xlUp).Row search for the last row with data in column B. You...
Hi Forrest Try this =IF(AND(ISBLANK(A1)=FALSE,LEN(SUBSTITUTE(A1," ",""))=0),"Space Key","") Sunny
Hi Amy Give this a try. Please note that for any additional sheet to be added and merged, the sheet's name must contain the text "Scrap Report" ...
There is no attachment. You can try this. In cell K10 enter =IF(G10=MAX($G$10:$G$14),2000,0) copy till K14 Hope this helps. Sunny
Hi Andy That cannot be done as Excel will always recalculate whenever a cell value is changed. The best I can think of is to convert your formul...
Hi Ehab In cell C2 enter =IF(COUNTIFS($A$2:A2,A2)>5,"",COUNTIFS($A$2:A2,A2)) Copy down as required. Hope this helps. Sunny
Hi Frans Thanks for your compliments For the helper to work, the data need to be sorted in the correct sequence. This will allow the headers...
Hi Andy I don't quite understand your requirement. Are you saying if you have already used a rate (say column E of the Employee database) for sh...