Add number to cell based on another cell's value

gzell

New Member
Joined
Apr 20, 2019
Messages
37
I am trying to find a way to insert a number in Column B (Person_ID) based on Cell Column G that is Blank. Then repeat the number in Column B until reach the next blank cell in Column G. Add 1 to number and repeat, thus giving each soldier an ID number. This would Loop to the end of worksheet. There are 27,000+ rows in spreadsheet. Below Ezekiel Able would be 1 in worksheet and next soldier would be 2 and so on.

Any help would be greatly appreciated.


<tbody>
[TD="class: xl63"]Row_ID[/TD]
[TD="class: xl64, width: 70, align: left"]Person_ID[/TD]
[TD="class: xl65, width: 71"]Last Name[/TD]
[TD="class: xl65, width: 74"]First Name[/TD]
[TD="class: xl65, width: 51"]Middle[/TD]
[TD="class: xl65, width: 55"]Data_ID[/TD]
[TD="class: xl65, width: 289"]Research Data[/TD]

[TD="class: xl66"]1[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl67, align: left"]Able[/TD]
[TD="class: xl68, align: left"]Ezekiel[/TD]
[TD="class: xl68"][/TD]
[TD="class: xl69"][/TD]
[TD="class: xl70, width: 289"][/TD]

[TD="class: xl66"]2[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl67, align: left"]Able[/TD]
[TD="class: xl68, align: left"]Ezekiel[/TD]
[TD="class: xl68"][/TD]
[TD="class: xl69"]1_1[/TD]
[TD="class: xl70, width: 289, align: left"]Army: Confederacy[/TD]

[TD="class: xl66"]3[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl67, align: left"]Able[/TD]
[TD="class: xl68, align: left"]Ezekiel[/TD]
[TD="class: xl68"][/TD]
[TD="class: xl69"]1_2[/TD]
[TD="class: xl70, width: 289, align: left"]Location: Texas[/TD]

[TD="class: xl66"]4[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl67, align: left"]Able[/TD]
[TD="class: xl68, align: left"]Ezekiel[/TD]
[TD="class: xl68"][/TD]
[TD="class: xl69"]1_3[/TD]
[TD="class: xl70, width: 289, align: left"]Regiment: 10th Regiment Texas Infantry (Nelson's)[/TD]

[TD="class: xl66"]5[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl67, align: left"]Able[/TD]
[TD="class: xl68, align: left"]Ezekiel[/TD]
[TD="class: xl68"][/TD]
[TD="class: xl69"]1_4[/TD]
[TD="class: xl70, width: 289, align: left"]Function: Infantry[/TD]

[TD="class: xl66"]6[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl67, align: left"]Able[/TD]
[TD="class: xl68, align: left"]Ezekiel[/TD]
[TD="class: xl68"][/TD]
[TD="class: xl69"]1_5[/TD]
[TD="class: xl70, width: 289, align: left"]Company: C[/TD]

[TD="class: xl66"]7[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl67, align: left"]Able[/TD]
[TD="class: xl68, align: left"]Ezekiel[/TD]
[TD="class: xl68"][/TD]
[TD="class: xl69"]1_6[/TD]
[TD="class: xl70, width: 289, align: left"]Rank: Private[/TD]

[TD="class: xl66"]8[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl67, align: left"]Able[/TD]
[TD="class: xl68, align: left"]Ezekiel[/TD]
[TD="class: xl68"][/TD]
[TD="class: xl69"]1_7[/TD]
[TD="class: xl70, width: 289, align: left"]Age: Unknown[/TD]

[TD="class: xl66"]9[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl67, align: left"]Able[/TD]
[TD="class: xl68, align: left"]Ezekiel[/TD]
[TD="class: xl68"][/TD]
[TD="class: xl69"]1_8[/TD]
[TD="class: xl70, width: 289, align: left"]Residence: Unknown[/TD]

[TD="class: xl66"]10[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl67, align: left"]Able[/TD]
[TD="class: xl68, align: left"]Ezekiel[/TD]
[TD="class: xl68"][/TD]
[TD="class: xl69"]1_9[/TD]
[TD="class: xl70, width: 289, align: left"]Enrolled: Buchanan Texas[/TD]

[TD="class: xl66"]11[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl67, align: left"]Able[/TD]
[TD="class: xl68, align: left"]Ezekiel[/TD]
[TD="class: xl68"][/TD]
[TD="class: xl69"]1_10[/TD]
[TD="class: xl70, width: 289, align: left"]Date: October 16 1861[/TD]

[TD="class: xl66"]12[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl67, align: left"]Able[/TD]
[TD="class: xl68, align: left"]Ezekiel[/TD]
[TD="class: xl68"][/TD]
[TD="class: xl69"]1_11[/TD]
[TD="class: xl70, width: 289, align: left"]Enlisted: Houston Texas[/TD]

[TD="class: xl66"]13[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl67, align: left"]Able[/TD]
[TD="class: xl68, align: left"]Ezekiel[/TD]
[TD="class: xl68"][/TD]
[TD="class: xl69"]1_12[/TD]
[TD="class: xl70, width: 289, align: left"]Date: October 25 1861[/TD]

[TD="class: xl66"]14[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl67, align: left"]Able[/TD]
[TD="class: xl68, align: left"]Ezekiel[/TD]
[TD="class: xl68"][/TD]
[TD="class: xl69"]2_1[/TD]
[TD="class: xl70, width: 289, align: left"]Detail:: Hospital Nurse[/TD]

[TD="class: xl66"]15[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl67, align: left"]Able[/TD]
[TD="class: xl68, align: left"]Ezekiel[/TD]
[TD="class: xl68"][/TD]
[TD="class: xl69"]2_1[/TD]
[TD="class: xl70, width: 289, align: left"]Detail: November 8 1862[/TD]

[TD="class: xl66"]16[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl67, align: left"]Able[/TD]
[TD="class: xl68, align: left"]Ezekiel[/TD]
[TD="class: xl68"][/TD]
[TD="class: xl69"]3_1[/TD]
[TD="class: xl70, width: 289, align: left"]Relieved of Duty: Nurse[/TD]

[TD="class: xl66"]17[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl67, align: left"]Able[/TD]
[TD="class: xl68, align: left"]Ezekiel[/TD]
[TD="class: xl68"][/TD]
[TD="class: xl69"]3_1[/TD]
[TD="class: xl70, width: 289, align: left"]Date: February 4 1862[/TD]

[TD="class: xl66"]18[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl67, align: left"]Able[/TD]
[TD="class: xl68, align: left"]Ezekiel[/TD]
[TD="class: xl68"][/TD]
[TD="class: xl69"]4_1[/TD]
[TD="class: xl70, width: 289, align: left"]Captured: Battle of Arkansas Post[/TD]

[TD="class: xl66"]19[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl67, align: left"]Able[/TD]
[TD="class: xl68, align: left"]Ezekiel[/TD]
[TD="class: xl68"][/TD]
[TD="class: xl69"]4_1[/TD]
[TD="class: xl70, width: 289, align: left"]Date: January 11 1863[/TD]

[TD="class: xl66"]20[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl67, align: left"]Able[/TD]
[TD="class: xl68, align: left"]Ezekiel[/TD]
[TD="class: xl68"][/TD]
[TD="class: xl69"]4_2[/TD]
[TD="class: xl70, width: 289, align: left"]Forwarded: St. Louis Missouri via Boats[/TD]

[TD="class: xl66"]21[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl67, align: left"]Able[/TD]
[TD="class: xl68, align: left"]Ezekiel[/TD]
[TD="class: xl68"][/TD]
[TD="class: xl69"]4_3[/TD]
[TD="class: xl70, width: 289, align: left"]Forwarded: Camp Douglas Illinois via Rail[/TD]

[TD="class: xl66"]22[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl67, align: left"]Able[/TD]
[TD="class: xl68, align: left"]Ezekiel[/TD]
[TD="class: xl68"][/TD]
[TD="class: xl69"]4_4[/TD]
[TD="class: xl70, width: 289, align: left"]Prisoner: Camp Douglas Illinois[/TD]

[TD="class: xl66"]23[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl67, align: left"]Able[/TD]
[TD="class: xl68, align: left"]Ezekiel[/TD]
[TD="class: xl68"][/TD]
[TD="class: xl69"]4_5[/TD]
[TD="class: xl70, width: 289, align: left"]Died: March 7 1863[/TD]

[TD="class: xl66"]24[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl67, align: left"]Able[/TD]
[TD="class: xl68, align: left"]Ezekiel[/TD]
[TD="class: xl68"][/TD]
[TD="class: xl69"]4_5[/TD]
[TD="class: xl70, width: 289, align: left"]Cause: Small Pox[/TD]

[TD="class: xl66"]25[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl67, align: left"]Adams[/TD]
[TD="class: xl68, align: left"]John[/TD]
[TD="class: xl68, align: left"]H[/TD]
[TD="class: xl69"][/TD]
[TD="class: xl70, width: 289"][/TD]

[TD="class: xl66"]26[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl67, align: left"]Adams[/TD]
[TD="class: xl68, align: left"]John[/TD]
[TD="class: xl68, align: left"]H[/TD]
[TD="class: xl69"]1_1[/TD]
[TD="class: xl70, width: 289, align: left"]Army: Confederacy[/TD]

[TD="class: xl66"]27[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl67, align: left"]Adams[/TD]
[TD="class: xl68, align: left"]John[/TD]
[TD="class: xl68, align: left"]H[/TD]
[TD="class: xl69"]1_2[/TD]
[TD="class: xl70, width: 289, align: left"]Location: Texas[/TD]

[TD="class: xl66"]28[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl67, align: left"]Adams[/TD]
[TD="class: xl68, align: left"]John[/TD]
[TD="class: xl68, align: left"]H[/TD]
[TD="class: xl69"]1_3[/TD]
[TD="class: xl70, width: 289, align: left"]Regiment: 10th Regiment Texas Infantry (Nelson's)[/TD]

[TD="class: xl66"]29[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl67, align: left"]Adams[/TD]
[TD="class: xl68, align: left"]John[/TD]
[TD="class: xl68, align: left"]H[/TD]
[TD="class: xl69"]1_4[/TD]
[TD="class: xl70, width: 289, align: left"]Function: Infantry[/TD]

[TD="class: xl66"]30[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl67, align: left"]Adams[/TD]
[TD="class: xl68, align: left"]John[/TD]
[TD="class: xl68, align: left"]H[/TD]
[TD="class: xl69"]1_5[/TD]
[TD="class: xl70, width: 289, align: left"]Company: I[/TD]

[TD="class: xl66"]31[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl67, align: left"]Adams[/TD]
[TD="class: xl68, align: left"]John[/TD]
[TD="class: xl68, align: left"]H[/TD]
[TD="class: xl69"]1_6[/TD]
[TD="class: xl70, width: 289, align: left"]Rank: Corporal[/TD]

[TD="class: xl66"]32[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl67, align: left"]Adams[/TD]
[TD="class: xl68, align: left"]John[/TD]
[TD="class: xl68, align: left"]H[/TD]
[TD="class: xl69"]1_7[/TD]
[TD="class: xl70, width: 289, align: left"]Age: 42[/TD]

[TD="class: xl66"]33[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl67, align: left"]Adams[/TD]
[TD="class: xl68, align: left"]John[/TD]
[TD="class: xl68, align: left"]H[/TD]
[TD="class: xl69"]1_8[/TD]
[TD="class: xl70, width: 289, align: left"]Residence: Parker County Texas[/TD]

[TD="class: xl66"]34[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl67, align: left"]Adams[/TD]
[TD="class: xl68, align: left"]John[/TD]
[TD="class: xl68, align: left"]H[/TD]
[TD="class: xl69"]1_9[/TD]
[TD="class: xl70, width: 289, align: left"]Enlisted: Kimball Texas or Millican Texas[/TD]

[TD="class: xl66"]35[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl67, align: left"]Adams[/TD]
[TD="class: xl68, align: left"]John[/TD]
[TD="class: xl68, align: left"]H[/TD]
[TD="class: xl69"]1_10[/TD]
[TD="class: xl70, width: 289, align: left"]Date: January 16 1862[/TD]

[TD="class: xl66"]36[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl67, align: left"]Adams[/TD]
[TD="class: xl68, align: left"]John[/TD]
[TD="class: xl68, align: left"]H[/TD]
[TD="class: xl69"]1_13[/TD]
[TD="class: xl70, width: 289, align: left"]Captured: Battle Arkansas Post Arkansas[/TD]

[TD="class: xl66"]37[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl67, align: left"]Adams[/TD]
[TD="class: xl68, align: left"]John[/TD]
[TD="class: xl68, align: left"]H[/TD]
[TD="class: xl69"]1_13[/TD]
[TD="class: xl70, width: 289, align: left"]Date: January 11 1863[/TD]

[TD="class: xl66"]38[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl67, align: left"]Adams[/TD]
[TD="class: xl68, align: left"]John[/TD]
[TD="class: xl68, align: left"]H[/TD]
[TD="class: xl69"]1_13[/TD]
[TD="class: xl70, width: 289, align: left"]Forwarded: St. Louis Missouri via Boats[/TD]

[TD="class: xl66"]39[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl67, align: left"]Adams[/TD]
[TD="class: xl68, align: left"]John[/TD]
[TD="class: xl68, align: left"]H[/TD]
[TD="class: xl69"]1_13[/TD]
[TD="class: xl70, width: 289, align: left"]Forwarded: Camp Douglas Illinois via Rail[/TD]

[TD="class: xl66"]40[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl67, align: left"]Adams[/TD]
[TD="class: xl68, align: left"]John[/TD]
[TD="class: xl68, align: left"]H[/TD]
[TD="class: xl69"]1_13[/TD]
[TD="class: xl70, width: 289, align: left"]Prisoner: Camp Douglas Illinois[/TD]

[TD="class: xl66"]41[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl67, align: left"]Adams[/TD]
[TD="class: xl68, align: left"]John[/TD]
[TD="class: xl68, align: left"]H[/TD]
[TD="class: xl69"]1_13[/TD]
[TD="class: xl70, width: 289, align: left"]Forwarded for Exchanged: City Point Virginia[/TD]

[TD="class: xl66"]42[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl67, align: left"]Adams[/TD]
[TD="class: xl68, align: left"]John[/TD]
[TD="class: xl68, align: left"]H[/TD]
[TD="class: xl69"]1_13[/TD]
[TD="class: xl70, width: 289, align: left"] Date: April 10 1863[/TD]

[TD="class: xl66"]43[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl67, align: left"]Adams[/TD]
[TD="class: xl68, align: left"]John[/TD]
[TD="class: xl68, align: left"]H[/TD]
[TD="class: xl71"][/TD]
[TD="class: xl72, width: 289, align: left"]Hospital: Sick[/TD]

[TD="class: xl66"]44[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl73, align: left"]Adams[/TD]
[TD="class: xl74, align: left"]John[/TD]
[TD="class: xl74, align: left"]H[/TD]
[TD="class: xl71"][/TD]
[TD="class: xl72, width: 289, align: left"]Location: Kingston Georgia[/TD]

[TD="class: xl66"]45[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl73, align: left"]Adams[/TD]
[TD="class: xl74, align: left"]John[/TD]
[TD="class: xl74, align: left"]H[/TD]
[TD="class: xl71"][/TD]
[TD="class: xl72, width: 289, align: left"]Date: March 22 1864[/TD]

[TD="class: xl66"]46[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl73, align: left"]Adams[/TD]
[TD="class: xl74, align: left"]John[/TD]
[TD="class: xl74, align: left"]H[/TD]
[TD="class: xl69"][/TD]
[TD="class: xl70, width: 289, align: left"]Captured: Franklin Tennessee[/TD]

[TD="class: xl66"]47[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl67, align: left"]Adams[/TD]
[TD="class: xl68, align: left"]John[/TD]
[TD="class: xl68, align: left"]H[/TD]
[TD="class: xl69"][/TD]
[TD="class: xl70, width: 289, align: left"]Date: November 30 1864[/TD]

[TD="class: xl66"]48[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl67, align: left"]Adams[/TD]
[TD="class: xl68, align: left"]John[/TD]
[TD="class: xl68, align: left"]H[/TD]
[TD="class: xl69"][/TD]
[TD="class: xl70, width: 289, align: left"]Forwarded: Nashville Tennessee[/TD]

[TD="class: xl66"]49[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl67, align: left"]Adams[/TD]
[TD="class: xl68, align: left"]John[/TD]
[TD="class: xl68, align: left"]H[/TD]
[TD="class: xl69"][/TD]
[TD="class: xl70, width: 289, align: left"]Forwarded: Louisville Kentucky[/TD]

[TD="class: xl66"]50[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl67, align: left"]Adams[/TD]
[TD="class: xl68, align: left"]John[/TD]
[TD="class: xl68, align: left"]H[/TD]
[TD="class: xl69"][/TD]
[TD="class: xl70, width: 289, align: left"]Arrived: December 3 1864[/TD]

[TD="class: xl66"]51[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl67, align: left"]Adams[/TD]
[TD="class: xl68, align: left"]John[/TD]
[TD="class: xl68, align: left"]H[/TD]
[TD="class: xl69"][/TD]
[TD="class: xl70, width: 289, align: left"]Forwarded: Camp Douglas Illinois[/TD]

[TD="class: xl66"]52[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl67, align: left"]Adams[/TD]
[TD="class: xl68, align: left"]John[/TD]
[TD="class: xl68, align: left"]H[/TD]
[TD="class: xl69"][/TD]
[TD="class: xl70, width: 289, align: left"]Date: December 3 1863[/TD]

[TD="class: xl66"]53[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl67, align: left"]Adams[/TD]
[TD="class: xl68, align: left"]John[/TD]
[TD="class: xl68, align: left"]H[/TD]
[TD="class: xl69"][/TD]
[TD="class: xl70, width: 289, align: left"]Arrived: December 6 1863[/TD]

[TD="class: xl66"]54[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl67, align: left"]Adams[/TD]
[TD="class: xl68, align: left"]John[/TD]
[TD="class: xl68, align: left"]H[/TD]
[TD="class: xl69"][/TD]
[TD="class: xl70, width: 289, align: left"]Oath of Alegiance: June 18 1865[/TD]

[TD="class: xl66"]55[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl67, align: left"]Adams[/TD]
[TD="class: xl68, align: left"]Peter[/TD]
[TD="class: xl68, align: left"]L[/TD]
[TD="class: xl69"][/TD]
[TD="class: xl70, width: 289"][/TD]

[TD="class: xl66"]56[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl67, align: left"]Adams[/TD]
[TD="class: xl68, align: left"]Peter[/TD]
[TD="class: xl68, align: left"]L[/TD]
[TD="class: xl69"]1_1[/TD]
[TD="class: xl70, width: 289, align: left"]Army: Confederacy[/TD]

[TD="class: xl66"]57[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl67, align: left"]Adams[/TD]
[TD="class: xl68, align: left"]Peter[/TD]
[TD="class: xl68, align: left"]L[/TD]
[TD="class: xl69"]1_2[/TD]
[TD="class: xl70, width: 289, align: left"]Location: Texas[/TD]

[TD="class: xl66"]58[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl67, align: left"]Adams[/TD]
[TD="class: xl68, align: left"]Peter[/TD]
[TD="class: xl68, align: left"]L[/TD]
[TD="class: xl69"]1_3[/TD]
[TD="class: xl70, width: 289, align: left"]Regiment: 10th Regiment Texas Infantry (Nelson's)[/TD]

[TD="class: xl66"]59[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl67, align: left"]Adams[/TD]
[TD="class: xl68, align: left"]Peter[/TD]
[TD="class: xl68, align: left"]L[/TD]
[TD="class: xl69"]1_4[/TD]
[TD="class: xl70, width: 289, align: left"]Function: Infantry[/TD]

[TD="class: xl66"]60[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl67, align: left"]Adams[/TD]
[TD="class: xl68, align: left"]Peter[/TD]
[TD="class: xl68, align: left"]L[/TD]
[TD="class: xl69"]1_5[/TD]
[TD="class: xl70, width: 289, align: left"]Company: D[/TD]

[TD="class: xl66"]61[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl67, align: left"]Adams[/TD]
[TD="class: xl68, align: left"]Peter[/TD]
[TD="class: xl68, align: left"]L[/TD]
[TD="class: xl69"]1_6[/TD]
[TD="class: xl70, width: 289, align: left"]Rank: Private[/TD]

[TD="class: xl66"]62[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl67, align: left"]Adams[/TD]
[TD="class: xl68, align: left"]Peter[/TD]
[TD="class: xl68, align: left"]L[/TD]
[TD="class: xl69"]1_7[/TD]
[TD="class: xl70, width: 289, align: left"]Age: --[/TD]

[TD="class: xl66"]63[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl67, align: left"]Adams[/TD]
[TD="class: xl68, align: left"]Peter[/TD]
[TD="class: xl68, align: left"]L[/TD]
[TD="class: xl69"]1_8[/TD]
[TD="class: xl70, width: 289, align: left"]Residence: --[/TD]

[TD="class: xl66"]64[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl67, align: left"]Adams[/TD]
[TD="class: xl68, align: left"]Peter[/TD]
[TD="class: xl68, align: left"]L[/TD]
[TD="class: xl69"]1_9[/TD]
[TD="class: xl70, width: 289, align: left"]Enrolled: Fairfield Freestone County Texas[/TD]

[TD="class: xl66"]65[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl67, align: left"]Adams[/TD]
[TD="class: xl68, align: left"]Peter[/TD]
[TD="class: xl68, align: left"]L[/TD]
[TD="class: xl69"]1_10[/TD]
[TD="class: xl70, width: 289, align: left"]Date: October 26 1861[/TD]

[TD="class: xl66"]66[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl67, align: left"]Adams[/TD]
[TD="class: xl68, align: left"]Peter[/TD]
[TD="class: xl68, align: left"]L[/TD]
[TD="class: xl69"]1_11[/TD]
[TD="class: xl70, width: 289, align: left"]Enlisted: Hempstead Texas[/TD]

[TD="class: xl66"]67[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl67, align: left"]Adams[/TD]
[TD="class: xl68, align: left"]Peter[/TD]
[TD="class: xl68, align: left"]L[/TD]
[TD="class: xl69"]1_12[/TD]
[TD="class: xl70, width: 289, align: left"]Date: October 31 1863[/TD]

[TD="class: xl66"]68[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl67, align: left"]Adams[/TD]
[TD="class: xl68, align: left"]Peter[/TD]
[TD="class: xl68, align: left"]L[/TD]
[TD="class: xl69"][/TD]
[TD="class: xl68, align: left"]Absent: January 1862-April 1864[/TD]

[TD="class: xl66"]69[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl67, align: left"]Adams[/TD]
[TD="class: xl68, align: left"]William[/TD]
[TD="class: xl68, align: left"]L[/TD]
[TD="class: xl69"][/TD]
[TD="class: xl70, width: 289"][/TD]

[TD="class: xl66"]70[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl67, align: left"]Adams[/TD]
[TD="class: xl68, align: left"]William[/TD]
[TD="class: xl68, align: left"]L[/TD]
[TD="class: xl69"]1_1[/TD]
[TD="class: xl70, width: 289, align: left"]Army: Confederacy[/TD]

[TD="class: xl66"]71[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl67, align: left"]Adams[/TD]
[TD="class: xl68, align: left"]William[/TD]
[TD="class: xl68, align: left"]L[/TD]
[TD="class: xl69"]1_2[/TD]
[TD="class: xl70, width: 289, align: left"]Location: Texas[/TD]

[TD="class: xl66"]72[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl67, align: left"]Adams[/TD]
[TD="class: xl68, align: left"]William[/TD]
[TD="class: xl68, align: left"]L[/TD]
[TD="class: xl69"]1_3[/TD]
[TD="class: xl70, width: 289, align: left"]Regiment: 10th Regiment Texas Infantry (Nelson's)[/TD]

[TD="class: xl66"]73[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl67, align: left"]Adams[/TD]
[TD="class: xl68, align: left"]William[/TD]
[TD="class: xl68, align: left"]L[/TD]
[TD="class: xl69"]1_4[/TD]
[TD="class: xl67, align: left"]Function: Infantry[/TD]

[TD="class: xl66"]74[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl75, align: left"]Adams[/TD]
[TD="class: xl68, align: left"]William[/TD]
[TD="class: xl68, align: left"]L[/TD]
[TD="class: xl69"]1_5[/TD]
[TD="class: xl67, align: left"]Company: D[/TD]

[TD="class: xl66"]75[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl75, align: left"]Adams[/TD]
[TD="class: xl68, align: left"]William[/TD]
[TD="class: xl68, align: left"]L[/TD]
[TD="class: xl69"]1_6[/TD]
[TD="class: xl67, align: left"]Rank: Private[/TD]

[TD="class: xl66"]76[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl75, align: left"]Adams[/TD]
[TD="class: xl68, align: left"]William[/TD]
[TD="class: xl68, align: left"]L[/TD]
[TD="class: xl69"]1_7[/TD]
[TD="class: xl67, align: left"]Age: --[/TD]

[TD="class: xl66"]77[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl75, align: left"]Adams[/TD]
[TD="class: xl68, align: left"]William[/TD]
[TD="class: xl68, align: left"]L[/TD]
[TD="class: xl69"]1_8[/TD]
[TD="class: xl67, align: left"]Residence: --[/TD]

[TD="class: xl66"]78[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl75, align: left"]Adams[/TD]
[TD="class: xl68, align: left"]William[/TD]
[TD="class: xl68, align: left"]L[/TD]
[TD="class: xl69"]1_11[/TD]
[TD="class: xl67, align: left"]Enlisted: Camp Brazos Texas[/TD]

[TD="class: xl66"]79[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl75, align: left"]Adams[/TD]
[TD="class: xl68, align: left"]William[/TD]
[TD="class: xl68, align: left"]L[/TD]
[TD="class: xl76"]1_12[/TD]
[TD="class: xl67, align: left"]Date: April 1 1862[/TD]

[TD="class: xl66"]80[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl77, align: left"]Adams[/TD]
[TD="class: xl74, align: left"]William[/TD]
[TD="class: xl74, align: left"]L[/TD]
[TD="class: xl69"][/TD]
[TD="class: xl74, align: left"]Hospital: Sick[/TD]

[TD="class: xl66"]81[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl73, align: left"]Adams[/TD]
[TD="class: xl74, align: left"]William[/TD]
[TD="class: xl74, align: left"]L[/TD]
[TD="class: xl71"][/TD]
[TD="class: xl74, align: left"]Location: Brownsville Arkansas[/TD]

[TD="class: xl66"]82[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl67, align: left"]Adams[/TD]
[TD="class: xl74, align: left"]William[/TD]
[TD="class: xl74, align: left"]L[/TD]
[TD="class: xl71"][/TD]
[TD="class: xl74, align: left"]Date: June 17 1862[/TD]

[TD="class: xl66"]83[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl67, align: left"]Adams[/TD]
[TD="class: xl74, align: left"]William[/TD]
[TD="class: xl74, align: left"]L[/TD]
[TD="class: xl69"][/TD]
[TD="class: xl68, align: left"]Absent: January 1863-April 1864[/TD]

</tbody>
 
You're welcome & thanks for the feedback
 
Upvote 0

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).

Forum statistics

Threads
1,223,903
Messages
6,175,284
Members
452,630
Latest member
OdubiYouth

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top