•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
How to count how many columns two rows have in common
Hello, I'm a hobbyist driving myself insane hopping between index, lookups, and countif functions trying to count:
How many times does character A feature with character B across multiple events
This is a slice of the whole chart, I'll call the characters A-D in descending order.
For example, say I want to count how many times character A and D share a column. In this slice of the chart, I'd want for the function to return 1.
In total there are 32 columns, and I want to be able to compare one character row with 21 other rows.
I suspect I'll need to change the cells that read "1*" to simplify the matter, but if there's a way to count for both "1" and "1*" cells I'd be very thankful.
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#natural language processing for spreadsheets
#generative AI for data analysis
#rows.com
#financial modeling with spreadsheets
#Excel compatibility
#row zero
#Excel alternatives
#count
#characters
#rows
#columns
#common
#function
#countif
#feature
#cells
#index
#lookup
#events