Recent content by Serene

Hi everyone, I have built a worksheet where I have calculated the Profit & Loss and Cash Floor for a model store for 5 years (ie, Year 1, Year 2, Year 3, Year 4, Year 5) What I need to do is to decide how many stores I should open each year. For each store, each year, I will use the same model...

Hi everyone, I have created a calculated field in Pivot Table - "EffectiveBonus". This field is based on the "Bonus" field in the main table and will pro-rate bonuses if minimum tenure if not fulfilled. However, it appears that the sum of "EffectiveBonus" field remains the same as that of the...

Dear everyone, I have the following data which I imported from MS Access Position Score QuantumIncrease GM 1 1.5% GM 2 2.0% GM 3 4% S. Mgr 1 2% S. Mgr 2 2.5% S. Mgr 3 4.5% ... As the Position is repeated...

Hi Harry, Thanks for the suggestion. I am not very proficient in writing subroutines. But actually I would like to system to generate the random PIN and if it exists to generate the next one. How do I ensure that all new pins generated is unique? Would you mind to show me all of the code...

Hi everyone, I would like to generate some PINs for my end users. However, these PINs must be of certain length (6 numeric) and they must not be the same as numbers already generated before. I have a list of numbers that have been generated previously. Please advise how these criteria can be...

Hi everyone, I have an Excel sheet that contains staff and their bonus amount etc. Can I do a mail merge from Excel to MS Word? If so, can someone here enlighten me how it can be done. Many thanks in advance Serene

Hi Faseeh, Thanks for the quick reply. I was not able to move but I found I could re-type. (Am using Excel for Mac 2011) Appreciate the great help. Serene

Hi guys, I am creating a pivot table to tabulate the results of a company wide appraisal. On the rows I have the Job Grades: General Manager, Manager, Supervisor, Staff. On the columns, I have- Excellent, Good, Satisfactory, Fair Poor. I am applying count to the values. However, it...

Dear Hui Thanks, I am trying out pivot table but am encountering some sorting problems which I will post another topic Cheers Serene

Hi everyone, I have a sheet where I have rows containing staffid, Job grade and appraisal score. I would like to analyse the tendency of the scoring by the different job grade. To do this, first I would like to recompile the table so I have the no of people by Job Grade who have been graded...

Hi Ian, I am using some spreadsheets via data from ERP system. Are you asking for technical know how n creating the dashboard or the methods by which replenishment is tracked? There are various ways to do so from the simplistic to the complex. Currently, we use stock turns and sell through...

Hi guys Thanks for your reply. The formula works if I reference the end date to a cell instead of typing in the actual end date inside the formula. This is indeed a very useful function. Thanks again! Serene

Hi everyone, I would like to count the number of months from a field "Join Date" to a field "Resign Date". Both fields are in text. In this case, how can I calculate the number of months. Can I also allow a decimal for the number of months. Thank you in advance Serene

Hi Kaushik,Hui, Thanks for your helpful and speedy response. I have managed to incorporate your suggestions. For the sorting, I realised I could create a custom sort (at the child level) so that I can determine the order, for example, Manager, Supervisor, staff Thanks again, you all have...

Hi everyone, I have imported some data from Access. I have some columns that I wish to sort. For eg, (1) Location (2) Job Grade (Staff, Supervisor, Manager, Senior Manager, etc) (3) Dept I would like to sort in the following order - By Location - By Dept - By Job Grade The location...