Search results

Hi NARAYANK991, Thanks for explaining the {1,1} part of the formula. I have learned a lot, since this is my first time working with array formulas. T The sample file, it works exactly as needed! Today I was able to complete the spreadsheet I have been struggling with for the last several...

NARAYANK991: Tested your formula in Libreoffice and it works perfectly!

Update: NARAYANK991: After changing the locale of the whole system to American English, I was able to change Excel's separator to comma. However, Excel still says "The formula you typed contains an error" and highlights the *{1,1} part of the formula. I removed the *{1,1} part and the error no...

NARAYANK991: First I have inserted your formula exatcly as you posted (copy and paste). Excel says "The formula you typed contains an error". Then I replaced your argument separators (commas) for semicolons and the error dissapeared, however the result was #N/A. I found that Excel uses different...

Faseeh: Hi. Your formula resulted in a list of unique items, however thay are not ranked by number of ocurrences (most ocurring items first). Also, I'm trying to avoid using helper columns (unless there is no other choice). Is there a way of avoinding the helper column and ranking the result...

Hello, My name is Bruno and it's my first time here. I need a formula that will extract a sorted, unique list of strings, ranked by number of ocorrences (most ocurring items first). Example: Original list (single column, unknown number os rows, with some blank cells): CC AA (blank...

Hello, My name is Bruno and it's my first time here. I need a formula that will extract a sorted, unique list of strings, ranked by number of ocorrences (most ocurring items first). Example: Original list (single column, unknown number os rows, with some blank cells): CC AA (blank...