User Profile
rcouri15
Copper Contributor
Joined Nov 14, 2019
User Widgets
Recent Discussions
Count the Number of Unique Values That Also Match a Value in Another Column
For example, I have a sheet to track the number of times people donated money. People occur in multiple rows in a table because they donate different amounts. I'm trying to count the number of unique people who donated who also have brown hair. This is a little different than what I'm exactly trying to do but basically the same. I'm attaching an example. I'm able to successfully do it by adding some extra columns but I'm wondering if there is a way to do it without the extra columns (Column B and C in the example), either by nesting formulas or using an array formula. This is a little over my head so would appreciate any help.Solved15KViews0likes3CommentsRe: Modifying Custom Table Style - Custom Table Elements?
mathetes Thank you! It weirdly worked that way. Just what worked for me was highlight the column except the header, right-clicking, selecting 'format cells...' and adding the border through there. I don't know why it didn't work the other way. Thanks again!598Views0likes0CommentsModifying Custom Table Style - Custom Table Elements?
I'm trying to create a custom table format. Toward the end of the table, there are a series of columns grouped together by a common theme. To make this visually clear that these columns are thematically distinct from the rest of the table, I want to create a solid singular border starting about 4 columns away from the end of the table that grows downward as you add more data/rows to the table. I'm not sure there is a way to do this but was wondering if anyone knew of a way. From what I can tell, the 'Modify Table Style' box doesn't permit custom table elements. I've attached an example of what I'd ideally like it to look like.Solved648Views0likes2Comments
Recent Blog Articles
No content to show