anybody expert in Microsoft excel and kindly give me an idea for below requirement.

Question

Need to do like below in 3rd column using excel formula and debit same amount should follow same credit amount in next like as look like in (REQUIRED DATA)

Sr    current data    required data
1     (300.00)             (300.00)
2     550.00               300.00
3     450.00              (425.00)
4     425.00               425.00
5     300.00              (450.00)
6     (425.00)              450.00
7     (550.00)             (550.00)
8     (450.00)              550.00

Comments

I don't get your question well; but you better check out the statistical functions given in Excel