Microsoft Excel is the original business intelligence tool. Long before Big Data was even a twinkle in its mother's eye, there was Excel and its pivot tables. When I was a serious spreadsheet jockey trying to make my mark on the world (as a financial auditor for a super-serious accounting...
Pivot Tables VBA Macros UDFs Archive Comments (37) 37 Responses to “Working with unique values” Nigel Edwards says: Hi, I've been searching for articles to help me to identify unique data across multiple Excel columns, and yours is the closest I have found. However, it seems to...
In baseball the basic skills are throwing and catching. In Excel development, saving files and dealing with different file formats is basic skill. In this sample, the method checks the file format of the passed workbook file and branches based on what it discovers. PrivateSubSaveWB(wbAsExcel....
Pivot Tables VBA Macros UDFs Archive Comments (37) 37 Responses to “Working with unique values” Nigel Edwards says: Hi, I've been searching for articles to help me to identify unique data across multiple Excel columns, and yours is the closest I have found. However, it seems to...
This formula works only in Excel 365 and is entered as a regular formula despite its name. It spills values to cells below as far as needed. The formula returns a #SPILL error if one or more cells are populated with characters. Delete the values and the formula spills values to cells be...
This formula works only in Excel 365 and is entered as a regular formula despite its name. It spills values to cells below as far as needed. The formula returns a #SPILL error if one or more cells are populated with characters. Delete the values and the formula spills values to cells be...