LoraKnight
New Member
- Joined
- Jun 18, 2013
- Messages
- 14
How can I remove rows from my spreadsheet that don't subtotal Zero in the Subtotaled "CPT" Column. I only want to leave the group of data that has a subtotal of Zero in the "CPT" Column.
This is the complete Sheet
<TBODY>
</TBODY>
<TBODY>
</TBODY>
This is the complete Sheet
Practice Code | Appt Date | Pat Person Nbr | Pat First Name | Pat Last Name | Appt Status | CPT | Appt Status Desc | Reason Desc | Appt Provider Name |
LKMN | 1/2/2013 | 3241.1 | A | Smith | T | Occurred | Ob Visit | Smith, Doctor | |
LKMN | 1/2/2013 | 3241.1 | A | Smith | 99213,TH | TH | Office Visit-Est Patient; Intermed | Smith, Doctor | |
3241.1 Count | 1 | 1 | |||||||
LKMN | 1/2/2013 | 31064.3 | B | Jones | T | Occurred | Post Op | Smith, Doctor | |
LKMN | 1/2/2013 | 31064.3 | B | Jones | Office Visit-Est Patient; Intermed | Smith, Doctor | |||
31064.3 Count | 1 | 0 | |||||||
LKMN | 1/2/2013 | 40300 | C | Johnson | T | Occurred | Ob Visit | Smith, Doctor | |
LKMN | 1/2/2013 | 40300 | C | Johnson | 99213,TH | TH | Office Visit-Est Patient; Intermed | Smith, Doctor | |
40300 Count | 1 | 1 | |||||||
LKMN | 1/2/2013 | 49746.1 | D | Williams | T | Occurred | Problem Check | Smith, Doctor | |
LKMN | 1/2/2013 | 49746.1 | D | Williams | 99213 | Office Visit-Est Patient; Intermed | Smith, Doctor | ||
49746.1 Count | 1 | 1 | |||||||
LKMN | 1/2/2013 | 52680.3 | E | Roberts | T | Occurred | Ob Visit | Smith, Doctor | |
LKMN | 1/2/2013 | 52680.3 | E | Roberts | TH | Office Visit-Est Patient; Intermed | Smith, Doctor | ||
52680.3 Count | 1 | 0 | |||||||
LKMN | 1/2/2013 | 75595.1 | F | Lard | T | Occurred | Ob Visit | Smith, Doctor | |
LKMN | 1/2/2013 | 75595.1 | F | Lard | 99213,TH | TH | Office Visit-Est Patient; Intermed | Smith, Doctor | |
75595.1 Count | 1 | 1 | |||||||
LKMN | 1/2/2013 | 104405 | G | Wilks | T | Occurred | Ob Visit | Smith, Doctor | |
LKMN | 1/2/2013 | 104405 | G | Wilks | 99213,TH | TH | Office Visit-Est Patient; Intermed | Smith, Doctor | |
104405 Count | 1 | 1 | |||||||
LKMN | 1/2/2013 | 119088 | J | Smith | T | Occurred | Ob Visit | Smith, Doctor | |
LKMN | 1/2/2013 | 119088 | J | Smith | TH | Office Visit-Est Patient; Intermed | Smith, Doctor | ||
119088 Count | 1 | 0 | |||||||
LKMN | 1/2/2013 | 123931 | K | Nolan | T | Occurred | Ob Visit | Smith, Doctor | |
LKMN | 1/2/2013 | 123931 | K | Nolan | 99213,TH | TH | Office Visit-Est Patient; Intermed | Smith, Doctor | |
123931 Count | 1 | 1 | |||||||
LKMN | 1/2/2013 | 164819 | L | Morris | T | Occurred | Ob Visit | Smith, Doctor | |
LKMN | 1/2/2013 | 164819 | L | Morris | 59400,X | Routine Obstetric Care Includi Ng a | Smith, Doctor | ||
164819 Count | 1 | 1 |
<TBODY>
</TBODY>
This is what I would like to be left with after the removal of the rows that don't subtotal Zero in the CPT Column
<TBODY> </TBODY> |
<TBODY>
</TBODY>
Last edited: