Help in Reporting

[Haree]

Hiii, I am uploading a sample data, I would have thousands of rows like this . I would need help in reporting like which weight is fast moving , basically a ranking system types. How am i supposed to achieve this ?. I tried pivot i don't think so it was helpful in this particular scenario.

Trial.xlsm
	A	B	C	D
10	17-05-2020	Sales	1	60
11	23-03-2020	Sales	1	55
12	24-05-2020	Sales	1	74.3
13	26-05-2020	Sales	1	75.5
14	26-05-2020	Sales	1	45.2
15	27-05-2020	Sales	1	63.1
16	28-05-2020	Sales	1	86.2
17	31-05-2020	Sales	1	103.7
Salem Kolusu

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B17	Cell Value	contains "Purchase"	text	NO
B17	Cell Value	contains "Sales"	text	NO

Cells with Data Validation
Cell	Allow	Criteria
B10:B17	List	Purchase,Sales

Thanks in Advance

 

[etaf]

I would need help in reporting like which weight is fast moving , basically a ranking system types

Can you define a little more
in your example you show the MAX of sales
RANK how many ?
I would need a lot more definition and examples

 

[Haree]

Hello etaf, Thank you for taking out time to help me out. I am attaching a sample of the report i would like

Stock Silver Trial.xlsm
	A	B	C	D	E	F	G	H	I	J
1	Date	Particulars	No of Pieces	Weight			Sl.NO	Weight From	Weight To	No Of Pieces
2	13-05-2020	Sales	1	45.7			1	40	50.9	1
3	16-05-2020	Sales	1	91.1			2	51	60.9	2
4	16-05-2020	Sales	1	84.2			3	61	70.9	2
5	16-05-2020	Sales	1	66.2			4	71	80.9	3
6	17-05-2020	Sales	1	62.3			5	81	90.9	1
7	17-05-2020	Sales	1	80.3			6	91	100.9	1
8	17-05-2020	Sales	1	60			7	101	110.9	0
9	23-03-2020	Sales	1	55			8	111	120.9	0
10	24-05-2020	Sales	1	74.3
11	26-05-2020	Sales	1	75.5
DATA TRIAL

Cells with Data Validation
Cell	Allow	Criteria
B2:B11	List	Purchase,Sales

G1:J9 is what i would be requiring.
Thanks a lot

 

[etaf]

I Modified the Weight to - to the same as the next BUT just used a LESS than - that way anything between the 0.9 and 1 would not be missed
I assume you never have a weight below 40

I have used
=COUNTIFS(D:D,">="&H2,D:D,"<"&I2)
to count the number of rows within that weight range

BUT may need to use SUMIFS - if you have more than 1 Piece in the No. of pieces column ALSO may need to modify to include the SALES column if that changes

BUT unless you example shows full info cannot guess
I'm not sure what the SI.NO column means

Book1
	A	B	C	D	E	F	G	H	I	J	K
1	Date	Particulars	No of Pieces	Weight			Sl.NO	Weight From	Weight To	No Of Pieces
2	43964	Sales	1	45.7			1	40	51	1
3	43967	Sales	1	91.1			2	51	61	2
4	43967	Sales	1	84.2			3	61	71	2
5	43967	Sales	1	66.2			4	71	81	3
6	43968	Sales	1	62.3			5	81	91	1
7	43968	Sales	1	80.3			6	91	101	1
8	43968	Sales	1	60			7	101	111	0
9	43913	Sales	1	55			8	111	121	0
10	43975	Sales	1	74.3
11	43977	Sales	1	75.5
12
Sheet1

Cell Formulas
Range	Formula
J2:J9	J2	=COUNTIFS(D:D,">="&H2,D:D,"<"&I2)

 

[Haree]

Hello @etaf
Thank you so much, it helped me a lot i just tweaked them a little bit more so that i could sort them with dates and added sales to the criteria as well. Thank you so much for your efforts.

 

[etaf]

you are welcome