Hi lea You can also refer here for a comprehensive post on Excel date and time : If you download the PDF file you can see the technique I used...
Hi lea You can use the Data - Text To Columns option 1) Select Column A 2) Select Data - Text To Columns 3) Select Fixed Width - Next - Ne...
Hi Maurizio You are welcome Sunny
Hi Maurizio I have added a helper column to your data to get the reverse sequence and count only those between 1 and 5 (last 5 games). You will ...
Hi Chloe Thanks for your feedback. I used VBA (Visual Basic For Application), a programming language, to write both the macro and function.. ...
Hi Chloe This example uses a custom function. Hope this helps Sunny
Hi Chloe You will need a macro for this. See if this helps. Sunny
Hi Chloe Please upload a sample copy of your file. It will help us understand your needs better. Sunny
Why don't you just ask all your users to copy the file from the network folder to their c: drive?
Hi Richard It is better if you could share your file so that it is easier for others to understand what you wanted. Sunny
Hi David Glad to hear you managed to fix the problem. Sunny
I'm not clear where you want the LOR no. to be. Can you post a sample where it should be?
Hi David No problem. Sunny
Hi Gary See if this works. 1) Create a helper column E 2) In cell E2 enter =IF(ISNUMBER(SEARCH("PSMAC",D2)),IF(COUNTIFS($A$2:A2,A2,$B$2:B2,B2...
Another method is press F12 and under Tools-General Options remove the password and press OK