Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Split alphanumerical string when encounter alphabetic character -Excel
Hello Friends, I need help with splitting an alphanumerical string. I am using Excel to manage this data but if you have any better suggestion, please let me know. I have a string starting with numerical part which has at the end some soft of alphabetical character followed by 1-9 numerical...- imme
- Thread
- Replies: 5
- Forum: Microsoft: Office
-
Count Patent Expiration date in excel
Hi, I am trying to determine Expiration date for patent in excel spreadsheet. WHAT I HAVE? File Date : Date when company filed application for patent, i. e. Publication Date : Date when patent office issue files application as patent i. e. RULE: patent expire after 20 years from file date...- imme
- Thread
- Replies: 6
- Forum: VBA Visual Basic for Applications (Microsoft)
-
How to count unique value in Excel Pivot Table
Hi, I am stuck here in counting unique values in many-many relationship. Here is situation. I have three columns in my excel sheet, first for patent numbers, second for Product code for each patent and third is group no. for each product code. Data have one patent number to many product code...- imme
- Thread
- Replies: 4
- Forum: Microsoft: Office
