Generate a list based on meeting a criteria

Hi all, this is my first post here. Hoping you all can help !

I'm currently running a large data pull and am trying to come up with a convenient way to generate a list of all the items in the table that meet a certain criteria. What would be the best way to do this? / What would be the appropriate code to do this.

If a cell is greater than 80, than report the class, day and % total

TABLE/INPUT

DAY#
Class 1 2 3 4 5
A 76 33 91 107 52
B 23 5 104 72 33
C 52 88 86 95 97

OUTPUT:

Class Day %total
C 2 88
A 3 91
B 3 104
C 3 86
A 4 107
C 4 95
C 5 97

Book1.xlsx

Hi, welcome to the forum

You could probably do this with INDEX/MATCH, but I would need to see a sample workbook, cant work with pics. upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.

Hi, welcome to the forum

You could probably do this with INDEX/MATCH, but I would need to see a sample workbook, cant work with pics. upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.

Try this:-
Based on your File Data
Results start "M1".

Please Login or Register  to view this content.

Regards Mick