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

    need to freez column on each monday if it has previous dates

    Hi shrivallabha, I have a sheet with dates as colum heads. Each day is a column. Now I want to lock the columns which has previous date. for example if I open the sheet today yesterday's column should be locked for editing. I hope it is clear now.. if not please let me know. Thanks you...
  2. S

    need to freez column on each monday if it has previous dates

    Please help me achive this. Regards, Sadhana
  3. S

    Named Range Reference through cell content

    the table got messed up but i think you will understand. :)
  4. S

    Named Range Reference through cell content

    Hello, I have following table. now I need to count "NA" in the column where the date matches with current date. In the following case the answer will be 3. 1-Dec 2-Dec 3-Dec 4-Dec 5-Dec NA NA NA NA NA pid pid pid pid pid pid pid pid pid pid NA NA NA NA NA NA NA NA NA NA Please help
  5. S

    Named Range Reference through cell content

    https://www.dropbox.com/s/d8exfp6mai2u6jo/AllocationSheet.xlsm
  6. S

    Named Range Reference through cell content

    Thank you Kaushik, I have posted my sheet on dropbox. would you be able to check it. The range is already defined in the 1st sheet... I wnat to know what to know people who are 'NA' for today whenever I opent the sheet. for example if today is 30Nov and opne the sheet I need to know count of...
  7. S

    Named Range Reference through cell content

    I mean to say cell containing text 'NA'. I want a fomula to search for Range which has today's date in it' name and count 'NA' containing cells in that perticular column.
  8. S

    Named Range Reference through cell content

    I have an effort tracking sheet which has column for each day. I have defined range name for each column. I need to show how amy cells has 'NA' in it for a specific range name. it should take todays date range automatically and show NA count for that perticular range. Is it possible?
  9. S

    Hello .. Introduce yourself

    Hello, I am Sadhana and having too much interest in excel capabilitites being a Project Manager. Regards, Sadhana
Back
Top