First and Last Entry on a Page using Modulus Remainderhttp://mail.joellipman.com/articles/web-development/php/first-and-last-entry-on-a-page-using-modulus-remainder.html

26 September 2011 I know it's quite a long title but I'm not sure what I'll be searching next time. It has taken me a lot longer than I thought it would mostly out of frustration and the inability to know exactly what I'm looking for... always difficult. After a cup of...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: *

MySQL Group_concat equivalent in T-SQL and Oraclehttp://mail.joellipman.com/articles/database/mysql-groupconcat-equivalent-in-t-sql-and-oracle.html

28 November 2011 as I don't see myself doing any other job and it beats daytime television any day. I use this quite a lot so I thought I'd put an article here somewhere. Based on the following concept: RowID column_to_return_as_string ---------...

• Type: Article
• Author: Joel Lipman
• Category: Databases
• Language: en-GB

Select unique values in Microsoft Excel columnhttp://mail.joellipman.com/articles/microsoft/excel/select-distinct-values-in-microsoft-excel-column.html

03 July 2012 Thought I'd put a quick note here, I tried a fair few solutions that didn't work and then found this hidden away in a forum: Quick Count =INT(SUMPRODUCT((A3:A1000"")/COUNTIF(A3:A1000,A3:A1000&""))) This returns the number of unique values in the range...

• Type: Article
• Author: Joel Lipman
• Category: Excel
• Language: en-GB

UNC Paths in Sharepoint 2007 linkshttp://mail.joellipman.com/articles/microsoft/sharepoint/unc-paths-in-sharepoint-2007-links.html

08 November 2012 letter to the path? Then they won't be able to use the link. Why? As soon as someone suggested I setup WebDAV to do this, I thought I'd write this article to warn others that that's unnecessary and can simply open another can of worms (security-wise)....

• Type: Article
• Author: Joel Lipman
• Category: SharePoint
• Language: *

Zoho Inventory Template Issue: First Page is Blankhttp://mail.joellipman.com/articles/crm/zoho/zoho-inventory-template-issue-first-page-is-blank.html

15 November 2018 So I thought I'd write an article to help me resolve the particular issue where the organization details and the header of the product line items table would display on the first page, the product line items would then print on the second page, with the...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: en-GB

COVID-19: Working from Homehttp://mail.joellipman.com/covid-19-work-from-home.html

05 July 2020 on end. I was waiting to move house during 2020 but then a virus capable of locking down the world manifested itself. I thought this would be temporary but after 4 months of slouching over the coffee table, my back is suffering terribly. I figured on a...

• Type: Article
• Author: Joel Lipman
• Category: Articles
• Language: *