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

    3 Filters Formula

    Dear sirs, Please help me the following question. Thank you very much. Each customer in Table IV has multiple accounts. The amount due for the accounts for the first six months of different financial years are provided in the table. The user will enter the Customer Number, the Account Number...
  2. G

    Help with multiple filters

    Hi Sirs Table III has data on the quantity ordered for certain products. These products have a product code along with a classifier L or R. There are two records for each product code, one for L and the other for R. The user will enter the product code and the classifier (L or R) in the cells...
  3. G

    Lookup customers

    Hi sirs, I have a data of customers with order no and I need to look them up using excel formulae. Your help would be greatly appreciated. Thanks!
  4. G

    Formula to produce multiple filters

    Thank you sir. Really appreciate such a quick response
  5. G

    Formula to produce multiple filters

    Dear sirs, The file Lookuptwocolumns.xlsx gives the model, year, and price for each of a series of cars. Set up formulas that enable you to enter the model and year of a car and return its price. I was able to do this by add a new column with the concatenation. Is there a way to do this...
  6. G

    Sums of multiple rows through Offset

    Thank you sir for your comprehensive replies. Really appreciated!
  7. G

    Sums of multiple rows through Offset

    Hi all, I have that contains sales data for a product P1, P2 or P3 from January to July. Suppose we enter a month and a product into our worksheet. Please help me with a formula using OFFSET that will give the total sales of that product in the given month
  8. G

    Create Backup Copy using Excel VBA

    Thanks YK for this code. Helped me a ton and my client was very happy with it. :)
  9. G

    Create Backup Copy using Excel VBA

    Hi All, I wanted to create a backup copy before I run the subroutines Ive written for my file. Ive used the following code. path_new = ActiveWorkbook.Path ActiveWorkbook.SaveAs Filename:=path_new & "\Backup_Copy" The problem is it closes the original file and runs the macros created...
  10. G

    Excel VBA: Creation of Array

    Hi Narayan, It worked perfectly. Thank you for your time and knowledge. :)
  11. G

    Excel VBA: Creation of Array

    Hi All, I have a number stored in FromMonth Variable(Say) Eg. FromMonth = 5. Now I need all the natural numbers less than and equal to 5 in an array and then pass into into the autofilter field. Your help would be greatly appreciated. Thanks,
  12. G

    Fuzzy Name Match Lookup

    Hi, I need help in lookup of a variable in another file where the mapping may have slightly different values. For eg.. ALP MANUFACTURING in one file and ALP MANU LTD. 1234556566 in the other file where I need the Number in the first file. I cant download the excel extension...
  13. G

    Need help with filtering on data

    Would like to know also if we can somehow extract top 10 rows out of the main data on to somewhere else for similar operations as done already but just on the top 10. Thanks.
  14. G

    Need help with filtering on data

    Yes, this is what I was looking for. Thanks. This is very helpful.
  15. G

    Need help with filtering on data

    Hi, So as you can see the reco_all is a string value(say UPSCALE,BUSINESS,3) Now, what I want is to use the filters provided by the users to filter out all the data and give me the recommendation which occurs the maximum number of times.(In SUMIFS I was able to calculate for numerical data as...
  16. G

    Need help with filtering on data

    Hi, Thanks for the reply. I dont really want to do it using pivots. Is there a way around it? The reason why I dont want to do it that way is because pivots created in Excel 2007 are a row below those created in 2010 which causes issues when clients use different versions. Thanks in advance.
  17. G

    Need help with filtering on data

    Hi All, I have uploaded a file and I need some help regarding the application of filters on my data. In the U column you can see the values over which my filter needs to work.For finding out summation of a column I used SUMIFS which is working just fine. Now I have 2 questions: 1. How can I use...
  18. G

    Excel Dashboard using VBA

    Hi all, I'm very new to Excel VBA but have a beginner knowledge of VBA. I've been asked where I work to create a dashboard in Excel using VBA. They have data and I have to create dynamic charts and everything. Taking options from user using drop downs and everything. I wanted to know where to...
  19. G

    Unique Square

    Got it. My bad
  20. G

    Unique Square

    Anybody? Please help needed
  21. G

    Unique Square

    1. square grid with no of rows = cols = r, containing integers 1, 2, 3 …, r2 occupying the different cells,one integer per cell, so the sum of integers in each row= the sum of integers in each column = the sum of integers in each of the two diagonals. 2. for r>3 the algo is: 1. Empty all the...
  22. G

    User form entry into a word file

    This works just fine. Thanks a ton sir. I'm really indebted.
  23. G

    User form entry into a word file

    Hi, I did go through this solution. Is there any way to achieve this without opening word? For eg. I have Data on a spreadsheet like Amulya(Name) and AI989(flight) Now, I want to create a word doc about this like with a some font like: Hi Amulya, We are pleased to inform that your flight...
  24. G

    User form entry into a word file

    Hi all, I want to create a word doc like an air plane ticket using data I'm getting from a user form. I have already created the user form. Wanted help in creation of the word doc. Your help will be sincerely appreciated. Thanks.
  25. G

    Travelling Salesman Problem

    Hi, Newbie here. I'm looking for a solution to the salesman problem where the algo is minimum of each row. For eg. 1 2 3 4 1 - 7 8 3 2 7 - 5 1 3 8 5 - 4 4 3 1 5 - We have 4 places to go 1,2,3,4 and then we've to come back to 1. In this, the guy will go from 1 to 4...
Back
Top