concatenate if meets certain criteria

[darkbluecat]

Hi, so I've got this:

=CONCATENATE("Data available from ",TEXT(MIN(Raw!U:U),"mmm yy")," to ",TEXT(MAX(Raw!U:U),"mmm yy"))

which returns the max date and min date from all the lines of data in another sheet, output is: Data available from Dec 18 to Nov 20

I've checked and this works,

Now in another column on that sheet, I have different names, and want to run this but only if it has that name too.

I've got a list of these names on the sheet i'm currently working on, and want to copy it for each of the six names, so that it only concatenates if it contains that name.

I've tried all sorts and can't share the file to show you because work.

 

[Fluff]

What column are the names in on the Raw sheet?

 

[darkbluecat]

B:B and the list on the sheet I'm working on starts with B6

 

[Fluff]

Ok, how about

=CONCATENATE("Data available from ",TEXT(MINIFS(Raw!U:U,Raw!B:B,B6),"mmm yy")," to ",TEXT(MAXIFS(Raw!U:U,Raw!B:B,B6),"mmm yy"))

 

[darkbluecat]

Yes!! It works, thank you so much!!

Can you explain how it works?
There's a lot of excel functions I don't understand and I'm trying to learn stuff and I won't know what functions to use when I know what I want to do in my head lol

I've started attending coding sessions at my uni lol to understand stuff, I like how logical it all is I just wish I could understand AND remember it all

 

[darkbluecat]

I didn't know minifs and maxifs were a thing!! No wonder I couldn't do it

 

[Fluff]

Glad to help & thanks for the feedback.