Thanks for the great solution. I was trying to get something very similar to work, maybe somebody has an idea. I have a list and wanted to get an autocompletion going. This is working with the code above. Now I want the data to be matched not only with the initial string of letters of the arguments in my validation list but against any string of letters in my validation list. Example: I have a list of names formatted as first / last name. This solution right now only allows matching against first names. I want the matching to work against last names as well. Any ideas? Help is greatly appreciated :)

=ABS(IF([@Priority]<3,settings!$F$2-K3,(((NETWORKDAYS(K3,settings!$F$2,Holidays[#All]))*((settings!$B$3-settings!$B$2)*24)-IF(AND(NETWORKDAYS(K3,K3,settings!$D$2:settings!$D$33)>0,(K3-INT(K3))*24>(settings!$B$2-INT(settings!$B$2))*24,(K3-INT(K3))*24<(settings!$B$3-INT(settings!$B$3))*24),((K3-INT(K3))*24)-((settings!$B$2-INT(settings!$B$2))*24),0)-IF(AND(NETWORKDAYS(settings!$F$2,settings!$F$2,settings!$D$2:settings!$D$33)>0,(settings!$F$2-INT(settings!$F$2))*24<(settings!$B$3-INT(settings!$B$3))*24,(settings!$F$2-INT(settings!$F$2))*24>(settings!$B$2-INT(settings!$B$2))*24),((settings!$B$3-INT(settings!$B$3))*24)-((settings!$F$2-INT(settings!$F$2))*24),0)-IF(AND(NETWORKDAYS(K3,K3,settings!$D$2:settings!$D$33)>0,(K3-INT(K3))*24>(settings!$B$3-INT(settings!$B$3))*24),(settings!$B$3-settings!$B$2)*24,0)-IF(AND(NETWORKDAYS(settings!$F$2,settings!$F$2,settings!$D$2:settings!$D$33)>0,(settings!$F$2-INT(settings!$F$2))*24<(settings!$B$2-INT(settings!$B$2))*24),(settings!$B$3-settings!$B$2)*24,0))/24)))

Professional company-wide Office 365 email signature

Sigsync is a secure, cloud-based Office 365 email signature service that helps to create centralized email signatures and disclaimers for all Office 365 users. Monitor email signatures for all Office 365 users by a centralized email signature management. It helps to design an attractive and professional company-wide email signature on every email across all the email clients and devices. Email signatures helps in promoting offers/discounts planned without much investment involved.
Uses of email signature
    Companies or businesses use email signature to enhance their brand, marketing and to establish a corporate identity.
    Easy for people to reach you and to know more about your business.
    Disclaimers for all users in your Office 365 email signature.
Few highlights of the software:
● Automatically retrieves details from Azure AD to add email signature.
● Branded email signatures and disclaimers for the entire organization.
● ...

Hi, I would very much love to purchase this product, if just for the tool for splitting my workbook into several worksheets so they can be saved as CSV files. I downloaded KUTools and tried this and uploaded the csv files into WPDataTable, a WordPress plugin widely used for online table creation, and I get this message 

There was an error while trying to save the table! parsererror WDTException: [0]: One or more columns doesn't have a header. Please enter headers for all columns in order to proceed.

Now, when I manually save the same worksheets as CSV files in Excel and upload them into WPDataTable, this problem doesn't occur and everything runs smoothly. When I open the CSV files, the content looks identical, but there must be something different between manually created CSVs and KUtools-created CSVs. What gives? Just for this feature, I'd love to immediately purchase the product and be ...

how would you do the first order but with multiple columns of data for each product? Like if KTO and KTE had multiple pieces of data in columns C, D, E,...

This was the formula used:

=IFERROR(INDEX($B$2:$B$16, MATCH(0, COUNTIF($D2:D2,$B$2:$B$16)+IF($A$2:$A$16<>$D2, 1, 0), 0)), 0)

This helped a lot but i'm trying to do this but everything starts hidden and hide and unhide isolated cells rather than a range? thanks!

how do you do this but everything starts hidden and how do you hide and unhide isolated cells rather than a range?

@crystalHi, 

Hello, how would the VBA code be adjusted if I want to combine cells in column M based on the duplicates in column A?

@THE HELPER Now it works for me. Thanks!!!