Posted to microsoft.public.excel.programming

Sinner

external usenet poster

Posts: 142

List & count unique records

Hi,

I have the following list.

08459087671
08459087673
08465228672
08429087671
08429087571
08454287667
08454287657
-----------------------------------
Would like to calculate the following i.e. the formula or VB code
should first list items based on first 7 characters uniqueness & then
the quanity count.

Result:
-----------------------------------
Items Qty
0845908 2
0846522 1
0842908 2
0845428 2

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Count Unique Records	Erinayn	Excel Worksheet Functions	1	February 4th 09 03:57 PM
count unique records	kr	Excel Worksheet Functions	14	January 25th 09 04:04 AM
Count Unique Records	CTAY	New Users to Excel	3	July 24th 08 05:35 AM
pivot count unique records only	Deborah	Excel Discussion (Misc queries)	0	July 8th 08 01:52 PM
Count Unique Records	Jon Dow[_2_]	Excel Worksheet Functions	4	February 26th 07 05:28 AM

All times are GMT +1. The time now is 06:26 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us