Hi guys, i'm working on a search function on my worksheet. so basically, i have a database and on the main page, i would like to type in a name and a style then have excel to find the most recent 10 entries within my database by providing me "item name, style, date, counts". Can anyone show me how? thanks in advance!
my current method is: enter name and style then {index(time/date/counts, match(name,name*style,style)}, but i can only get 1 line out and couldn't get the rest (ideally, 10 lines)
Bookmarks