Attached is your test file

Hope this will help

]]>

Attached is your test file

Hope this will help

]]>Attached is your test file ... see formula located in cell D8

Hope this will help

]]>

Attached is your test file ... see formula located in cell D8

Hope this will help

]]>This is exactly what I was looking for. That data sheet enitirely has about 560+ alternate combinations.

You have made it easy for me to search the required data.

Thank you.

]]>

Try,

In H4, enter formula :

=AGGREGATE(15,6,H9:H30/(D9:D30=D4)/(E9:E30=E4)/(F9:F30=F4)/(G9:G30=G4)/(H9:H30>=C4),1)

Regards

This is exactly what I was looking for. That data sheet enitirely has about 560+ alternate combinations.

You have made it easy for me to search the required data.

Thank you.

I need some help with a formula that will calculate sick time earned starting on the employee's anniversary date (cell J11). The employee will accrue 4 hours every 30 days, but will not earn more than 48 hours in 12 consecutive months. I'm afraid…]]>

I need some help with a formula that will calculate sick time earned starting on the employee's anniversary date (cell J11). The employee will accrue 4 hours every 30 days, but will not earn more than 48 hours in 12 consecutive months. I'm afraid this is beyond my ability so any help is much appreciated. I've attached the workbook.

]]>Thanks a lot for your feedback AND for YOUR Thanks ]]>

That worked ! THANK YOU SO MUCH . I'm new to this so thank you for your patience!

Thanks a lot for your feedback AND for YOUR Thanks

]]>(Code, 7 lines)

]]>

If that is the case ... can you attach your Excel file ...

(i.e. cells i7, i13, i24, i 25 ... which are related to your colored ranges ..).

What is the logic…]]>

Hi sir,

In other forum it was single employee example but it is not work for me, this is absolutely new thread new example files.

Please consider and help me make the solution to me.

Thanks and regards,

Dackson.

If that is the case ... can you attach your Excel file ... **WITH** the formula which calculates what you are calling the ' leave days ' ...

(i.e. cells i7, i13, i24, i 25 ... which are related to your colored ranges ..).

What is the logic to select ... or not to select the days ???

]]>Let's say Sheet2, Sheet3, and Sheet4 in cell A1 would show whatever image was…]]>

Then on other sheets within the document it would autopopulate that image.

Let's say Sheet2, Sheet3, and Sheet4 in cell A1 would show whatever image was pasted/inserted into cell A15 on the Welcome page.

Otherwise the user will need to paste the picture multiple times.

It's not a huge hassle, just something that I feel could make this more user friendly

]]>To apply a Date or Time format, execute the following steps.

- Select the required cell.
- Right-click, and then click Format Cells.
- In the Category list, select Date, and select a date format.
- Click OK.
- Dates are stored as

To apply a Date or Time format, execute the following steps.

- Select the required cell.
- Right-click, and then click Format Cells.
- In the Category list, select Date, and select a date format.
- Click OK.
- Dates are stored as numbers in Excel and count the number of days. Times are handled internally as numbers between 0 and 1.
- You can enter times as 6:00, but Excel displays this time as 6:00:00 AM in the formula bar. AM is used for times in the night and morning. PM is used for times in the afternoon and evening.
- Change the number format of the cell to Date only.
- Finally, if you cannot find the right date or time format, create a custom date or time format.

Hope this helps.

Regards,

Jerry M.

]]>Thanks for your message and the formula. I am not getting his to work as Excel complains it's not a formula. But it doesn't matter. I'll just copy what I need manually for now.

Thanks though.

Regards,

Mike]]>

Thanks for your message and the formula. I am not getting his to work as Excel complains it's not a formula. But it doesn't matter. I'll just copy what I need manually for now.

Thanks though.

Regards,

Mike

]]>=COUNTIF(A1:INDEX($A$1:$C$10,$H1,3),E1)

if you wanted.]]>

=COUNTIF(A1:INDEX($A$1:$C$10,$H1,3),E1)

if you wanted.

]]>Sir, thank you so much for the help.]]>

Sir, thank you so much for the help.

]]>This one has me stumped, and I'm not easily stumped.

I have a simple column of…]]>

Hello,

This one has me stumped, and I'm not easily stumped.

I have a simple column of dates; some dates are duplicated, some are not.

What I want is to be able to highlight only the duplicated dates, in alternating fashion.

You might think that Conditional Formatting already provides this - just go to Highlight Duplicates.

But that will not achieve the objective since I don't want all the duplicated dates highlighted in one color.

I want one color to highlight the first group of duplicated dates, a second color to highlight the next group of duplicated dates, then back to the 1st color for the next group, etc. An easy illustration is attached.

Thank you !

]]>will return the row number.]]>

=MATCH(MIN(A1:A10),A1:A10,0)

will return the row number.

]]>Ahh okay that makes sense now, I have a solution thank you! I already have a lookup built in to check whether theres 31 or 30 days in the month so will incorporate this now to ensure it calcs the right days. I misinterpreted your…]]>

As I said, June and November have the same number of days, so that should work fine; only months with different numbers of days have issues.

Will the dates always be the end of a month?

Ahh okay that makes sense now, I have a solution thank you! I already have a lookup built in to check whether theres 31 or 30 days in the month so will incorporate this now to ensure it calcs the right days. I misinterpreted your initial comment.

Thanks,

Mel

]]>Assume data in A2:A?

In C2, enter formula and copied down 3 lines :

=LARGE(OFFSET(A$1,MATCH(9^9,A:A)-1,0,-15),ROW(A1))]]>

Assume data in A2:A?

In C2, enter formula and copied down 3 lines :

=LARGE(OFFSET(A$1,MATCH(9^9,A:A)-1,0,-15),ROW(A1))

]]>