Last seen: Aug 30, 2025
Hello Mitul, I have not checked your file, but to me it seems that you want to transpose the data. Have you checked this blog article by Mynda? ...
Hello, I am really not sure if I understand correct, but attached file shows what I would do if I had such list. Using a PivotTable is great for ma...
Hello Tonya, I have put together three different approaches, see the attached file. In short, you can use VLOOKUP function if you create a helpe...
Hi, Well, you can always create one PivotTable, set it up as you want showing only the consultants you need for the specific time sheet. When done,...
Hello Mitul, I hope you get the picture of what I try to show, that you get the errors due to irregularities in your data. As I see it, you have gr...
Hello Mitul, I have worked with your sample file in Excel for Mac, so the approach is a little bit different than it needs to be when done in Windo...
Hello Mitul, Sorry to say, but your dates are in a mess. Some "dates" are typed in so Excel does not recognize them as dates, but as text. I have u...
Hello, Just sharing my view, I would stick with the source data format and use a Pivot Table to arrange the data as required. Br, Anders
Hello, Well, the error message says it all, the user(-s) getting this error lacks permission to access the folder and/or files in the shared folder...
Anders Sehlstedt said Hello, You use the NA() function to get the #N/A error. You can read more information from Microsoft Office support about t...
Hello, You use the NA() function to get the #N/A error. You can read more information from Microsoft Office support about the NA function here. ...
Hello, Yes, if you do not want to have the zeros in the trendline then you have to replace those with #N/A instead. /Anders
Hello Mitul, As Philip writes, I do think you would benefit greatly of taking an Excel course because you will get good explanations of how the fun...
Hello Mitul, Glad to help out, but this is more looking like a private class rather than just giving some help or advice on how to go on with a prob...
Hello Mitul, How are you? Sorry for a late response, I had some difficulties to get home from work today. Questions regarding Document Copy-of-m...