Ok, I'll explain this as best I can. I've been able to work out part of my solution but not all of it.
I've got a column of data that is regularly updated, which looks something like:
REMOTES
H00001AA.SNT*
H00001AB.SNT*
H00001AC.SNT*
H00001AE.SNT*
H00001AF.SNT*
H00006AB.SNT
H00011AA.SNT
H00018AA.SNT
H00024AA.FOX
H00026AA.SNT
H00026AB.SNT
H00028AA.SNT
Now, what I need to do is generate a listing or report that will go through this column and find how many unique occurences there are. BUT, here's the catch, I only need to match the first 6 characters of each cell.
Is there a way to do this? I can report the unique occurences both through a formula and through a pivot table, but I can't seem to figure out the filter part for the first 6 characters...
Anyone have any ideas? Thanks in advance!
I've got a column of data that is regularly updated, which looks something like:
REMOTES
H00001AA.SNT*
H00001AB.SNT*
H00001AC.SNT*
H00001AE.SNT*
H00001AF.SNT*
H00006AB.SNT
H00011AA.SNT
H00018AA.SNT
H00024AA.FOX
H00026AA.SNT
H00026AB.SNT
H00028AA.SNT
Now, what I need to do is generate a listing or report that will go through this column and find how many unique occurences there are. BUT, here's the catch, I only need to match the first 6 characters of each cell.
Is there a way to do this? I can report the unique occurences both through a formula and through a pivot table, but I can't seem to figure out the filter part for the first 6 characters...
Anyone have any ideas? Thanks in advance!