Add number to cell based on another cell's value

G

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>
 

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off
Sort by date Sort by votes
How about in B2 copied down
=COUNTIF(G$2:G2,"")
 
Upvote 0
Hello,

In cell B3, you can try =IF(AND(C3=C2,D3=D2),B2+1,B3)

Hope this will help
 
Last edited:
Upvote 0
thanks for the info. But I am trying to get this through 27,000 rows with number changing based on another cell's value (empty)
 
Upvote 0
Did you try either of the solutions offered?
If so did they work? If not, in what way did they not work?
 
Upvote 0
Tried James suggestion. It places 1 in cell B4. I would like to give each person a id number. Ezekiel Able would have a 1 for in column B for each row associated with his name, John Adams would be 2, etc. Sorry for not making this clear in the original post.
 
Upvote 0
gzell said:
Tried James suggestion. It places 1 in cell B4. I would like to give each person a id number. Ezekiel Able would have a 1 for in column B for each row associated with his name, John Adams would be 2, etc. Sorry for not making this clear in the original post.
Click to expand...

Tested with your sample data... looks like it does generate your expected results ...
 
Last edited:
Upvote 0
@James006
With your formula I get the numbers 1 to 23 in B3:B25 & then nothing but 1s thereafter.
That's not to mention the circular references error.
 
Upvote 0
yes, I tried it. works as expected. thanks. I am trying to find a solution that will number all rows for each individual. Thank you for the response.
 
Upvote 0
You must log in or register to reply here.

Similar threads

G
  • Question Question
copy/paster to another worksheet
Replies
5
Views
775
Fluff
Fluff
G
  • Solved
Cut/Paste to new Worksheet
Replies
3
Views
475
gzell
G
G
  • Question Question
Row to Column + Data
Replies
5
Views
486
Fluff
Fluff
G
  • Question Question
Transpose Rows to Columns
2
Replies
10
Views
970
Peter_SSs
Peter_SSs
G
  • Solved
Clear Content based on another cell value (Empty)
Replies
7
Views
552
Fluff
Fluff

Forum statistics

Threads
1,223,893
Messages
6,175,240
Members
452,621
Latest member
Laura_PinksBTHFT

Share this page

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