# warehouse- sales problem -statistics.

• There are 2 kind of things to sale and to srorage, of course, so the warehouse is divide in two sides, electronics (probills numbers are evens) and clothes (are odds). Some products have excellent sales rank (from 67% to 100), normal (34 to 66) and poor (1 to 33).
Sales department problem. Show the list of numbers ( from 59), taken 6 at the time that have the rank and type, means two excellent, 2 normal, 2 poor, and 3odds, 3 evens, this list create balance sales. They have to sale everything not only the electronics (evens) or clothes (odds) and the excellents and poors.
example:
probill # 2 - 4- 6---3---5---7
rank 67 100 34 66 1 33 easy first look 2 high,average,low rank
and also odds and even. that' balance
in the market. first I don't know how to write a vba code, and I post only here and here only nowhere-else.

• Re: warehouse- sales problem -statistics.

with all respect, somebody can answer if I can post my problem, and maybe, got some brief answer. thank you,

• Re: warehouse- sales problem -statistics.

I think you could do this with formulas however your explanation of what you want is really really difficult to understand. Perhaps you could upload a sample workbook with some non-sensitive data as well as the desired output that you need. I have read your question a few times and I think you may need to explain exactly what you require very specifically - a sample workbook with sample output/report format would be invaluable.

Regards
[SIZE=3]Anthony
[/SIZE]&WCF_AMPERSAND[SIZE=3]
[/SIZE]&WCF_AMPERSAND&WCF_AMPERSAND&WCF_AMPERSAND[SIZE=2]You have your way. I have my way. As for the right way, the correct way, and the only way, it does not exist.[/SIZE]

• Re: warehouse- sales problem -statistics.

Thank you, so much for your attention. With all respect, I would like to modify the code I am working, but I am stumped, days and days, and.... so I am sending what I need; and the workbook I rather by private message. (it's to long here).
[TABLE="class: MsoNormalTable, width: 439"]

[tr]

[TD="width: 66, bgcolor: transparent"]numbers
[/TD]
[TD="width: 63, bgcolor: transparent, colspan: 2"]ranking
[/TD]
[TD="width: 91, bgcolor: transparent"]
[/TD]
[TD="width: 90, bgcolor: transparent"]
[/TD]
[TD="width: 75, bgcolor: transparent"]
[/TD]
[TD="width: 44, bgcolor: transparent"]
[/TD]
[TD="width: 55, bgcolor: transparent"]
[/TD]
[TD="width: 47, bgcolor: transparent"]
[/TD]
[TD="width: 55, bgcolor: transparent"]
[/TD]

[/tr]

[tr]

[TD="width: 66, bgcolor: transparent"]

58

[/TD]
[TD="width: 48, bgcolor: transparent"]

92

[/TD]
[TD="width: 16, bgcolor: transparent"]
[/TD]
[TD="width: 402, bgcolor: transparent, colspan: 6"]rank high from 67 to 100/ middle 34 to 66 and low 1 to 33
[/TD]
[TD="width: 55, bgcolor: transparent"]
[/TD]

[/tr]

[tr]

[TD="width: 66, bgcolor: transparent"]

41

[/TD]
[TD="width: 48, bgcolor: transparent"]

30

[/TD]
[TD="width: 16, bgcolor: transparent"]
[/TD]
[TD="width: 91, bgcolor: transparent"]
[/TD]
[TD="width: 90, bgcolor: transparent"]
[/TD]
[TD="width: 75, bgcolor: transparent"]
[/TD]
[TD="width: 44, bgcolor: transparent"]
[/TD]
[TD="width: 55, bgcolor: transparent"]
[/TD]
[TD="width: 47, bgcolor: transparent"]
[/TD]
[TD="width: 55, bgcolor: transparent"]
[/TD]

[/tr]

[tr]

[TD="width: 66, bgcolor: transparent"]

49

[/TD]
[TD="width: 48, bgcolor: transparent"]

71

[/TD]
[TD="width: 16, bgcolor: transparent"]
[/TD]
[TD="width: 402, bgcolor: transparent, colspan: 6"]the code must generate the combinations of 6 numbers
[/TD]
[TD="width: 55, bgcolor: transparent"]
[/TD]

[/tr]

[tr]

[TD="width: 66, bgcolor: transparent"]

24

[/TD]
[TD="width: 48, bgcolor: transparent"]

65

[/TD]
[TD="width: 16, bgcolor: transparent"]
[/TD]
[TD="width: 354, bgcolor: transparent, colspan: 5"]with 2 high, 2middle, 2 low, and 3evens, 3 odds.
[/TD]
[TD="width: 47, bgcolor: transparent"]
[/TD]
[TD="width: 55, bgcolor: transparent"]
[/TD]

[/tr]

[tr]

[TD="width: 66, bgcolor: transparent"]

20

[/TD]
[TD="width: 48, bgcolor: transparent"]

50

[/TD]
[TD="width: 16, bgcolor: transparent"]
[/TD]
[TD="width: 91, bgcolor: transparent"]sum range
[/TD]
[TD="width: 164, bgcolor: transparent, colspan: 2"]from 141 to 247
[/TD]
[TD="width: 44, bgcolor: transparent"]
[/TD]
[TD="width: 55, bgcolor: transparent"]
[/TD]
[TD="width: 47, bgcolor: transparent"]
[/TD]
[TD="width: 55, bgcolor: transparent"]
[/TD]

[/tr]

[tr]

[TD="width: 66, bgcolor: transparent"]

21

[/TD]
[TD="width: 48, bgcolor: transparent"]

67

[/TD]
[TD="width: 16, bgcolor: transparent"]
[/TD]
[TD="width: 299, bgcolor: transparent, colspan: 4"]this range is part of the inputs also.
[/TD]
[TD="width: 55, bgcolor: transparent"]
[/TD]
[TD="width: 47, bgcolor: transparent"]
[/TD]
[TD="width: 55, bgcolor: transparent"]
[/TD]

[/tr]

[tr]

[TD="width: 66, bgcolor: transparent"]

16

[/TD]
[TD="width: 48, bgcolor: transparent"]

98

[/TD]
[TD="width: 16, bgcolor: transparent"]
[/TD]
[TD="width: 91, bgcolor: transparent"]
[/TD]
[TD="width: 90, bgcolor: transparent"]
[/TD]
[TD="width: 75, bgcolor: transparent"]
[/TD]
[TD="width: 44, bgcolor: transparent"]
[/TD]
[TD="width: 55, bgcolor: transparent"]
[/TD]
[TD="width: 47, bgcolor: transparent"]
[/TD]
[TD="width: 55, bgcolor: transparent"]
[/TD]

[/tr]

[tr]

[TD="width: 66, bgcolor: transparent"]

17

[/TD]
[TD="width: 48, bgcolor: transparent"]

70

[/TD]
[TD="width: 16, bgcolor: transparent"]
[/TD]
[TD="width: 457, bgcolor: transparent, colspan: 7"] there are two high rank two middle rank and two low rank totals
[/TD]

[/tr]

[tr]

[TD="width: 66, bgcolor: transparent"]

19

[/TD]
[TD="width: 48, bgcolor: transparent"]

20

[/TD]
[TD="width: 16, bgcolor: transparent"]
[/TD]
[TD="width: 91, bgcolor: transparent"]

12

[/TD]
[TD="width: 90, bgcolor: transparent"]

16

[/TD]
[TD="width: 75, bgcolor: transparent"]

20

[/TD]
[TD="width: 44, bgcolor: transparent"]

17

[/TD]
[TD="width: 55, bgcolor: transparent"]

25

[/TD]
[TD="width: 47, bgcolor: transparent"]

51

[/TD]
[TD="width: 55, bgcolor: transparent"]

141

[/TD]

[/tr]

[tr]

[TD="width: 66, bgcolor: transparent"]

12

[/TD]
[TD="width: 48, bgcolor: transparent"]

100

[/TD]
[TD="width: 16, bgcolor: transparent"]
[/TD]
[TD="width: 91, bgcolor: transparent"]

12

[/TD]
[TD="width: 90, bgcolor: transparent"]

46

[/TD]
[TD="width: 75, bgcolor: transparent"]

52

[/TD]
[TD="width: 44, bgcolor: transparent"]

49

[/TD]
[TD="width: 55, bgcolor: transparent"]

51

[/TD]
[TD="width: 47, bgcolor: transparent"]

25

[/TD]
[TD="width: 55, bgcolor: transparent"]

235

[/TD]

[/tr]

[tr]

[TD="width: 66, bgcolor: transparent"]

23

[/TD]
[TD="width: 48, bgcolor: transparent"]

67

[/TD]
[TD="width: 16, bgcolor: transparent"]
[/TD]
[TD="width: 91, bgcolor: transparent"]

46

[/TD]
[TD="width: 90, bgcolor: transparent"]

58

[/TD]
[TD="width: 75, bgcolor: transparent"]

52

[/TD]
[TD="width: 44, bgcolor: transparent"]

21

[/TD]
[TD="width: 55, bgcolor: transparent"]

51

[/TD]
[TD="width: 47, bgcolor: transparent"]

19

[/TD]
[TD="width: 55, bgcolor: transparent"]

247

[/TD]

[/tr]

[tr]

[TD="width: 66, bgcolor: transparent"]

32

[/TD]
[TD="width: 48, bgcolor: transparent"]

80

[/TD]
[TD="width: 16, bgcolor: transparent"]
[/TD]
[TD="width: 91, bgcolor: transparent"]

32

[/TD]
[TD="width: 90, bgcolor: transparent"]

58

[/TD]
[TD="width: 75, bgcolor: transparent"]

24

[/TD]
[TD="width: 44, bgcolor: transparent"]

23

[/TD]
[TD="width: 55, bgcolor: transparent"]

41

[/TD]
[TD="width: 47, bgcolor: transparent"]

51

[/TD]
[TD="width: 55, bgcolor: transparent"]

229

[/TD]

[/tr]

[tr]

[TD="width: 66, bgcolor: transparent"]

25

[/TD]
[TD="width: 48, bgcolor: transparent"]

1

[/TD]
[TD="width: 16, bgcolor: transparent"]
[/TD]
[TD="width: 91, bgcolor: transparent"]
[/TD]
[TD="width: 90, bgcolor: transparent"]
[/TD]
[TD="width: 75, bgcolor: transparent"]
[/TD]
[TD="width: 44, bgcolor: transparent"]
[/TD]
[TD="width: 55, bgcolor: transparent"]
[/TD]
[TD="width: 47, bgcolor: transparent"]
[/TD]
[TD="width: 55, bgcolor: transparent"]
[/TD]

[/tr]

[tr]

[TD="width: 66, bgcolor: transparent"]

52

[/TD]
[TD="width: 48, bgcolor: transparent"]

60

[/TD]
[TD="width: 16, bgcolor: transparent"]
[/TD]
[TD="width: 402, bgcolor: transparent, colspan: 6"] there are 3 evens and three odds
[/TD]
[TD="width: 55, bgcolor: transparent"]
[/TD]

[/tr]

[tr]

[TD="width: 66, bgcolor: transparent"]

51

[/TD]
[TD="width: 48, bgcolor: transparent"]

10

[/TD]
[TD="width: 16, bgcolor: transparent"]
[/TD]
[TD="width: 91, bgcolor: transparent"]
[/TD]
[TD="width: 90, bgcolor: transparent"]
[/TD]
[TD="width: 75, bgcolor: transparent"]
[/TD]
[TD="width: 44, bgcolor: transparent"]
[/TD]
[TD="width: 55, bgcolor: transparent"]
[/TD]
[TD="width: 47, bgcolor: transparent"]
[/TD]
[TD="width: 55, bgcolor: transparent"]
[/TD]

[/tr]

[tr]

[TD="width: 66, bgcolor: transparent"]

46

[/TD]
[TD="width: 48, bgcolor: transparent"]

90

[/TD]
[TD="width: 16, bgcolor: transparent"]
[/TD]
[TD="width: 255, bgcolor: transparent, colspan: 3"]the numbers and ranking I have to input manually.
[/TD]
[TD="width: 99, bgcolor: transparent, colspan: 2"]
[/TD]
[TD="width: 47, bgcolor: transparent"]
[/TD]
[TD="width: 55, bgcolor: transparent"]
[/TD]

[/tr]

[/TABLE]
sorry for any mistake. and thank you again for your time. You are the first person who respond.

• Re: warehouse- sales problem -statistics.

You can get the Binomial co-efficients by using the following - place the number set in Column A

## Files

Regards
[SIZE=3]Anthony
[/SIZE]&WCF_AMPERSAND[SIZE=3]
[/SIZE]&WCF_AMPERSAND&WCF_AMPERSAND&WCF_AMPERSAND[SIZE=2]You have your way. I have my way. As for the right way, the correct way, and the only way, it does not exist.[/SIZE]

• Re: warehouse- sales problem -statistics.

how can I attach a file like this. I tried and I couldn't. where is the instruction for that.

• Re: warehouse- sales problem -statistics.

Scroll down the page.

Regards,

Wigi

Excel MVP 2011-2014

For more Excel memes: visit http://www.wimgielis.com ==> English articles ==> Excel memes

-- Topics without [CODE] tags or a meaningful topic title, will be neglected by me (and probably many others as well) --

## Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!