Basic Questions !

[Deepak Sharma]

Hello Everyone, Hope you all are doing well!

I have a data sheet, in which I have few questions to solve using formulas.
I also need few more questions which involve good formulas to solve.
Is there anyone can tell how to do forecasting on the basis of previous sales?
Is there any macro we can apply to run any command in this workbook?

I have today's deadline actually! Please suggest !

Thanks & Regards,

 

[NARAYANK991]

Hi ,

The answer to question 1 is not 445 because there are duplicate entries against order IDs ; to get a unique count of orders , use the following array formula , to be entered using CTRL SHIFT ENTER :

=SUM(IF(Data!$G$2:$G$2000 = "High", 1/COUNTIFS(Data!$G$2:$G$2000, "High", Data!$B$2:$B$2000, Data!$B$2:$B$2000)))

Narayan

 

[Deepak Sharma]

Sure ! Thanks, Narayan, Can you please tell the answers to other questions ?

 

[Deepak Sharma]

Can anyone please reply to these questions as I have some deadline to finish it off......

Regards,