GoogleSheets: Result based on unique and countif formula

[YLP]

Hi,,
please suggest suitable formula in google sheets ,, for result,,
1) column b contains numbers
2) column c is unique values from column b
3) column d is no of occurrences for unique values
4) column e,f,g,h,i,j in sheet 3 of development sheet provided should give result for corresponding yymm data of column A..

 

[vletm]

YLP
You're asking something suitable formula in google sheets ... with given Excel-file.
Should You try to ask from some Google-sheet?
... This is the Excel-forum.

 

[Juniad]

Try this formula in Cell E2 and drag over and down.
=IFERROR(INDEX($A$2:$A$12155,SMALL(IF($C2=$B$2:$B$12155,ROW($B$2:$B$12155)-ROW($B$1)),COLUMNS($E$2:E2))),"")