week1

Lads, Hope you can help me. I have Table in Sheet1 consisting of 100's of rows and about 20 columns similar to below. I need formula in Sheet2 that looks through Column A Sheet1 and if it finds APPLE IN CELL then it needs to copy whole row into Sheet2 and same for PEAR. This need to be in the...

I am building a rota and so have 52 work sheets titled week1, week2, etc... each sheet is identical in layout, similar to below. Assume that cells here run from A1:O5 What I want to do is have all the dates update across the 52 sheets when I enter the 'start' date in week1 Currently I am just...

Here is the formula which I am using. Problem: Its not printing the correct row of data. =INDEX($A$1:$H$15,MATCH($A$18,$A$1:$A$15,0),MATCH(B$18,$B$2:$H$2,0),MATCH($A19,$A$3:$A$15,0)) Here is the same formula, which explains the above formula, and what I'm looking to achieve...

Hi Guys, I am just wondering anyone could help me to build a bar chart graph. The vertical axis is amount and horizontal axis is customers. <tbody> Customer Week1 Week1 Week2 Week2 Act Fcst Act Fcst A 10 5 20 10 B 42 10 20 15 C 30 43 24 18 D 49 34 20 19 </tbody> Is it possible...

I have a multi-sheet workbook which has some sheets called Week1 Week2 etc. I also have a sheet with a range of dates in column AB4 to AB35 In the worksheet Week1 etc, I have dates stored in row B5 to H5. I have a named range called "SheetList" which contains the names of the worksheets Week1...

Hi All, I have two sheets and one called Week1. This formula works for me from the other sheet: =INDEX(Week1!$G$3:$G$50,MATCH($C6,Week1!$B$3:$B$50,0)) However, I would like to replace Week1 in the formula with a text string I type say in cell A1. This is where I get stuck. Can someone shed...

I have three columns where the first column have names, second column has week (eg, Week 1, Week 2) and the third column has shifts (eg, S1, S2). I want to count the number of instances of third column of a specific person of first column in a particular week. For EG: Col 1 Col 2 Col...

Hi, This is my current slicer filters, is there any setting that can sort the weeks below correctly? from Week1 to Week13 accordingly. <tbody> Week1 Week10 Week11 Week12 Week13 Week4 Week6 Week7 Week8 Week9 </tbody>

I'm trying to get an average of what Tyde did divided by the hours he worked (B2:F2) = 48 (B3:F3) = 40 <tbody> A B C D E F 1 Jan-1 Jan-2 Jan-3 Jan-4 Jan-5 2 Tyde 11 12 11 8 6 3 Hours 8 8 8 8 8 </tbody> The formula i want to use is (ill explain way) =sum(B2:F2)/(B3:F3) this...

I have one sheet with a list of fruit then next 6 colums are marked week1 to 6 Fruit Week1 Week2... Apple 23 45 oranges 10 pears 5 6 7 on a second sheet I want to lookup the fruit and bring back the last row with data in it if I lookup apples it will return...