ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   to retrieve a particular value from excel sheet (https://www.excelbanter.com/new-users-excel/191264-retrieve-particular-value-excel-sheet.html)

refina

to retrieve a particular value from excel sheet
 
PAYMENT RECEIPT BALANCE
Branch pune 0.00 4,153,150.00

01/07/2007 1 6,899,650.00
01/07/2007 2 17,308,800.00
01/07/2007 3 17,308,800.00
BranchTotal 24,218,450.00 24,208,450.00 28,351,600.00

Branch kolkatta 0.00 4,153,150.00
03/07/2007 4 110,000.00
03/07/2007 5 85,000.00
03/07/2007 6 58,200.00
03/07/2007 7 283,750.00
03/07/2007 8 324,000.00
BranchTotal 24,218,450.00 24,208,450.00 4,143,150.00




For the above sheet i should
1.get the balance 4,143,150.00 of branch total of kolkatta.
2.copy and save tat value in another excel sheet.


Please reply


refina

to retrieve a particular value from excel sheet
 
Please reply within tomarrow
refina wrote:
PAYMENT RECEIPT BALANCE
Branch pune 0.00 4,153,150.00

01/07/2007 1 6,899,650.00
01/07/2007 2 17,308,800.00
01/07/2007 3 17,308,800.00
BranchTotal 24,218,450.00 24,208,450.00 28,351,600.00

Branch kolkatta 0.00 4,153,150.00
03/07/2007 4 110,000.00
03/07/2007 5 85,000.00
03/07/2007 6 58,200.00
03/07/2007 7 283,750.00
03/07/2007 8 324,000.00
BranchTotal 24,218,450.00 24,208,450.00 4,143,150.00

For the above sheet i should
1.get the balance 4,143,150.00 of branch total of kolkatta.
2.copy and save tat value in another excel sheet.

Please reply




All times are GMT +1. The time now is 08:50 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com