| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Finding most common occurence of values in cells containing letters and numbers
i have to do a shortage analysis of various part numbers at work. i do this on a weekly basis , putting each weeks new data in a new worksheet. i need to be able to find the most common occuring part no. across these worksheets. the problem i have that these part numbers have various different formats some are just plain numbers eg 1234 some have a stroke and a number after them to denote a left and right pair of the same part eg 1234/1. the last type has the stroke for left and right, and an additional stroke and a letter to denote revision changes to parts eg 1234/1/A the part numbers are anywhere from 2 digits up to 7 digits. is there a way to find which part occurs most so that i can then inform the right people that they need to concentrate on the particular part. the part numbers are always in the same column on each worksheet. -- sparklyballs ------------------------------------------------------------------------ sparklyballs's Profile: http://www.excelforum.com/member.php...o&userid=37701 View this thread: http://www.excelforum.com/showthread...hreadid=572962 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sorting Cells With Alpha Numeric Values | Charts and Charting in Excel | |||
| Sorting - cells containing numbers, numbers and letters | Excel Discussion (Misc queries) | |||
| How do I sort letters before numbers in Excel? | Excel Discussion (Misc queries) | |||
| Finding Numbers with Cells that also contain letters | Excel Discussion (Misc queries) | |||
| How can I merge 2 cells with numbers and letters? | Excel Worksheet Functions | |||
Threaded Mode
