Hi,
I'm have a simple spreadsheet, with a list of application names. Tha applicaiton names have multiple versions and I need to count how many applications as opposed to how many verisons.
A quick example...
Office 2010
Office 2007
Office 2003
Application1 version1.4
Application 1 version 5
Applicaiton 1 version three
Application2 v4
Applicaiton2 v6
Applicaiton2 version5
so whilst there is 9 rows there are 3 applications and I'm trying to count the no of applicaitons. I can't split the text as the way the application and version is presetned isn't always the same.
Any ideas how to group similar rows rather than exact?
oh and I'm not exactly a wizz on excel so I will get lost with complex scripts.
Bookmarks