sale

I have table Name "Table of all Data" with 6 column field <tbody> Date TY Date LY Total Available Unit This Year <tbody> Total Sale Unit This Year </tbody> <tbody> Total Available Unit Last Year </tbody> Total Sale Unit This Year 01/01/2017 01/01/2016 500 350 600 400...

Raw Data below: I need to create a report that shows: Till ID, Sales Person and Time of first sale. I have used MID to extract the till number and then used IF(AND ..... If till number = 1629 and Column C = sales then return time in column B but this has failed miserably. I want to show that...

Hi Everyone, OK so I have sale recods in sheet1 Column J is the salespersons Name and Column R is the Date the sale was made I need a formula in S2 that can tell me how many sales persons there are for the date in cell T2? So cell "T2" has a date example "21/08/2017" Now Down Column J are...

I am new to using pivot tables, so bear with me... My Data <tbody> Cust # Sale Price Return.CD 123 10 A 123 20 123 30 H </tbody> I have 3 columns in my pivot table that are all "Sum of Sale Price". I would like the first column to stay unfiltered, the second column to be filtered...

I am looking to write a macro to compare and 'match' 2 data sets. They are currently in separate sheets and consist of: Sheet 1: Sales Table with Sale Date & Sale Amount: <tbody> Sale Date Sale £ 1/8 £710 2/8 £834 3/8 £692 4/8 £672 5/8 £768 6/8 £452 7/8 £890 </tbody> Sheet...

I have two table of sale data datewise one for 2015-2016 and another for 2016-2017. In our retail chain bussiness some new location add or closed in 2016-2017. Now when i want to compare someone location with last year then what i do for sameperiod sale. Suppose xyz opened in 14 jun 2015 and...

Hello all, I have a situation where I want to be able to calculate the XIRR of given distributions, combined with proceeds of a potential sale. In order to correctly calculate the XIRR, I have to create a new row that has all distributions to date and also the proceeds dictated by that given...

Hi, I am having difficutly building a formula to distribute overall sales quotas to employees base on each employees expected phone hours. Total Sales Target : 1000 Total Employees : 15 Total Phone Hours for Dept : 2000 Employee 1 : 161 hours (8.05%) Employee 2 : 123 hours (6.15%) Employee 3 ...