Search results

Sirs, I would like to sort out and copy each party's sum of sales, cash received, cheque received, discount given, goods return etc. in a new sheet. Sample file attached. Can somebody give a solution

how to make a automatically shrink and expandable table as per the data contains.

Sir I solved the problem. Thanks

I want to add data to the last empty row

http://www46.zippyshare.com/v/39105554/file.html Link is above

http://www58.zippyshare.com/v/11241576/file.html Sample excel copy link above I have more than 200 Customer Name in Database sheet. I want to search select Customer Name from sheet name Database in the sheet of Invoice-Cash-Cheque sheet at the bottom row for data entry. I would like to...

http://www32.zippyshare.com/v/86951341/file.html Sir please check sheet requirement on the workbook. 19,700.00 is repeating down.That is not required if there is no value in left row. ie from H6 there is not require. Sir, one question can we shrink and expand the table as the per data...

http://www59.zippyshare.com/v/87548378/file.html My Sample uploaded file is above. I need a help to modify the Account Statement as on Requirement sheet on the workbook. If opening balance is Credit then it should subtract from the invoice amount. If opening balance is Debit then add to...

I tried to change but not getting correct answer

Can we use if statement on this =J4+D56-K4-D57 formula for getting the same result on the same cell. regards

Thanks, Can we use IF statement with formula to get right answer instead of custom format. regards

I am using this (=J4+D56-K4-D57) formula and getting negative value, but I want this negative value to make credit suppose if the answer is -59700.00 I want the value as 59700.00 credit if the result is 59700.00 then 59700.00 debit can any one give a solution.

I GOT FORMULA SUPPOSE STOCK1,STOCK2,STOCK3 AT J4,K4,L4 CELL AND RATE ON I4 CELL THEN =IF(COUNT(J4:L4)=3,J4+K4+L4)*I4 IF ANY ONE CAN ANY OTHER FORMULA THEN GIVE ME

I want to sum and multiply value as given below. I would like to hider #value if some column contain no value Rate stock1 stock2 stock3 Amount 25 50 75 60 15 10 35 I want to multiply stock1,stock2,stock3 * rate to amount column with hide error value.

=IF(COUNTIF('Invoice-Cash-Cheque'!B:B,$B$2)<ROWS($G$6:G7),"",INDEX('Invoice-Cash-Cheque'!F:F,SMALL(IF('Invoice-Cash-Cheque'!$B$3:$B$4=$B$2,ROW('Invoice-Cash-Cheque'!$B$3:$B$4)),ROW(C2)))) How can I copy this array formula from top cell to last cell

In your solution Opening Balance not showing.

Can I copy paste this formula after Ctrl+Shift+Enter

I try to enter the formula Ctrl+Shift+Enter but result come the same.

yes I can't find a solution. I try to enter Ctrl+Shift+Enter but I can't. I don't know why? If you trying to fix with macro pls. disply all sheet one by one one sheet without any format ie border line or anything Thanks & Regar4ds

I think If it can work with macro then its good

B6=IF(COUNTIF('Invoice-Cash-Cheque'!B:B,$B$2)<ROWS($B$6:B6),"",INDEX('Invoice-Cash-Cheque'!C:C,SMALL(IF('Invoice-Cash-Cheque'!$B$3:$B$4=$B$2,ROW('Invoice-Cash-Cheque'!$B$3:$B$4)),ROW(A1))))...

Thank you so much I will check and correct as your advice. Thanks a lot.

http://www19.zippyshare.com/v/42444925/file.html @sgmpatnaik Here showing one error when I try to change the name. Why this error showing, how I can correct the formula,

Ok I got it =12.5% * (A2 / (1 + 12.5%)) where A2 388612.13

=A2*12.5/100 will come 48576.51625 Actual result need to come 43179.125