Given a single column with duplicates appearing, one may want to dynamically extract unique values to another range. Depending upon the version of MS Excel which you are using, there could be two ways to solve this problem Solution for MS Excel 2010 and higher versions If you are using the Power Query add-in, then a […]
Read More →
{ 325 Comments }
Assume a four column database with department as the second column. Entries in the department column may be repeated. A person may wish to create one worksheet tab for each department. Therefore, as and when a person names a worksheet tab as one of the departments, all rows of that department should appear on this new sheet. You […]
Read More →
{ 4 Comments }
Given a large number of entries in the source of data validation, it may become cumbersome to scroll down the list to select a desired value. It would be ideal to have the user type the first alphabet and be taken to all words which start with that alphabet. The drop down list in cell […]
Read More →
{ 244 Comments }
In a list with multiple occurrences, the VLOOKUP() function in Excel will only return the first occurrence of the string being searched. Depending upon the version of MS Excel which you are using, there could be two ways to solve this problem Solution for MS Excel 2010 and higher versions If you are using the […]
Read More →
Dynamically extract unique values with no conditions
{ 4 Comments }