• 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. J

    auto insert row, based on cell value

    Thank you, I'll look out in office 365 now
  2. J

    auto insert row, based on cell value

    Thank you so much for your kind help, can you please provide me the excel sheet you made in office 365 and can you please help me once again if you can help me in printing the same. I need the same content date wise, as the data entered was of 1 day in the sample sheet, i have the data in my...
  3. J

    auto insert row, based on cell value

    hello ninjas, I need some help again in my sheet, as I have date wise data now for all year, i need to print the data date wise like from date 01-04-2018 to 31-12-2018, can the data be automatically filtered date by date? or I have to print it day by day by manually adding date. Like I created...
  4. J

    vlookup error

    Thanks alot sir
  5. J

    vlookup error

    Help me please, I can't understand why I'm getting the error in VLOOKUP formula, If I copy paste the cell value from the table, i get proper result, but if i manually enter i get the "#N/A" error.. my previous post also got ignored. please let me know the reason, i didn't crossed rules and...
  6. J

    VLOOKUP error

    Help me please, I can't understand why I'm getting the error in VLOOKUP formula, If I copy paste the cell value from the table, i get proper result, but if i manually enter i get the "#N/A" error..
  7. J

    Amount differs in result having same voucode

    thankyou sir, i will update here if i need any help again, thanks a lot once again
  8. J

    Amount differs in result having same voucode

    thanks for your kind help, it worked, now can you please help me in the next process as if I use your formula in "V3" cell, it shows blank cell in result please help
  9. J

    Amount differs in result having same voucode

    Uploaded the sheet, please help me
  10. J

    Amount differs in result having same voucode

    Sir, with your help i updated my formulas, please check the result i get some blank values in response.
  11. J

    Amount differs in result having same voucode

    hello sir, can you please help me in this formula as i need the different amount from the table, but it shows the same amount as of previous in last line of result, Help me please please check the attached file
  12. J

    need the specific values from a table

    hello sir, can you please help me in this formula too, as i need the different amount from the table, but it shows the same amount as of previous in last line of result, Help me please
  13. J

    need the specific values from a table

    thankyou for your reply, but the array formula worked for me
  14. J

    need the specific values from a table

    thankyou for your reply Sir, but I need auto filter whenever the data is updated, by your way i have to do it manually
  15. J

    need the specific values from a table

    should I follow the same formula for all the columns & rows, to get the proper result
  16. J

    need the specific values from a table

    Hello Everyone, This is Anshum this side, and I need help as I need specific values from a table, which is updated with hourly basis with new entries, I just need specific values in return as "the amount in the table>0" . Please help me with the formula that i can update my sheet for better result.
  17. J

    month & year as result

    SOLVED THANKYOU
  18. J

    month & year as result

    you can find the month in numeric form in sheet [D2K16], with the column head name MONTHR, followed by the year in another column
  19. J

    month & year as result

    Sir, I changed that file from .xlsm to .xls, and Can I message you personally, as I didn't get the line "'following things i need' Have You follow that Yourself? If You have, then You would add those steps someway that other would too. You would use same terms in both eg where is 'month r...
  20. J

    month & year as result

    I'm uploading the file again, Please help me for the following queries below 1. automatically Month should be defined from the number as 4 = april, 5 = may 2. if the coulmn value is 0, it must pick value from the other column 3 can some words can be picked from the line, as if the line...
  21. J

    month & year as result

    sorry for everything sir, Please clear those formulas and help me for the query I wanted to get solved, It will not be repeated again
  22. J

    any help for this

    sorry for everything sir
  23. J

    month & year as result

    Sir, as the main file is of big size, like of 15 mb, I cannot upload that..coz of privacy issue, so I created a copy of that file, where i need alteration. Ignore the error and let me know if you need to know any thing else
  24. J

    month & year as result

    Please ignore that error.
  25. J

    month & year as result

    Sir, I'm not shouting to anyone, sorry for that as I was in a hurry, and my software works in capital letters only, so as i switched my screen and typed as it was.. sorry for that
Back
Top