How to pick up 1 number with a lot of same numbers in row/ column?
With a lot of same numbers in row/column, I want to pick up the number one
time in new row/column. Any suggestion? Thank. |
How to pick up 1 number with a lot of same numbers in row/ column?
One quick way - create a pivot table
Assume your source data is running in A1 down Insert a new top row, enter a col header, eg: xxx Select col A, click Data Pivot table Click Next Next In step 3, click Layout Drag n drop xxx into ROW area Drag n drop xxx into DATA area If it appears as "Sum of xxx", just double click on it, then change it to Count under Summarize by Click OK Finish Hop over to the pivot in the new sheet (to the left) where you'd see the unique list of numbers in the leftmost col (that's the list that you want), and the corresponding counts of each number adjacent to it. -- Max Singapore http://savefile.com/projects/236895 Downloads:17,000 Files:358 Subscribers:55 xdemechanik --- "Jon" wrote: With a lot of same numbers in row/column, I want to pick up the number one time in new row/column. Any suggestion? Thank. |
All times are GMT +1. The time now is 02:57 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com