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

Recent content by Khurrum

  1. K

    bank reconciliation

    any thought how to crack it by simple excel program.
  2. K

    Confused and need help putting salary formula's together

    Sorry Robie got it late. Dont know, is it what you looking for?
  3. K

    Highest & lowest sales value (by Region,Salesperson & Product)

    Thanks a lot Mr. Sumendra. I find your formula work fine but again you pointed it right in case of duplicates it will change the whole scenario all together, may be "total sales value" achieved by a sales person in all regions may be the final argument, if it not be further duplicated...
  4. K

    Highest & lowest sales value (by Region,Salesperson & Product)

    Mr. Somendra, BY CONDITIONAL FORMATTING WE WOULD HIDE UNWANTED CELLS RIGHT, BUT WE NEED A FORMULA AS YOU RIGHTLY SAID, GIVE US, 'SINGLE CELL SOLUTION'. IF THIS EVEN DONE, IT WILL ACHIEVE ITS GOAL. In essence we need to do 3 things - evaluate all possible single sales values highest or lowest...
  5. K

    Highest & lowest sales value (by Region,Salesperson & Product)

    Mr. Somendra & all members Is it possible with IF(AND).... statement or any other method matching new range name comprise of (North,East,West,South) as RegionCriteria matching each record under the existing range name as Region or =MMULT(), =CHOOSE(), ROW() or COLUMN() functions or any method...
  6. K

    Highest & lowest sales value (by Region,Salesperson & Product)

    Pivot table make another database, that I told you before.
  7. K

    Highest & lowest sales value (by Region,Salesperson & Product)

    You are right Somendra. But reason is this I have more than 100000 lines of data of about 26 salespersons, with over 15 products how is it possible to show (26 x 4) 104 lines for each sales person, and 6 other similar variables for other analysis. If I change the format it is like a another...
  8. K

    Highest & lowest sales value (by Region,Salesperson & Product)

    Sorry Somendra You are free to provide the results, anywhere, but use the format of the expected result. Input Sales Data is there Expected Result table is there Pivot table is there to check my requirement. You can check this file again
  9. K

    Highest & lowest sales value (by Region,Salesperson & Product)

    Thanks Mr. Somendra I appreciate your work and time. But I think you used "results" as variables, and therefore, results are not achieved, but atleast it moved to one of the required steps. I need to know how to get single highest and lowest sales value under 1 instance or it is not...
  10. K

    Highest & lowest sales value (by Region,Salesperson & Product)

    Hello, PFA excel file. Looking for a single cell formula (possible an array formula) whereby I could determine highest and single sales value, to guage sales performance by region, salesperson and product. The problem is already solved by a Pivot table, but I want it to be dynamic in the event...
  11. K

    To do list

    Mr. Maqsood What is your main goal to acheive? Why don't you have 3 different colour bars for each priority & one for total which gives more clarity towards your goal to achieve.
  12. K

    Dynamic array formula required for placing top 5 records under specific area/name

    Mr. Narayan I appreciate your concerns. But the reason for using 'aggregate' instead is, it gives lot of functionality/options, which always helpful in case of error triggers during mapping of long spreadsheets, though it is going away from the usual. Regards, Khurrum
  13. K

    Dynamic array formula required for placing top 5 records under specific area/name

    Thanks Mr. Parsad DN Your formula works for me, fine.
  14. K

    Hi Narayan I posted my query [extracting top 5 records out of a given range/criteria, using an...

    Hi Narayan I posted my query [extracting top 5 records out of a given range/criteria, using an array formula] but no response. If you could help me please let me know. Thanks in advance Khurrum
Back
Top