Forum

Hello Ahmad, I have problem understanding your question. Please give more details of what you want to do and what you want as a result. There ar...

Hello Mitul, The formula you have problem with contains semicolon as separator character. That works perfectly fine for me as that is correct for m...

Hello Sandra, I will try to give some answers to your question, let's begin with the easiest first. To insert a picture I use the Attachments bu...

Hello, As there is no sample files in your post I can't really give any help or advice, but for me it works just fine. I have attached my test file...

Hello Mitul, This question is not related to this post, so you should have created a new topic. Anyway, the answer to your first question is tha...

Hello, It would be much easier if you can give us some sample files. Is it possible to upload some files having same structure but contains just so...

Hello Mitul, No, not what I know of. Br, Anders

Hello Mitul, I have rearranged all your data in a separate sheet. I have cleaned up the document. The reason why you see two dec -18 is because in ...

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