How are you my dear sir, may God keep you for us, thank you for your interest in spreading science, please help me get a solution to a problem regarding the unique function that you want to use with history so that if there is a table with names and in a history and needs to make a unique function according to the chosen date thank you very very much
Hello - I'm looking for a way to find the maximum TEXT value within a filtered table.. However, I have learned that finding a maximun text value not allowed? I was then hoping to use the unique function within a filtered excel table but that pulls in all unque values. Any thoughts.
Hi Chris, thanks for sharing this. I’ve currently got two columns e, f. - e with unique from table; f with countif sorted by largest to lowest amounts. Is there any way to sort unique by the order of countif data in f? Thank you!
I'm trying to use the =SORT(UNIQUE) function in a drop-down list on worksheet A that evaluates data in a table on worksheet B (same workbook) but keep getting the response that it evaluates to an error. It works in a cell but not when I try to do a drop-down list. I have over 50 unique values - is this the issue?
sorry but this nothing more than databasing. For me excel means calculations. What if you add all the amounts from every unique company? you should have two columns: company and the number of total values. I want the new array then sorted by the total values.