• 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

    Flexible flow chart

    Hi Annen, First welcome to the Chandoo.org I checked your report sheet, you can try with the combination of "OFFSET" and "IF" formula. I'll upload the complete sheet once I'll done with it. Thanks! Atul
  2. A

    =COUNTIFS formula in Excel 2003

    Thank you so much all.. for your endless support n for everything.. you always help me, teach me.. u cant imagine how my excel knowledge has developed.. Its just because of you.. Hats off to you all.. Hats off to Chandoo.org & the team. Thanks again! :)
  3. A

    Validate cells which are allready having formula.

    Thank you so much SirJB7..
  4. 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...
  5. A

    Validate cells which are allready having formula.

    one more thing to ask you is- can we use any formula which works like "COUNTIFS" in 2003? Atul
  6. A

    Validate cells which are allready having formula.

    Narayan & SirJB, Thanks for replying. SirJB, the sheet u have modified, is working and I'll try with it. Thanks a lot for your precious help.
  7. A

    Validate cells which are allready having formula.

    Hi, I have uploaded a sample allocation sheet. please check with the following link. https://skydrive.live.com/redir.aspx?cid=92bd629a339d0180&resid=92BD629A339D0180!107&parid=root (Please read the info given in callout shape in "Agents" tab.) Thank you!
  8. 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...
  9. 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!
  10. A

    TEXT from NUMERIC cell

    Hi Narayan, Please help me in this- http://chandoo.org/forums/topic/how-to-distribute-datawork-in-available-people
  11. A

    TEXT from NUMERIC cell

    Done! Thanks Narayan. Using this formula, size of that excel sheet reduced from 2 MB to 50kb. B'coz we were using =LOOKUP formula and we had a list of dates till the year of 2090. Thanks.. Thanks a lot!
  12. A

    How to distribute data(work) in available people

    Hi, Column A contains list of files, Column B - Names of agents, Column C - status of the file. Now if Agent A is working on a file so status of that file will be PENDING. same goes for COMPLETED & CUST REPLY files. so if I want to count the files which are COMPLETED by agent A & PENDING...
  13. A

    How to distribute data(work) in available people

    Hey Narayan, its done by =COUNTA formula. Thanks a lot dear!
  14. 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...
  15. A

    How to distribute data(work) in available people

    Hi Narayan, Thanks Thanks Thanks.. IT WORKS! But.. My BOSS is not happy with this (as usual). B'coz if some day we have only 8 people, or more than 10 people then?? so I modified that formula.. By -ROW($5:$5),10)+1 To -ROW($5:$5),Sheet1!$A$1)+1 and in Sheet1!$A$1 I'm entering the...
  16. A

    Difference in Dates

    Hi all, I am using XL 2003. and in column B, They are not text, they are dates only (i.e 40864 - 17/11/2011). I am working on 17/11, and i need to update the system for next business day. if i am using +1, it will become 40865 i.e 18/11/2011 as 1 business day, but if we have official...
  17. A

    Difference in Dates

    Hello sir, Thank you so much for the reply. I tried by NETWORKDAYS formula, but its not working.. :(
  18. 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 |...
  19. A

    How to distribute data(work) in available people

    Hi Narayan.. Thanx a lot, it works but quite oppositely. 1. Actually i want name of 10 agents in Sheet1. and 2. List of 100 files should be in Sheet2 so, 3. I want these 10 agents to be distributed amongst those 100 files. e.g File 1 : A File 2 : B . . File 10 : J File 11 : A...
  20. 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