Search results

If you data is soughed, then the formula in the attached sheet will help. The Distributor Name's names are not consistent across the sheet, hence there is a discrepancy with the number you have typed & with the formula I have. Please change the names to a single spelling then the formula will work.

Thanks somendra will try it out.

yes, you got it right, it will be basically for a week or 15 days.

Thanks, Somendra, Can we have the dates in the user form instead of drop down. I don't need the current weeks date, all the dates in my sheet should appear in the user form.

Hi Luke, Thanks for the excel, what I was looking out is an user form where the employees select their names from the drop down list & besides the dates they enter the numbers of hours worked & press save & the data is saved in the main sheet where I have put the names & dates. Its a VBA user...

Hi, Happy new year to all of you. I am beginner in VBA, I need help from the experts to create this user form. The user form should appear in the userform tab The names from colum A should be the drop down list in the userform name field In the userform only the current weeks dates should...

Even I guessed so, Khalid.

Hi, Just check if this is what you are looking for.

If this is a error log, then you can show if the problem is being repeated, & who had solved it previously, this will help to track the efficiency of the resolving officer.

@ Ratan Bhushan, Can you explain what do you want to show in the chart or heat map, the target column is blank for most of the columns. In 7OCR you mentioned If goes up - Green. What should go up, the total or a number in any coulmn. what is the criteria.

Thanks, Shrivallabha, this is what I was looking for.

yes @ Narayan

@ Shrivallabha If SD=12/5/2014 [History] and ED=12/15/2014[Future] then what will be the expected result? Future If SD=12/5/2014 [History] and ED=12/6/2014[Present] then what will be the expected result? Present If SD=12/6/2014 [Present] and ED=12/15/2014[Future] then what will be the...

@ Narayan StartDate = Past , EndDate = Today Present StartDate = Today , EndDate = Today Present StartDate = Future , EndDate = Today It is not possible,as the start date cant be in future & end date today StartDate = Past , EndDate = Past History StartDate = Today , EndDate = Past It is not...

@ Narayan, There wont be any blanks in the dates.

Hi All, need you help in solving the multiple if or conditions A1: Start Date (SD) B1: End Date (ED) C1: to have the result based on the following conditions. There are 3 conditions: If SD or ED is less than today "History" If SD or ED is greater than today "Future" If SD or ED is equal to...

for A & D apply the conditional format (highlight duplicate value) separately. Filter the blanks in column E & delete the highlighted cells in A & D. Please upload the file it this is not what you are looking for.

check this. When you have too many data in an chart, it is always better to show the relationship b/w 2 charts with the same color (light & dark). EX: In this chart as there are 3 years & all the 3 years has Target & Achievement. Show the Target in 3 different colors & the 3 Achievement in the...

Please use this formula in q26, if there is a negeative value, then it will become 0. =IF(L26-M26-N26-O26-R26-S26<=0,0,L26-M26-N26-O26-R26-S26) The formula for 1st & 2nd question is already in your excel, what do you want.

@ Dackson, If you want a shorter formula & if you are ready to use a helper column, see my attached file. A column is a helper column in which I have entered number 1-27 & used the SMALL formula is used to get the values from smallest to largest.

@ Dackson, please check this link http://chandoo.org/wp/2009/08/19/excel-pivot-tables-tutorial/

It can be done with the help of pivot table.

Check this out, reference is given to the entire column from B:F , so when you add in more serial no.s the data will be automatically update in the next sheet. If you add any more column say G,H,I, then in the formula just replace F with the last column of your data.

Hope this is what you are looking for

@ Harry0 There is no formula involved in it, it is a simple pivot table & it is not possible to edit an pivot table. If you want any changes please do the same in the main sheet & refresh the pivot table. The changes are reflected in the pivot table. Please surf chandoo website for pivot table...