bertkelmer
New Member
- Joined
- Aug 15, 2018
- Messages
- 5
I have tried searching and google with minimal luck. I am trying to help someone who is not excel savy at work. I am trying to extract a value that appears x times or more based on a criteria that is in a different column. For example, the report below has data on all the cost centers (column A) this person is responsible for. They are interested in cost center 34 and want to extract the name of the person that appears 2 or more times from column b. So based on this criteria, the yield would be John (cost center 34, appears twice), and the 5-10 rows below would be blank.
I've tried formulas that pull values that appear >=2 times but the yield is John, Kelly and Jim when I drag the formula down. I am interested only on cost center 34.
A B
34 John
34 John
34 Adam
25 Kelly
25 Kelly
25 Kelly
12 Jim
12 Jim
12 Jim
I've tried formulas that pull values that appear >=2 times but the yield is John, Kelly and Jim when I drag the formula down. I am interested only on cost center 34.
A B
34 John
34 John
34 Adam
25 Kelly
25 Kelly
25 Kelly
12 Jim
12 Jim
12 Jim