Count multiples rows and ans in a single row and column

[AFZAL SOHAIL]

Dear Team,

I am a sharing a data in which the count of product are in multiple rows , but I want to ans in a single row and column is as under:-

Sr.No.	Product	Count	Results	Expected results
1	Apples	2	Apples	2	Apples	2
6	Apples	2	Banana	3
5	Banana	3	Banana	3	Grapes	2
9	Banana	3	Mangoes	2
11	Banana	3
3	Grapes	2	Grapes	2
4	Grapes	2
2	Mangoes	2	Mangoes	2
10	Mangoes	2

 

[AFZAL SOHAIL]

Dear Team,
Please Help

 

[AFZAL SOHAIL]

I requested to Moderator please help me/guide me..
Thanks in advance pl.

 

[AFZAL SOHAIL]

What is the reason in my thread so no any expert ans my query?

 

[Peter_SSs]

What is the reason in my thread so no any expert ans my query?

Probably because you have two sets of data and expected results and they seem quite different to each other. So people probably don't know what the format of your data is or what results you actually want.

 

[Sergius]

Hello! Do you need to calculate the number of products? Or display the unique names of the products? Because nothing is clear from your post.

 

[AFZAL SOHAIL]

I need to count unique names of the product and against their count:
e.g. Apple = 2
Banas = 3

with a single formula

 

[ExcelNewbie2020]

try
=LET(ab,UNIQUE(B2:B10),HSTACK(ab,COUNTIF(B2:B10,ab)))

 

[AFZAL SOHAIL]

try
=LET(ab,UNIQUE(B2:B10),HSTACK(ab,COUNTIF(B2:B10,ab)))

Thanks a lot sir,
It is working very well.
May God Bless You.

 

[Peter_SSs]

Thanks a lot sir,
It is working very well.

In that case perhaps you need to update your forum profile? Your profile shows that you have Excel versions 2021 and 2016, but neither of those versions has the HSTACK function.