So say I have a block of information from A4:G26. I have these cells filled with style #'s (L500, K500, 711031, 23m, K500...etc.) I want to pick out the top 10 most frequent styles and list them in cells K4:K14.
So say I have a block of information from A4:G26. I have these cells filled with style #'s (L500, K500, 711031, 23m, K500...etc.) I want to pick out the top 10 most frequent styles and list them in cells K4:K14.
To attach a Workbook
(please do not post pictures or links to worksheets)
- Click Advanced (next to quick post),
- Scroll down until you see "Manage Attachments",
- Click that then select "add files" (top right corner).
- Click "Select Files" find your file, click "open" click "upload"
- Once the upload is completed the file name will appear below the input boxes in this window.
- Click "Done" at bottom right to close the Attachment Manager.
- Click "Submit Reply"
Ben Van Johnson
I hope I attached the file correctly. I'm looking to make a list ofthe top 10 most common style numbers. Thank You.
Make a list of the unique styles, add a formula, and sort:
Row\Col J K L 3Style Count 423m 64K4: =COUNTIF($A$4:$G$26, J4) 5K500 29 6K501 1 7K502 1 8K503 1 9K504 1 10K505 1 11K506 1 12K532 36 13K533 1 14K534 1 15K535 1 16K536 1 17K537 1 18L500 15 19L501 1 20L502 1 21L503 1 22L504 1 23L505 1 24L506 1
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks