I can't find the formulas in order to display the data in green. Thank you for your kind help.

XRGI8

New Member
Joined
Jul 16, 2021
Messages
4
Office Version
  1. 365
Book1.xlsx
ABCDEFGHIJKLMNOPQ
1Sheet 1Sheet 2Sheet 3
2Account No. & Account NameDateCounterpartyTextDebitCreditAccount No.Account NameBalance (Debit)Balance (Credit)DateAccount No. (Debit)Account No. (Credit)AmountText
3
41200 AccountName12001200AccountName1200Balance1200DebitBalance1200Credit1/5/2212002000Amount1Text1
51/5/222000Text1Amount11250AccountName1250Balance1250DebitBalance1250Credit1/6/2212502500Amount2Text2
62/18/223600Text4Amount4[to be continued][to be continued][to be continued][to be continued]2/12/2212503100Amount3Text3
73/3/223400Text5Amount52/18/2212003600Amount4Text4
84/12/222500Text7Amount73/3/2234001200Amount5Text5
95/5/222000Text10Amount103/13/2233001250Amount6Text6
10[to be continued][to be continued][to be continued][to be continued][to be continued]4/12/2212002500Amount7Text7
111250 AccountName12504/14/2225001250Amount8Text8
121/6/222500Text2Amount25/4/2212502400Amount9Text9
132/12/223100Text3Amount35/5/2220001200Amount10Text10
143/13/223300Text6Amount6[to be continued][to be continued][to be continued][to be continued][to be continued]
154/14/222500Text8Amount8
165/4/222400Text9Amount9
17[to be continued][to be continued][to be continued][to be continued][to be continued]
18[to be continued]
19
20
21Text in black = formulas are already ok
22Text in green = formulas that I cannot find
Sheet1
 

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.

Forum statistics

Threads
1,215,537
Messages
6,125,386
Members
449,221
Latest member
DFCarter

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