# Search results

1. ### Finding Out Percent of Lines Open...

Is this what you want?
2. ### Based on Item number need to find matching debit credit one on one value

Hi Pascal, Not a summary actually, I just want to remove matching debit credit in each item number, Mr. Bosco's solution is working if there is no item number but If item number 166510152 has debit 500 and 166510153 has 500 credit it should not eliminate the formula should check matching debit...
3. ### Based on Item number need to find matching debit credit one on one value

Hi, Help to modify the formula Based on the Item number need to find matching debit credit one on one value. The formula solution provided by Mr. Bosco is attached. Regards, PaVi

Thanks

Ok Thanks
6. ### Need to eliminate matching amount either in debit credit or in netting

Thanks, Bosco it's working fine, but my question is if the same amount is there in a different item then it will not give the correct output. Can we match the item number also in the formula?
7. ### Need to eliminate matching amount either in debit credit or in netting

Hi All, Need the formula to find the matching amount in debit credit or netting based on Item Number. Thanks in advance for your support and help. Regards, PaVi
8. ### Backlog value distribution year wise as per Contract end date

Thank you p45cal, work perfectly, I will learn this formula
9. ### Backlog value distribution year wise as per Contract end date

Hi, Need the formula to distribute backlog value year-wise as per the end date. I really appreciate any help you can provide. Sample file attached. Regards, PaVi
10. ### Need formula help

Thanks vletm... work fine and sorry for title next time I will use better title. Thanks
11. ### Need formula help

Hi, I have two sheet in one sheet I have Total CTC for each employe in other sheet Jobwise number of hour each employee work in particular job, So I want to distribute the total CTC amount to each job. Sample fine attached with required output. Thanks in advance. Regards, Pavi
12. ### Pivot Formatting

Thanks for your effort sir I am copy paste on same pivot that's why it's not working. In earlier version pivot not loosing Auto formatting when I am copy paste value.
13. ### Pivot Formatting

Yes original copy have format but after copy paste special value pivot lose the format and paste special format is not working.
14. ### Pivot Formatting

Thanks for your reply If I am making pivot to value it's loosing it's format how can I again paste format when there is no formatting left.
15. ### Pivot Formatting

Hi, Please help I am using Excel 2019 and using AutoFormat for Pivot table when i am converting pivot using paste special Value pivot is loosing its formatting. Thanks, Parvez
16. ### Need Formula help for current value

Thanks this too working
17. ### Need Formula help for current value

Thanks alot perfect fit :)
18. ### Need Formula help for current value

Hi, Please help me to solve the formula for my dashboard. I have spreadsheet where I will update the price daily I want current value column U should calculate the last updated price. Sample file attached. Thanks, pAvi
19. ### Need help to fill the date from begin of page

Thanks Nebu this also working
20. ### Need help to fill the date from begin of page

Thanks Navic working fine
21. ### Need help to fill the date from begin of page

Hi, Need formula help to fill the date from the begin of page as per sample file. Regards, pAvi

Thanks
23. ### Need desire output using Vlookup

=IF(COUNTIFS(A\$2:A2,A2,B\$2:B2,B2)=1,VLOOKUP(A2&B2,IF({1,0,0},INDEX(Sheet2!\$A\$4:\$A\$6&Sheet2!\$B\$4:\$B\$6,0),Sheet2!\$A\$4:\$C\$6),3,0),0) Formula is not working for my actual data as my data have many column. I didn't understand the underlined IF. Please explain. and customer number is unique so...
24. ### Need desire output using Vlookup

Hi all, I want desire output using vlookup for multiple value in data table. Sample attached. Thanks pAvi

Thanks.