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