@Dritan The codes are not hidden. You can view them by pressing ALT+F11. The username, password and worksheet name is stored in the Setup sheet ...
Hi Tom I don't have any problem with the formula. Did you copy the formula to the correct cell? Please refer my attachment. If it is not correct...
Thanks Mynda. Glad to know you like it.
Hi Teddy You can try this trick. 1) Create an empty Table with a header (no data) 2) Create a PivotTable from this empty Table with the heade...
Hi Donald I would create a helper column in the Primary database and then do an INDEX/MATCH from the Secondary database. Please refer example at...
It would be best if you can upload your file.
Hi Dritan What you asked for is quite complicated and not fool-proof. I am assuming you know a bit of VBA as you will need to maintain the file ...
Hi Tom Assuming your data is in columns A and B starting from row 1. In cell C2 enter =IF(A2=A1,B1,B2) Copy the formula down column C ...
Hi Tom Excel has a remove duplicate option. From the Data tab select Remove Duplicates, untick Advisor Name and click OK. Hope this helps. ...
Why do you need a macro when you can easily do it just using Excel?
Hi Mariya Just select A2:A4 and then press the Merge & Centre cells icon on the ribbon. Repeat for cells B2:B4, C2:C2 and D2:D4. You can the...
Hi Cory My suggestion is to create a helper column in your data to make the Orig Department (the source of the problem) unique. If you don't lik...
A simple SUMIFS should do the trick Sunny
Hi Suhail I agree with Frans that what you require is difficult to do. You can take a look at my attachment to get some ideas. No guarantee i...
Hi Candid You can try this: In cell D27 enter =IF(D25>50000,15000*0.335,IF(AND((D25-35000)>0,D25<50000),(D25-35000)*0.335,0)) Hope t...