jordiejones
New Member
- Joined
- May 5, 2010
- Messages
- 31
I have tried previous helper columns that would allow me to return rows but looking for a nice clean solution. here's what my data looks like.
<tbody>
</tbody>
I'm trying to create a new list of ONLY rows containing Capitalized "DP" regardless of how many instances
<tbody>
</tbody>
I've tried "=EXACT(A2:A5,"DP")" but it only returns EXACT matches in the first cell.
Any help would be greatly appreciated.
Ted | DP | dp | dp | bp |
Angela | dp | dp | ap | dp |
Mike | dp | DP | dp | DP |
Scott | PP | lp | dp | dp |
Renee | dp | dp | ap | DP |
<tbody>
</tbody>
I'm trying to create a new list of ONLY rows containing Capitalized "DP" regardless of how many instances
Ted | Dp | dp | dp | bp |
Mike | dp | DP | dp | DP |
Renee | dp | dp | ap | DP |
<tbody>
</tbody>
I've tried "=EXACT(A2:A5,"DP")" but it only returns EXACT matches in the first cell.
Any help would be greatly appreciated.