How to display similar rows just once?

O

ofirab

Board Regular
Joined
Mar 11, 2003
Messages
62
Hello All,

under "Name" colum, from all "bezeqinternational" entries, i want to display just one, i.e i want to know how many differnet enteries under "name" column i have,

untitled.gif


Thank you

Ofira :biggrin:
 

Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result
Sort by date Sort by votes
Will using DATA->--Filter---> ADVANCED FILTER
to display Unique records suffice ?

(y)
 
Upvote 0
... and for a count of unique names (distinct names)...

=SUMPRODUCT((NameRange<>)/COUNTIF(NameRange,NameRange&""))

Or apply COUNTA on the result of Advanced Filter.
 
Upvote 0
You must log in or register to reply here.

Similar threads

T
  • Solved
Sort by Date
2
Replies
14
Views
548
johnnyL
J
R
  • Solved
Using VBA to achieve looping a user input form and consolidate the output into another worksheet
Replies
1
Views
477
Artik
Artik
B
  • Question
Getting a pivot table value from VBA Code
Replies
0
Views
152
BenW71
B
B
  • Question
How can I combine two tables?
Replies
5
Views
230
barcelonat
B
J
  • Question
Complex Move data from two spreadsheets with similar data in different columns to a specific column in an existing spreadsheet(Sheet 3)
Replies
0
Views
100
JMC57
J

Forum statistics

Threads
1,214,620
Messages
6,120,554
Members
448,970
Latest member
kennimack

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top