Search results

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...

Hi everyone, I have imported some data from Access. However, I discovered some text field needs to be converted to numbers. How can I do this in the easiest way? Thanks in advance Serene

Dear Guys I was able to get the correct answer with all of the above formulas. There was a formatting problem. Thanks everyone! Serene

Thanks guys for the advice. Actually, the table concerned is a summation of all the sheets in the workbook. I tried the alternative formula but the result is still the same. I will try to upload the worksheet Thanks Serene

Hi SP Pls advise how I can upload? Sorry I am a newbie, Cheers Serene

Thanks for the quick response! However, the formula is not giving me the correct value. It is actually returning a larger sum when I filter. Is there any settings needed for the filter? Thanks Serene

Dear Guys I have a table with filters by dept. Please advise if I can create a function based on the filter that is being created. For eg, if the filter is dept 1, then the subtotal and total will change automatically. Likewise for selecting all. Thanks in advance Serene

Hi, I have a sheet with various departments and their sales budget figures. Dept| Sales| Budget$ However, I need to group them by Division and also by Financial Group(either or depending on user of the sheet) The Division is according to staff assigned and Financial Group is for purpose...

Hi everyone, Apologies if this appears to be a newbie question: I am have an Excel workbook where I keep the salaries of staff. Each sheet represents a dept. Inside every sheet, I keep the Rank of Staff, Names, Title, Salary, Bonuses, etc The data is kept by row and the fields are in the...

Hi everyone, I am creating a workbook which will be updated by myself and another staff. However, there are certain confidential information (salary) which can only be viewed by me. How can I hide these cells? Any suggestions will be greatly appreciated. Thanks Serene

Dear Narayan, Thank you for your suggestion. I managed to use 1 - General Manager, 2 - Manager, etc in the drop down list, then in the vlookup, I use the truncate function to strip take only the numeric value. For eg, =VLOOKUP(C2,A10:H14,LEFT(B2)+3) Cheers Serene