index match function

Hi, This is the first time I've posted here so apologies if any of this is incorrect. I have a list of products ordered by week with their volume. I would like to select the top ten products by week. I have found and used the formula which gets the top ten, but I am struggling to do it by...

Dear Experts, Please have a look on below chart, this is showing date wise in and out. <colgroup><col><col><col><col><col><col span="10"></colgroup><tbody> S.No. Employee Name Father/Name Designation 01 01 02 02 03 03 04 04 05 05 In Out In Out In Out In Out In Out 1 187430 Andress Mashi...

Dear Experts, Please look into the attach file frmula index match could not perform very well and where is duplicate of marks formula does not pick up name of student and make some error repeat two time..... https://1drv.ms/x/s!Ar_1OKzm7QW1fm4AUrX7VPiLmlA Please help to resolve this formula...

Hi guys! I have a excel sheet like this https://imgur.com/a/NlFCgbO and I want to pull some specific data by day. Like for example if I select 1 it will look like this https://imgur.com/a/BIEyiyP. Thanks!

<style type="text/css"> p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'Lucida Grande'} span.s1 {color: #006107} span.s2 {color: #0057d6} span.s3 {color: #ab30d6} </style>I am working on a project and have been spending hours looking into the excel INDEX MATCH formulas and online tutorials...

Hi there, I have two tables from different sources and they should so the same information. I have an unique ID column in each table and I am currently trying to use a index match function to check different coulms for matches using the ID as a reference. What I have so far is...