Forum Discussion
First time posting. Combine cells with the same value
Hi community!
That's my first post of Excel! I have a question about using the following values:
I have a Spanish Sharepoint list query in Excel.
For each row is a user audit in a store in different days. I want to count all FALSE values per User audit entry in a single column.
There are some entries for each user. I want to get something like this:
User1: 12 False
User2: 5 False
User3: xFalse
Can i use an specific formula which can update each time that I update database?
Thank you so much!!
Best Regards.
Jesús
Maybe with Power Query. In the attached file you can add data to the large blue dynamic table. Then you can click in any cell of the green table and right-click with the mouse and select refresh to update the green result table.
The layout of the data in the screenshot is for illustration. You can place the green table to the right of the blue table or on another sheet.
- Thank you!
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.
