Forum Discussion
First time posting. Combine cells with the same value
I try to add new rows in the attatched file but the green table data don't update when i select refresh.
The "Count" column number is my achievement. I can copy the green table in the original file but i need the function which get "falso" and "verdadero" count per user.
=SUMPRODUCT((Tabelle1[User]=A25)*(Tabelle1[[FalsoVerdadero1]:[FalsoVerdadero9]]=B25))You can try SUMPRODUCT. This formula returns the same result but it doesn't require Power Query.
Yeah!! It was found with the true (Verdadero) values, but it's wrong with the other value.
For example: User1 has 27 "VERDADERO" values and 7 "FALSO" values, not 33. For each user, true value is correct.
How is the problem? I used this formula:
=SUMAPRODUCTO((Tabla_Auditoría[Usuario]=[@Usuario])*(Tabla_Auditoría[[Portal]:[Cabecera]]=[@Incidencia]))
I can't tell what the reason is without seeing your sheet. The formula returns the expected results in my sheet as you can see in the screenshot of my last reply. Can you attach a sample workbook without sensitive data or a screenshot without sensitive data which shows the formula, the whole data and the results in your sheet?