• 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

    traverse a column and change data based on result

    I have uploaded a file that can help http://rapidshare.com/files/431453290/Test_SS.xlsm Summary of what I did: Updated a private sub function in worksheet 1 (what ever worksheet you use - NOT module) Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$D$1&#34...
  2. S

    Shiftless Worksheet - fill shift cell based on time cell

    Hey joetech71, Donno if I got it the DUMB way - but here it goes: =IF(AND((HOUR(C832)+MIN(C832))>=7.292361,(HOUR(C832)+MIN(C832))<=15.649),"1",IF(OR((HOUR(C832)+MIN(C832))>=22.91,(HOUR(C832)+MIN(C832))<=7.291667),"3",""))
  3. S

    Hello .. Introduce yourself

    Hey All, Im Swaroop - working as an Analyst in Project Management Office. Had hands on experience with Excel and love to experiment on it. Looking forward to Install Excel 2010 yet :( Currently working on excelling MS ACCESS Thanks for the forum:) Regards, SS
  4. S

    Auto Y axis limits in Excel Charts

    Hey HSK, Select the axis, Do a right Click ON the axis and then select "Format Axis" in which you can set the option "Auto" which will auto adjust the minimum/maximum units as per your data. Swa
Back
Top