Forum Discussion
Excel combine lambda and countif in formula
Hi, I believe it would be easier to help you if you could share a sample file (without sensitive data) of your problem. Also, can you develop further what is the expected output? Do you want to retrieve an array with only values that appear more than once in a set range?
If you could share a screenshot or a sample file together with a desired output I am sure it would be an easy task!
Martin_Angosto sorry thats more helpful. See attached. Basically what I want to check is if there are numbers with different names spelled. So for example in the example I want to have a list containing 10193460 | a
10193460 | aa
and the other projects should not appear because the numbers were spelled in the same way.
I was thinking of preparing a unique table and then counting the number of times the projects would appear because when the names are not spelled the same you would have multiple times the specific project. But perhaps there are other more logic ways to achieve this.