• 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

    How to create an index column based on dates in another column

    Hello I would like to create a helper column or index column based on my reporting date. The reporting date are random. They are sometimes 4 days,7 days apart or even 10 days apart. Secondly several rows have the same reporting date. I want to create a helper column that gives the reporting...
  2. S

    Retrieve value selected in data validation list onto another cell

    Thanks Narayan I see your point and =celladdress just works fine. I was reusing someone workbook and maybe they have used some other method and I am not able to retrieve the cell value there But on a new worksheet, I can def see that just pointing to cell works Regards Swati
  3. S

    Retrieve value selected in data validation list onto another cell

    hello Excel gurus I have created a dropdown list with 10 variables from a list. it works fine. Now i want that the value that is selected by the user should be extracted to another cell. Basically I want to reference that cell for a formula to extract some other value. Eg. My data validation...
  4. S

    Help in connecting data table

    Narayan Please have a look at the file. On the Survey tab, on the pivot table, I am trying to use three tables: Calendar table, survey table and case table The calendar table works well with the other tables. But when I try to use data from survey and case table together it says the link is...
  5. S

    Help in connecting data table

    Narayan I tried to remove some data from the file because it was too large and got a new error message that one of the linked table is not working. I encountered the same issue in the morning but I didn't realize what was the problem. When I try to update data, the file breaks. Is there...
  6. S

    Help in connecting data table

    Can anyone explain what this means How can i avoid circular relationship. The case numbers appear in both tables and occur only once in both tables
  7. S

    Helper column to check if date falls within last 18 months

    Hello We want to build a chart that contains data for last 18 months only. We dont want to use timeslicer I though of using a helper column. I don't want to use a rolling count of days in my formula I want to build a helper column to check if the date was within the last 18 months So if we...
  8. S

    Calendar Table

    Thanks Narayan Those links were very helpful. It was really an issue with the way my dates carried date stamp, once I cleaned it, I was able to link all the tables Thanks again...
  9. S

    Calendar Table

    Hello Narayan Thanks for taking time to help me understand this. I was able to use the calendar table to work out my backlog table. However when I add another table and try to connect it to my calendar table, the relationship breaks. I cannot understand why because I can see that I have linked...
  10. S

    Calendar Table

    Hello I want to have a list of dates which I can use to count cases opened and closed in a particular period. I want to do this in a pivot table so I dont want to use my opened date or closed date as dimension. I want to use an independent list of dates for this. When I try to create a...
  11. S

    Backlog metric in pivot table

    Thanks Narayan I was able to figure out how you did the calculations. As always thanks for your time and effort
  12. S

    Backlog metric in pivot table

    Thanks Narayan It works like magic...how can i see how you calculated the backlog and running backlog in the pivot table
  13. S

    Backlog metric in pivot table

    Hello Narayan Thanks for taking the time to look at this Attached is a sample file. I want to get the backlog and running backlog in my pivot table Regards Swati
  14. S

    Backlog metric in pivot table

    I used the formula in calculated field but it doesnt give me the desire result =Count (Date Opened)-Count (Date Closed)
  15. S

    Backlog metric in pivot table

    Hello I regularly produce backlog metrics for our customers. See For long I have run two seperate pivots to calculate opened and closed cases and then combine them here. I know I can run this as a table by extracting the min date and then counting open closed cases in the range However I...
  16. S

    Response Time

    Hello Naryana Thanks for sharing the links....I love this solution. I also worked on another combination which works well too... =B2-MIN(INDEX($B$2:$B$21,MATCH(A2,$A$2:$A$21,0))) If column b has time and column A has the event identifier I think this formula would work even when date time...
  17. S

    Response Time

    Thanks So much Narayan THis works like magic Can you please explain the logic so that I can use this in other context as well Thanks again...i have spent endless hours trying to figure this out Regards
  18. S

    Response Time

    Hello I am struggling to calculate the response time for a large data set. I need to calculate the response time from when the alert was first sent and finally picked. So one alert would go to multiple users and we need to calculate the response time on each row (current alert time-first alert...
Back
Top