• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. A

    Joining Two Single Columnar Table based on only 2 conditions

    This is the output I am looking for. I want to create the Dynamic TOP N Table. Thanks Ashish Mehra
  2. A

    Goodly Top N Anomaly

    Link: Display Top N items and Others in Power BI - Goodly Hi all, I have a similar workaround to show "Others" as shown in the above shared url from one of the example shared by Chandeep Chabra. Concern 1: I used few Slicers Year, Month, Category & Top N Value. Here no value is showing in...
  3. A

    Monthly Comparison - Visual

    Hi Team, We have monthly data with multiple attributes. Requirement: If we select "Customer A" then visual will share / tell the driving factors behind "Sales" Movement. Any query let me know. Regards Ashish Mehra
  4. A

    Identify Back Date Entry / Deals - Volume Report

    Hi Deepak, I have shared sample data for Volume till July & August with Output format of Volume Report. The logic is once the Volume Report is made, this will be freeze. There will not be any change. Regards, AM
  5. A

    Identify Back Date Entry / Deals - Volume Report

    Hi, We are facing 3 issues as of now: 1) Back Date Entry posted in system 2) Change in Loan Amount 3) Change in Loan Start Date column Explaination: Point# 1) There is a bug in our system that is allowing back date entry posting manually in system by Operation team. Till the system is...
  6. A

    Interest Amount vba code

    Hi all, With reference to https://chandoo.org/forum/threads/interest-amount.39794/#post-238138 I have attached sample dataset in Data worksheet. Desired output is mentioned for Loan A/C ACXXX01 in Required Output worksheet. Can someone help me the output through vba code. Regards, AM
  7. A

    Interest Amount

    Thanks all. Attached is the output. Thread closed.
  8. A

    Interest Amount

    Hi, I have attached sample dataset in Data worksheet. Desired output is mentioned for Loan A/C ACXXX01 in Required Output worksheet. Calculation is done in Pivot Report worksheet. Here logic is: For Loan A/C ACXXX01; Start Date = Report Run Date - DPD / Ageing Output will be 24 days of...
  9. A

    Vlookup with Choose

    Hi, I am using code to get second instance of lookup value. =vlookupAM(A2,$A$2:$B$20,2) Function vlookupAM(Lookupvalue As String, LookupRange As Range, ColumnNumber As Integer) Dim i As Long Dim Result As String For i = 1 To LookupRange.Columns(1).Cells.Count If LookupRange.Cells(i, 1) =...
  10. A

    Invoice Automation

    @Deepak Thanks for your time but this is not my requirement. Output template has 4 sheets & Invoice-Leasing sheet is one of them.
  11. A

    Invoice Automation

    @vletm Invoice number as User-ID ... Ans: Got it What about next time? Do You really use always same Invoice number? Ans: I have reconfirm from concern person. How do You know which Invoice (number) has completed and which not? Ans: We are in stage 1 of this project. I will enquire on this...
  12. A

    Invoice Automation

    @vletm Sorry for confusion I read Company as Client. Initially, I thought of concatenating Company & State & use as unique identifier but as per suggestion from Deepak about taking Invoice number as Unique identifier. I drop my idea & taken Invoice number (Col AI). 1st User-ID >> after that...
  13. A

    Invoice Automation

    @vletm I got it wrong. Unique identifier is Invoice number (Col AI). Files are attached.
  14. A

    Invoice Automation

    Yes, Invoice is unique. I got it wrong of concatenating Company & State. The idea is from list of unique Invoice number, we have to create multiple templates saved on desktop folder. Regards AM
  15. A

    Invoice Automation

    Dear Deepak, Yes you are right. I have started this project, I will take care of any novice activity. In Invoice Base file there are Company (Col Z) & State (Col AF), if we concatenate them then we can have unique identifier. As requirement is to generate invoice on the basis of Company &...
  16. A

    http://forum.chandoo.org/threads/invoice-automation.35159/ Pl help

    http://forum.chandoo.org/threads/invoice-automation.35159/ Pl help
  17. A

    Narayan Sir Pl help http://forum.chandoo.org/threads/invoice-automation.35159/

    Narayan Sir Pl help http://forum.chandoo.org/threads/invoice-automation.35159/
  18. A

    Invoice Automation

    Hello all, I have attached couple of workbooks, Invoice Base & Invoice Format. Working: Invoice Base fIle has 2 sheets, from each of the sheet 2 sheets needs to be populated in Invoice Format file. I have used links for sample/demo point. There are 30 + fields in each of the sheet. To start...
  19. A

    Extracting email ids

    Split is working superb. Just one line code. Really interested in knowing the output from INSTR for future reference. Regards AM
  20. A

    Macro to change color of the cell of specific column

    Thanks Sir JB I will make note of your kind words.
  21. A

    Macro to change color of the cell of specific column

    Sir JB7 You are a nice man!
  22. A

    Extracting email ids

    @Deepak Can you please post through VBA code
  23. A

    Extracting email ids

    Hi I have list of mail IDs in column A; Mail Ids ashish@gmail.com sachin@rediffmail.com hello@chandoo.com Result in column B Domain Gmail rediffmail Chandoo
  24. A

    Macro to change color of the cell of specific column

    OK Chihiro n thanks for definition.
  25. A

    Macro to change color of the cell of specific column

    I respect your views but it depends on how you take it
Back
Top