Hello,
I'd appreciate help with a file that I am working on. Not sure how to describe it but I have provided an example in the attached file.
I have data in the format presented in columns B and C. I need to create the result in columns F-J. Column F is provided and all the values are unique. Row 4 is provided as well and all the values are unique too.
I need to count how many times there is an overlap.
In G5 copied across and down:
=SUMPRODUCT(($B$4:$B$9=$F5)*(ISNUMBER(SEARCH(G$4,$C$4:$C$9))))
There is a typo in cell C8 - I've corrected it in the attached.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
Thank you so much!
Hi zz_zz11
Your Cell C8 has the following content: 2002 char six, so it is normal to get 1 in Cell H6 calculation, but it is actually 2002 chair six, or it may be a typo, or you will really get 2
That was pointed out in post #2 yesterday.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks