Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Create counter for combinations of cell matches within same row
Register FAQ Search Today's Posts Mark Forums Read

Reply
 
Thread Tools Display Modes
  #1  
Old 02-03-2023, 02:12 AM
Gouldinho Gouldinho is offline Create counter for combinations of cell matches within same row Windows 10 Create counter for combinations of cell matches within same row Office 2021
Novice
Create counter for combinations of cell matches within same row 		 
Join Date: Jan 2023
Posts: 5
Gouldinho is on a distinguished road
Default Create counter for combinations of cell matches within same row
Hi All,

I'm trying to create a counter which identifies instances where for example "*P*" in column C and "Office" in D both occur in the same row. This counter would go in I21 in my attached screenshot.

For context, I know how to create counters, just not how to ask it to look for combinations from 2 cells within the same row.



This would obviously need to apply to the whole sheet.

I hope I've managed to explain this clearly and thanks in advance for any help!
Attached Images
File Type: png excel snip.PNG (63.2 KB, 7 views)
Reply With Quote
  #2  
Old 02-03-2023, 05:10 AM
p45cal's Avatar
p45cal p45cal is offline Create counter for combinations of cell matches within same row Windows 10 Create counter for combinations of cell matches within same row Office 2019
Expert
  
Join Date: Apr 2014
Posts: 719
p45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud of
Default
Pictures for this question are no earthly use. Attach a workbook with just this sheet in it, then when you get an answer you're sure it'll work. (If the data is sensitive, it doesn't need to contain any more data than what you've already exposed in the picture.)
Reply With Quote
  #3  
Old 02-03-2023, 06:44 AM
Gouldinho Gouldinho is offline Create counter for combinations of cell matches within same row Windows 10 Create counter for combinations of cell matches within same row Office 2021
Novice
Create counter for combinations of cell matches within same row 		 
Join Date: Jan 2023
Posts: 5
Gouldinho is on a distinguished road
Default
Noted, Please find attached!
Attached Files
File Type: xlsx stock sheet example.xlsx (47.3 KB, 2 views)
Reply With Quote
  #4  
Old 02-03-2023, 07:31 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Create counter for combinations of cell matches within same row Windows 10 Create counter for combinations of cell matches within same row Office 2021
Expert
  
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,667
Pecoflyer has much to be proud ofPecoflyer has much to be proud ofPecoflyer has much to be proud ofPecoflyer has much to be proud ofPecoflyer has much to be proud ofPecoflyer has much to be proud ofPecoflyer has much to be proud ofPecoflyer has much to be proud of
Default
Perhaps
Code:
=SUMPRODUCT(--(ISNUMBER(SEARCH("P",$C$2:$C$1129)))*($D$2:$D$1129="office"))
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
  #5  
Old 02-03-2023, 07:46 AM
p45cal's Avatar
p45cal p45cal is offline Create counter for combinations of cell matches within same row Windows 10 Create counter for combinations of cell matches within same row Office 2019
Expert
  
Join Date: Apr 2014
Posts: 719
p45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud of
Default
Some formulae in column I
To double-check choose a group name in cell M8 and compare results with column I, especially the totals; it'll help you sort out discrepencies.
Attached Files
File Type: xlsx msofficeforums50359stock sheet example.xlsx (68.4 KB, 1 views)
Reply With Quote
  #6  
Old 02-03-2023, 08:42 AM
Gouldinho Gouldinho is offline Create counter for combinations of cell matches within same row Windows 10 Create counter for combinations of cell matches within same row Office 2021
Novice
Create counter for combinations of cell matches within same row 		 
Join Date: Jan 2023
Posts: 5
Gouldinho is on a distinguished road
Default
p45cal and Pecoflyer just wanted to thank you both for your help! The returned sheet is exactly what I had been aiming for p45cal. I'm now breaking down what you did to learn it for myself next time!

Thanks again!
Reply With Quote
Reply

« Previous Thread | Next Thread »
Thread Tools
Display Modes
Linear Mode Linear Mode


Similar Threads
Thread Thread Starter Forum Replies Last Post
Create counter for combinations of cell matches within same row lookup the date beside a cell that matches a value oscarlimerick Excel 2 01-30-2022 09:38 AM
how to create a Microsoft word 2016 tempalte so it matches a CSS template bboerma Word 3 11-21-2017 08:18 AM
Create counter for combinations of cell matches within same row If value of cell A Matches a value in a Range of cells (column) then add value of cell A to cell C rick10r Excel 1 07-05-2016 12:07 PM
cell text to auto populate if criteria matches Jackie Excel 2 02-06-2015 07:58 PM
Create counter for combinations of cell matches within same row How to conditionally format cells in Col. A if it matches adjacent cell in Col. B? alshcover Excel 2 06-03-2014 12:50 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:57 AM.

Contact Us - Privacy Statement - Top

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2023, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2023 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft