Excel: Find values in one column that are not in anotherhttps://www.joellipman.com/articles/microsoft/excel/excel-find-values-in-one-column-that-are-not-in-another.html

06 March 2014 Old New Exists in Old? --------- --------- -------------- 123456 234567 234567 345678 345678 456789 567890 597890 I want the third column to say whether this is new or not. How? I found this in a StackExchange site: Method #1 =MATCH(B2, $A$2:$A$100, 0)...

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

Upload file to Google Drive with PHP/cURL and API REST v3 (without Client Library)https://www.joellipman.com/articles/google/upload-file-to-google-drive-with-php-curl-and-api-rest-v3-without-library-install.html

29 October 2018 two requests, the second is the appropriate multipart function which uploads and names the file in a single request, and the third is a 'nice-to-have' upload to the specified folder. Method #1: two requests 1. Send the media file 2. Update the name of...

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

Zoho Deluge - First Monday of Month or Last Tuesday of Monthhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-first-monday-of-month-or-last-tuesday-of-month.html

27 September 2019 1; } else if(v_InputSwitch.toString().indexOf("Second") >= 0) { v_DayOccur = 2; } else if(v_InputSwitch.toString().indexOf("Third") >= 0) { v_DayOccur = 3; } else if(v_InputSwitch.toString().indexOf("Fourth") >= 0) { v_DayOccur = 4; } else...

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

Zoho Deluge: Handle Commas between Quotes in a CSV (and New Lines)https://www.joellipman.com/articles/crm/zoho/zoho-deluge-handle-commas-between-quotes-in-a-csv.html

26 August 2021 will also replace any new lines found between two double-quotes with a single space (note how I've added a new line in the third row in the sample data): // generate a sample CSV file v_DataCSV = "1,Joel Lipman,Kings Castle,England\n"; v_DataCSV =...

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

Zoho Analytics: Determine profits from invoices and purchase ordershttps://www.joellipman.com/articles/crm/zoho/zoho-analytics-determine-profits-from-invoices-and-purchase-orders.html

03 November 2022 purchased; including shipping and tax. The second is to associate these to the invoiced items and work out the profit. The third is to group by the sales person, date, and customer so as to generate meaningful reports. The first dataset should be just...

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

What can MAGA’s do to stop Biden from cheating again?https://www.joellipman.com/articles/_other-misc/jokes/what-can-maga’s-do-to-stop-biden-from-cheating-again.html

28 August 2024 "What's your IQ?" "100." The robot proceeds to chat about NASCAR, Budweiser, and John Deere tractors. The guy comes back a third night and this time when asked says, "About 50." The robot leans in real close and says, "Isn't it terrible the way Biden...

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

ZohoCRM: Make either Mobile or Email mandatoryhttps://www.joellipman.com/articles/crm/zoho/zohocrm-make-either-mobile-or-email-mandatory.html

03 October 2024 a warning that you are selecting a field that is already being used in a rule. Seems that I can't select the same field in a third layout rule... Easy without coding and probably everyone figures this one out but I thought I'd add it here as I thought...

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

RocketTheme's Affinity July 2009 Releasedhttps://www.joellipman.com/articles/cms/joomla/rocketthemes-affinity-july-2009-released.html

01 July 2009 Affinity is the July 2009 release from RocketTheme and features extensive third party support for powerful and popular community products, such as JomSocial, K2 and phpBB3. The template's core feature is Sortable Elements, which allows for the movement...

• Type: Article
• Author: Webmaster
• Category: Joomla
• Language: *

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

15 November 2018 page, the product line items would then print on the second page, with the terms and conditions or small print notes on a third page. How? Printing to PDF or saving as a PDF lets me preview the page breaks based on the paper size I select. I have a bit...

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