Advanced Excel COUNTIF/V/HLOOKUP FUNCTION

SalientAnimal

New Member
Joined
Dec 24, 2010
Messages
43
Hi All,
So I have a fairly basic calcualtion that I need to do, however structuring the correct formula to use is what seems to be the problem. I have a worksheet where I need to Calculate leave available vs. leave taken.
Part of this would include building a trend pattern to see on which day of the week leave is most often taken. The purpose of this is to see if, as an example, a person is misusing sick leave on a friday to get an "Extend Weekend"
The problem I have is because of the way the document is layout. I have attached the document.
What I need to happen (Example):
1. SHEET (Leave_Matrix) Brian Windsor has taken SLV every friday in January.
2. SHEET (Leave_Trends_Balances) The table (Leave Trends C18:J25) needs to count/calculate 4 SLV on Friday and 1 ALV on Thursday for Brian Windsor.
3. SHEET (Leave_Trends_Balances) Should this trend continue into February as an example the Friday leave count should keep counting over other months. ie. by the end of February, Brian Windsor might have 6 Fridays as SLV.
I hope my explination makes sense of what I am trying to achieve?
Thanks....

Attached available here: http://www.excelbanter.com/showthread.php?p=1602412#post1602412
 

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.

Forum statistics

Threads
1,212,044
Messages
6,105,577
Members
447,972
Latest member
carrieann

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top