Spreadsheet: 274523d1383142081-one-formula-to-add-specific-text-to-a-column-test-book-101
Sheet: Sheet1

Comments: | Primary Ins | Sdate | Pdate
I need "[NAME]" in each of these lines, column A, for all the claims above the Total for [NAME] line | 824-AETNA INC. | 2011-10-03 00:00:00 | 2011-10-14 00:00:00
Then I plan to sort out all the Total and blank lines so I can work with this as a database | 824-AETNA INC. | 2011-10-10 00:00:00 | 2011-10-14 00:00:00
 | 824-AETNA INC. | 2011-10-11 00:00:00 | 2011-10-19 00:00:00
 | 824-AETNA INC. | 2011-10-17 00:00:00 | 2011-10-19 00:00:00
 | 824-AETNA INC. | 2011-10-18 00:00:00 | 2011-10-25 00:00:00
 | 824-AETNA INC. | 2011-10-25 00:00:00 | 2011-10-31 00:00:00
 | 824-AETNA INC. | 2011-10-31 00:00:00 | 2011-10-31 00:00:00
 | 824-AETNA INC. | 2011-11-14 00:00:00 | 2011-11-18 00:00:00
 | 824-AETNA INC. | 2011-10-24 00:00:00 | 2011-10-25 00:00:00
 | 824-AETNA INC. | 2011-11-01 00:00:00 | 2011-11-10 00:00:00
 | 824-AETNA INC. | 2011-11-07 00:00:00 | 2011-11-10 00:00:00
 | 824-AETNA INC. | 2011-11-08 00:00:00 | 2011-11-18 00:00:00
 | 824-AETNA INC. | 2011-11-15 00:00:00 | 2011-11-23 00:00:00
 | Total for [NAME]:
I need "Meredith" in each of these lines, column A, for all the claims above the Total for Meredith line | 824-AETNA INC. | 2011-10-31 00:00:00 | 2011-11-10 00:00:00
 | 824-AETNA INC. | 2011-11-01 00:00:00 | 2011-11-10 00:00:00
 | 824-AETNA INC. | 2011-11-14 00:00:00 | 2011-11-18 00:00:00
 | 824-AETNA INC. | 2011-11-07 00:00:00 | 2011-11-10 00:00:00
 | 824-AETNA INC. | 2011-11-08 00:00:00 | 2011-11-18 00:00:00
 | 824-AETNA INC. | 2011-11-15 00:00:00 | 2011-11-23 00:00:00
 | 824-AETNA INC. | 2011-11-21 00:00:00 | 2011-11-23 00:00:00
 | 824-AETNA INC. | 2011-11-22 00:00:00 | 2011-11-30 00:00:00
 | 824-AETNA INC. | 2011-11-25 00:00:00 | 2011-11-30 00:00:00
 | 824-AETNA INC. | 2011-11-26 00:00:00 | 2011-11-30 00:00:00
 | 824-AETNA INC. | 2011-11-28 00:00:00 | 2011-11-30 00:00:00
 | Total for MEREDITH:
 | 824-AETNA INC. | 2011-11-16 00:00:00 | 2011-11-23 00:00:00
 | 824-AETNA INC. | 2011-11-21 00:00:00 | 2011-11-23 00:00:00
 | 824-AETNA INC. | 2011-11-22 00:00:00 | 2011-11-30 00:00:00
 | 824-AETNA INC. | 2011-11-23 00:00:00 | 2011-11-30 00:00:00
 | 824-AETNA INC. | 2011-11-25 00:00:00 | 2011-11-30 00:00:00
 | 824-AETNA INC. | 2011-11-26 00:00:00 | 2011-11-30 00:00:00
 | 824-AETNA INC. | 2011-11-28 00:00:00 | 2011-11-30 00:00:00
 | 824-AETNA INC. | 2011-11-29 00:00:00 | 2011-11-30 00:00:00
 | 824-AETNA INC. | 2011-12-01 00:00:00 | 2011-12-05 00:00:00
 | 824-AETNA INC. | 2011-12-04 00:00:00 | 2011-12-05 00:00:00
 | 824-AETNA INC. | 2011-12-05 00:00:00 | 2011-12-12 00:00:00
 | 824-AETNA INC. | 2011-12-12 00:00:00 | 2011-12-12 00:00:00
 | 824-AETNA INC. | 2011-12-13 00:00:00 | 2011-12-14 00:00:00
 | 824-AETNA INC. | 2011-12-15 00:00:00 | 2011-12-27 00:00:00
 | 824-AETNA INC. | 2011-12-19 00:00:00 | 2011-12-27 00:00:00
 | 824-AETNA INC. | 2011-12-26 00:00:00 | 2011-12-27 00:00:00
 | 824-AETNA INC. | 2011-12-21 00:00:00 | 2011-12-27 00:00:00
 | 824-AETNA INC. | 2011-12-29 00:00:00 | 2011-12-31 00:00:00
 | 824-AETNA INC. | 2011-12-27 00:00:00 | 2011-12-31 00:00:00
 | 824-AETNA INC. | 2011-12-28 00:00:00 | 2011-12-31 00:00:00
 | 824-AETNA INC. | 2011-12-29 00:00:00 | 2011-12-31 00:00:00
 | 824-AETNA INC. | 2011-12-30 00:00:00 | 2011-12-31 00:00:00
 | 824-AETNA INC. | 2011-12-31 00:00:00 | 2011-12-31 00:00:00
 | 824-AETNA INC. | 2012-01-05 00:00:00 | 2012-01-08 00:00:00
 | 824-AETNA INC. | 2012-01-02 00:00:00 | 2012-01-08 00:00:00
 | 824-AETNA INC. | 2012-01-03 00:00:00 | 2012-01-08 00:00:00
 | 824-AETNA INC. | 2012-01-04 00:00:00 | 2012-01-08 00:00:00
 | 824-AETNA INC. | 2012-01-05 00:00:00 | 2012-01-08 00:00:00
 | 824-AETNA INC. | 2012-01-06 00:00:00 | 2012-01-08 00:00:00
 | 824-AETNA INC. | 2012-01-07 00:00:00 | 2012-01-08 00:00:00
 | 824-AETNA INC. | 2012-01-09 00:00:00 | 2012-01-19 00:00:00
 | 824-AETNA INC. | 2012-01-13 00:00:00 | 2012-01-19 00:00:00
Same | Total for BIVINS:
 | 824-AETNA INC. | 2011-12-16 00:00:00 | 2011-12-27 00:00:00
 | 824-AETNA INC. | 2011-12-19 00:00:00 | 2011-12-27 00:00:00
 | 824-AETNA INC. | 2011-12-26 00:00:00 | 2011-12-27 00:00:00
 | 824-AETNA INC. | 2011-12-22 00:00:00 | 2011-12-27 00:00:00
 | 824-AETNA INC. | 2011-12-30 00:00:00 | 2011-12-31 00:00:00
 | 824-AETNA INC. | 2011-12-27 00:00:00 | 2011-12-31 00:00:00
 | 824-AETNA INC. | 2011-12-28 00:00:00 | 2011-12-31 00:00:00
 | 824-AETNA INC. | 2011-12-29 00:00:00 | 2011-12-31 00:00:00
 | 824-AETNA INC. | 2011-12-30 00:00:00 | 2011-12-31 00:00:00
 | 824-AETNA INC. | 2011-12-31 00:00:00 | 2011-12-31 00:00:00
 | 824-AETNA INC. | 2012-01-04 00:00:00 | 2012-01-08 00:00:00
 | 824-AETNA INC. | 2012-01-02 00:00:00 | 2012-01-08 00:00:00
 | 824-AETNA INC. | 2012-01-09 00:00:00 | 2012-01-19 00:00:00
 | 824-AETNA INC. | 2012-01-13 00:00:00 | 2012-01-19 00:00:00
 | 824-AETNA INC. | 2012-01-13 00:00:00 | 2012-01-19 00:00:00
 | 824-AETNA INC. | 2011-12-19 00:00:00 | 2012-01-23 00:00:00
 | 824-AETNA INC. | 2012-01-16 00:00:00 | 2012-01-27 00:00:00
 | 824-AETNA INC. | 2012-01-18 00:00:00 | 2012-01-27 00:00:00
 | 824-AETNA INC. | 2012-01-23 00:00:00 | 2012-01-31 00:00:00
 | 824-AETNA INC. | 2012-01-27 00:00:00 | 2012-01-31 00:00:00
Same | Total for MILGRAM:
 | 824-AETNA INC. | 2012-01-16 00:00:00 | 2012-01-27 00:00:00
 | 824-AETNA INC. | 2012-01-17 00:00:00 | 2012-01-27 00:00:00
 | 824-AETNA INC. | 2012-01-23 00:00:00 | 2012-01-31 00:00:00
 | 824-AETNA INC. | 2012-01-24 00:00:00 | 2012-01-31 00:00:00
 | 824-AETNA INC. | 2012-01-30 00:00:00 | 2012-01-31 00:00:00
 | 824-AETNA INC. | 2012-02-01 00:00:00 | 2012-02-10 00:00:00
 | 824-AETNA INC. | 2012-02-01 00:00:00 | 2012-02-10 00:00:00
 | 824-AETNA INC. | 2012-02-06 00:00:00 | 2012-02-17 00:00:00
 | 824-AETNA INC. | 2012-02-07 00:00:00 | 2012-02-17 00:00:00
 | 824-AETNA INC. | 2012-02-13 00:00:00 | 2012-02-24 00:00:00
 | 824-AETNA INC. | 2012-02-13 00:00:00 | 2012-02-24 00:00:00
Same | Total for MATHER: