Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Counting unique text/number cells from a range
Please consider a long range of text cells containing A, B, C, D....Z and more. Lets say it goes from H1 to H1500 A -H1 A B F D A H D |
#2
|
|||
|
|||
Yes. It's called a Pivottable. With the Pivottable you can select a Row item to be Column H and then select Column H to also be the Data item, and Count the No of Data item. So in short you will get a list that says: ColH...Count of ColH 1.......2 5......7 A......10 B.......3 C.......20 ... To learn how to use Pivottables whatch this video: http://www.datapigtechnologies.com/ExcelMain.htm Hope this helped Ola Sandström -- olasa ------------------------------------------------------------------------ olasa's Profile: http://www.excelforum.com/member.php...o&userid=17760 View this thread: http://www.excelforum.com/showthread...hreadid=379168 |
#3
|
|||
|
|||
I think Advanced Filter will do what you need.
Try this, http://contextures.com/xladvfilter01.html Debra Dalgleish is the expert on this, Regards, Alan. "sudeepd12" wrote in message ... Please consider a long range of text cells containing A, B, C, D....Z and more. Lets say it goes from H1 to H1500 A -H1 A B F D A H D |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Applying formula to only NON-EMPTY cells in range | Excel Discussion (Misc queries) | |||
range and cells syntax | Excel Worksheet Functions | |||
Counting unique entries in column A but only if specific values appear in columns B and C | Excel Worksheet Functions | |||
counting text cells | Excel Worksheet Functions | |||
How do I reference the same cell as I move through range of cells. | Excel Worksheet Functions |