1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Duplicates within filtered list

I have a table listing cases where an operator has rejected a job they have been allocated - for a number of reason codes.

I have filtered the list, as there are only three of these reason codes that I am interested in.

What I want to identify is the number of duplicates within this subset - i.e. where the same job has been reissued and then rejected again (because the issue which initially caused it to be rejected hasn't been resolved).

So if the rejection code is in Column A and the job reference is in Column B, I need a formula which will identify where the contents of the cell in Column A is one of the 3, and where the job reference appears more than once.

Ideally, I'd want to identify the number of cases rejected once, twice, seven times etc.

All help gratefully received.

submitted by /u/TFPOMR
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel alternatives for data analysis
#rows.com
#natural language processing for spreadsheets
#AI formula generation techniques
#generative AI for data analysis
#Excel compatibility
#no-code spreadsheet solutions
#formula generator
#Excel alternatives
#rejected
#duplicates
#job
#rejection code
#operator
#job reference
#cases rejected
#number of duplicates
#reason codes
#same job
#filtered list
Duplicates within filtered list