Hi Jose Welcome to the forum. In sheet Global cell B2 enter =SUMIF(INDIRECT(B$1&"!A:A"),$A2&"*",INDIRECT(B$1&"!B:B")) Copy down a...
Hi Amy There are still a lot of questions that need to be asked. Is 12_Tab an accumulated file? (i.e. every week new data will be appended to th...
You can try File - Recent and at the bottom right of the screen there is a Recover Unsaved Workbooks option. Good luck. Sunny
Hi Mark My solution is in VBA. If you don't want to use the Worksheet Change event, you can insert a button on the worksheet and attach my macro...
Hi Mark I don't think you can display the result of a formula in a Comment. You will need VBA for that. What you request is complex and difficul...
Hi Andy You can try this. It is a bit more complex as I don't know how many unique staff are there in a year. I have catered for 40. You can amend ...
Hi Frans I will try to explain whatever I can on this one. I will use the F9 key to select and evaluate the formulas part by part. =LOOKUP(2,1/(...
Hi Amy I am not clear about what you wanted. Can you give an example of what you are doing and what is the expected result? Sunny
Hi Lynn You can try this =IF(A1="M",Index B3,F10 etc, Index F3:I10 etc) Replace the text in blue for Male and red for Female for what you wan...
Hi Suhail Try this. In cell P2 enter =LOOKUP(2,1/(C2:N2<>0),$C$1:$N$1) Copy down as desired. Hope this helps. Sunny
Hi Amy These are ARRAY formulas. In cell F12 enter =INDEX($X$3:$X$99,MATCH(B12&D12,$V$3:$V$99&$W$3:$W$99,0)) Finish by pressing CTRL+...
Here is a PivotTable equivalent. You only need to duplicate the output sheets and change the filter. Just refresh the PivotTable if there are any a...
Hi Matthew As an alternative to the PivotTable (or a VBA solution), you can also try this. It uses array formulas. Without knowing how many rows...
My attachment contains the formula. Just filter the color.
Hi Amy Happy to know it is working for you. Cheers. Sunny