Finding Specific Information

[joshtak]

Hello! I am trying to do an INDEX formula to find specific dates. Everything was working fine until I realized that I have 2 categories that have the similar name.

The 2 categories are "End User" and "End User Exception".

I just want to find the "End User" and not have the "End User Exception" be included.

Would anyone know if this is possible?

Thank you,

 

[James006]

Hi,

Could you at least post your current formula ... and describe your sheet's structure ...

 

[joshtak]

Sure, sorry about that.

My current formula is:

=INDEX('All Daily Queue Data'!B:B,(AGGREGATE(15,3,(('All Daily Queue Data'!$A:$A=$A$1)/('All Daily Queue Data'!$A:$A=$A$1)*ROW('All Daily Queue Data'!$A:$A))-ROW($A$1),ROWS($A$2:A2))))


The layout on the 'All Daily Queue Data' tab is:
Column A shows the name of the Queue. This would show "End User" and "End User Exception".
Column B shows the dates for each queue.

The reference is "End User".

Thank you!