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

    Highlights cells in sheets created after pivot filter automation based on condition (title edited)

    Hello I have to prepare an aging report weekly which is prepared by extracting data in a master sheet and creating a Zone wise Sheets from using Pivot Filter. How can I highlight the name of Customers in every sheets whose outstanding is above 45 days automatically. I tried with conditional...
  2. nitesh

    Pivot Table Calculated Field problem

    I have my transport rate chart as per date and location.Using index and match i have inserted Freight Rate/ton as per location and date in my master cement sheet.When i create a pivot of this data,I insert caluclated field of total qty by summing up two products qty viz OPC & PPC .in order to...
  3. nitesh

    Cash Discount Calculation using date,amount and logical arguments

    In my Industry we give 100 rupee cash discount per 1 ton cement sale within 10 days and 60 rupee cash discount per ton if the customer pays within 17 days. So every month for all customers we need to check opening balance and the payment received against billed invoice and then validate as...
  4. nitesh

    Lookup a destination fare from a range of date on the basis of Qty dispatch

    I have a volume of pivotised data having headers as date,transporter,qty,destination. i have to lookup for freight rates which keep on changing very frequently on the basis of destination and the freight for a particular period. How can i do it through excel... Date Transporter qty...
Back
Top