UNIQUE FILTER / IF amendment needed

ollyhughes1982

Active Member
Joined
Nov 27, 2018
Messages
269
Office Version
  1. 365
Platform
  1. MacOS
Hi,

Please see below link to a file I’m having an issue with. I already have a solution in my ‘All Completed Runs - Alphabet’ worksheet to find the first instance of each run that begins with the relevant letter. This works for 95% of cases, but it does not for all. For example, my list is showing ‘Mallards Pike parkrun’ in 2019 as my first ‘M’ run, but it should actually be ‘parkrun de Mandavit’ in 2016. it's because in French parkruns they have the parkrun bit before the main name of the run, so this messes up my filter, as it picks it up as a 'P', rather than an 'M'.

Is there a way I can get around this? I do have a helper column (AU) in my main ‘All Completed Runs’ worksheet, which I have highlighted in yellow, which gives the first letter followed by an instance number. I wonder if I could use this to filter somehow, by having some sort of if or unique filter that first looks at the letter in AU and then if it is the first instance (i.e. if it is followed by 1). This would then give me the correct result. I just don’t know how to do it.

Link: Unique Filter issue.xlsx

Thanks in advance!
 

ollyhughes1982

Active Member
Joined
Nov 27, 2018
Messages
269
Office Version
  1. 365
Platform
  1. MacOS
Hi. I get a circular reference with that formula.
Screenshot 2020-04-20 at 14.20.32.jpg
 

Some videos you may like

Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes

ollyhughes1982

Active Member
Joined
Nov 27, 2018
Messages
269
Office Version
  1. 365
Platform
  1. MacOS
Hi. Yes, thanks both. I have removed the unique for column B now, thanks. I just need to get the date field working, if possible, please. I got a circular reference with the suggested formula
 

ollyhughes1982

Active Member
Joined
Nov 27, 2018
Messages
269
Office Version
  1. 365
Platform
  1. MacOS
Would it be ok to ask if you might be able to help with my other issue that I am having at the moment? Link to thread is below:


Thanks.
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
48,365
Office Version
  1. 365
Platform
  1. Windows
Glad we could help & thanks for the feedback
 

Watch MrExcel Video

Forum statistics

Threads
1,114,418
Messages
5,547,812
Members
410,813
Latest member
Vhinzvirgo
Top