User Profile
Klas_Britse
Copper Contributor
Joined Mar 04, 2021
User Widgets
Recent Discussions
Re: Counting unique posts in a table with multiple conditions
Coung - Not really, I found that part myself and it seems a bit too simplified to really help me address my issue. Sergei – Im using Excel365. FILTER and UNIQUE are available functions (even if they are called FILTER and UNIK in my swedish version). Must try those, haven’t used those formula fun JMB17 – Thanks for the shared formulas, need to study them closer to understand wh In general, I think I’ll try first with the FILTER/UNIQUE functions, it’s always nice when things can be solved as easy as possible. Thank you all very much! For now, that is. We’ll see if I need more support later… 😊1.7KViews1like1CommentCounting unique posts in a table with multiple conditions
Hi Im trying to calculate number of rows in a table that fulfil multiple conditions using the COUNTIFS function. My problem is that I only want to count rows holding unique values in one of the columns. I've read about the FREQUENCY function that can be used for counting unique values, but I don't understand if/how I can combine it with COUNTIFS. Is that possible, or does anyone know a different method to do this? /Klas2KViews0likes5Comments
Recent Blog Articles
No content to show