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

    Sum if for a specific time limit

    Hi, The data is as shown below Date in column A, Time in B and values in C. I need to sum the values in coulmn C for the times starting from 7:00 PM a day and ending 6:00 AM the next day. The sum is done for 24 hrs. which would run into the next day. Any help in this area would be helpful. A...
  2. T

    Week Num Function

    Hi, I need help here... My weeknum function gives me the week number. Lets say that the date is Feb 3, 2012, weeknum will show the number as "6", Is there any way that the cell shows Feb week 1, Mar week 3 and so on....
  3. T

    Change graph according to the dates selected

    Attaching an excel sheet. I need to select the week and the graph should show the changed data. Or there are two buttons placed need to check if that can be done by this button. Dynamic graphs i suppose any help link as given below...
  4. T

    Capture the Name of the Excel file while opening the same using VBA code

    OH ok i understood, i have captured the name in a variable. But this is giving me the name of the file that is been used for the code. My requirement is to capture the name of the file that i open with this code... any idea, or am i not correct in understanding the basic
  5. T

    Capture the Name of the Excel file while opening the same using VBA code

    Hi SirJB7, Thanks for the reply, I am new to VBA coding so have not tried. Now i tried and not getting the required result. i have changed the code to Sub OpenFile() Dim fileName fileName = Application.GetOpenFilename If fileName <> "False" Then...
  6. T

    Capture the Name of the Excel file while opening the same using VBA code

    I am using a code to open file from another file. Sub OpenFile() Dim fileName fileName = Application.GetOpenFilename If fileName <> "False" Then Workbooks.Open fileName, Format:=2 End If End Sub My requirement is to capture the name of the file (Not the path) which is opened...
  7. T

    Dependent drop down combo box. (see attached file)

    Never confusing Narayan, that was well explained. As I said have been reading most of your posts and all are well explained. I need your assistance for most of my cases. I would be posting more. You are one of those guys who explain very well. There is one more a person called Hui i feel, if i...
  8. T

    Dependent drop down combo box. (see attached file)

    You Know Narayan .... You are just awesome. i have been going through few of your posts and was always satisfied with the solutions that you give. Just one more question what is the significance of "-1" in this formula - =OFFSET(F2,MATCH($G$2,$E$2:$E$96,0)-1,0,COUNTIF(E2:E96,$G$2),1)
  9. T

    Dependent drop down combo box. (see attached file)

    Hi I am facing problems in here. i have uploaded the file in hotfile link - http://hotfile.com/dl/139854571/4da7eab/Error_Classification.xlsx.html i am able to get the drop down in the 2nd Level but the list is blank. Please help again
  10. T

    Dependent drop down combo box. (see attached file)

    Hey, thanks Prasad. That really worked out
  11. T

    Dependent drop down combo box. (see attached file)

    I have a list (Validation) in "A2" and it has ABC and BCD as drop down. Now "C2" should actually show another list depending on the selection of ABC or BCD. Please help
  12. T

    Sum On Conditions with Excel 2007

    Yes luke thats exactly what I want. Now its better.. :-). Thank you so much for your help.
  13. T

    Display a word as we scroll the selection in excel

    Hi, This is a bit akward stuff. This is an excel sheet. I have row, say A2 to Z2 filled up with alphabets starting with A to Z. I have another cell, say A3 displaying the active cell value. the code i have used is Range("A3") = ActiveCell.Value in the Selection change of the worksheet. Now i...
  14. T

    Sum On Conditions with Excel 2007

    Hi Fred, its only 8 in the entire range. Sorry for not being specific. Well this is just my second post, so, not so well with it. :-) Hi Luke, Thanks for this you saved my day. I was actually suming up the work hours for the entire team and wanted to sumup the time which was less than 8 hours...
  15. T

    Sum On Conditions with Excel 2007

    Hi, I have a range say A1:D10, All of the cells in this range contain the number 8, except for three cells, which contain 5, 2 and 6. The cells are A2, B2 and C2. I wanted to write a formula in "A11" or any other cell which would Sum only the cells that contain numbers other than 8, I am...
  16. T

    VLOOKUP to return multiple corresponding values

    Hi Felix, This is my first time too using the site. Here i have a different thought about it. I might be wrong, but correct me because i might not be aware of it. As per your requirement, i feel that VLOOKUP is a function that would return only one value in a single cell.(This is the part that...
Back
Top