• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. A

    How to get date from text string

    I have a long list of a text containing "mmm dd yyyy hh:mm:ss". e.g. May 21st 2013 21:42:04 Mar 22nd 2013 21:38:18 Dec 23rd 2013 21:37:15 Oct 1st 2013 21:35:48 Jan 1st 2013 21:32:37 Mar 3rd 2013 21:32:02 Apr 2nd 2013 21:29:51 Jun 20th 2013 21:28:19 Feb 21st 2013 21:25:30 I want to...
  2. A

    How to check double dates in a list?

    Hi all, I am working on a project and srucked on this- If I have a list of dates as mentioned bellow. And there are some dates which are entered two-three times. But we dont know which they are, How to check those dates in given list? e.g- 27-Jan-12 12-Feb-12 01-Mar-12 03-Apr-12...
  3. A

    Ideas for a Six Sigma project

    Hi team, This might be quite different (or stupid) question I'm asking on this forum but I need some help to make more improvements in my project. I am working on a Six Sigma project, subject is 'SHIFT & OVERTIME MANAGEMENT'. off-course its completely EXCEL based. I am done with the 'shift...
  4. A

    How to neglect zero's in chart?

    Hi team, I have a chart based on a run rate table. the table shows percentage of current over. so there are some numbers as well as zero's. Suppose the game is in 9th over & run rate is 15.71 but the series goes down as 10th & next all overs have number 0 in the table. The series should be...
  5. A

    Highlight the cell range by selecting dropdown

    Hi all excel gurus, I have created an Shift Time Manager worksheet where we will come to know about the exact work flow and the work completion flow. I have uploaded two files, please read the notes and help me. 1st) I need your help in this-...
  6. A

    =COUNTIFS formula in Excel 2003

    Hi team, We have a worksheet where we collate the data by using COUNTIFS formula. It's working with excel 2007 but not in 2003. Do we have any option or any another formula which will work like COUNTIFS in excel 2003? In which we can give more criteria to count the numbers. Thanks! -Atul...
  7. A

    Validate cells which are allready having formula.

    Hi team, I have a work allocation sheet, which we use to allocate the work across the team. I have used =INDEX formula to distribute the work in available agents. Now some procedure has changed. suppose column A is for file numbers & B is for agent names. B1 has agent name "John" (which is...
  8. A

    How to hide / unhide column by using formula

    How can we hide or unhide column by using formula when we are entering value in any cell. e.g in A1 if i will enter 1 then Column F will hide and if i will enter any other number or if i will delete that 1 from A1, then Column F will unhide. please help me in this. Thank you!
  9. A

    TEXT from NUMERIC cell

    Hi all, I have one query. Please help me. If cell A5 contains 17/11/2011 i.e 50864. I changed its format as ddd i.e Thu Now It looks like TEXT but the origin of that cell is a NUMBER i.e 50864. But if I want to use "Thu" from cell A5 as a TEXT "Thu" in cell B5. Which formula can do this...
  10. A

    Difference in Dates

    Hi team, I need upcoming action by dates which we use to update the system. we don't calculate Saturday & Sunday as they are non business days. e.g- A B C 2| Enter Date here- | 17-11-2011 | Thu so i get- A B C 4| 1 business date |...
  11. A

    How to distribute data(work) in available people

    Hi all, Please help me in this.. If i have a list of 100 files (every file has its own diff number) in 1 tab and another list of 10 people in another tab. Now i want to distribute those 10 people in front of 100 files respectively. After sorting 10 files to 10 people, for 11th file i again...
Back
Top