Array or range lookup per row?
=IF(--SUMPRODUCT(--(ISNUMBER(MATCH(Sheet1!$B$3:$B$15,B6,0))))0,SUMPR ODUCT(--(ISNUMBER(MATCH(Mon!$E$7:$E$51,Sheet1!$A$3:$A$15,0 ))),--(ISNUMBER(MATCH(Mon!$K$7:$K$51,Sheet1!D$3:D$15,0)) ),--(ISNUMBER(MATCH(Mon!$F$7:$F$51,Sheet1!$E$3:$E$15,1 ))),--(ISNUMBER(MATCH(Mon!$F$7:$F$51,Sheet1!$F$3:$F$15,-1)))),"None")
Currently i have this formula to look up through many ranges of cells and to count up how many times it matches. unfortunatly i need it to do what it does only per Row. Not just through all the ranges at once but too look up the info in one sheet per row and search for it in the other per row and if i matches per row to count it. Current layout is this (Sheet1) each item in each row is going to be diffrent (#### means4 random #'s Name Date ####'s Time in Time out Name Date ####'s Time in Time out Name Date ####'s Time in Time out Name Date ####'s Time in Time out (Mon) colums depicted by ** are irrelevant information but cannot be deleted ** ** ** ** Date Time ** ** ** ** ** ####'s **-till end of info ** ** ** ** Date Time ** ** ** ** ** ####'s **-till end of info ** ** ** ** Date Time ** ** ** ** ** ####'s **-till end of info ** ** ** ** Date Time ** ** ** ** ** ####'s **-till end of info (Report) Name Long formula above Name Long formula above Name Long formula above Name Long formula above i need the formula to look at the name in report then find the name however many times it occurs in sheet1 then look at the info that is in the same row as the name and then find the items in a row with the items in Mon then count it up how many times it occurs for that name. Hop this helps -- RG |
All times are GMT +1. The time now is 10:47 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com