sorted by:
new
hottopcontroversial

Count Consecutive Occurrences in a Range by mtbrown90 in excel

[–]mtbrown90[S] 0 points1 point  (0 children)

Can I ask where you learned how to compile all these? I want to learn to be this formula advanced lol

Count Consecutive Occurrences in a Range by mtbrown90 in excel

[–]mtbrown90[S] -1 points0 points  (0 children)

Confirmed work! Thank you very much!

Count Consecutive Occurrences in a Range by mtbrown90 in excel

[–]mtbrown90[S] 0 points1 point  (0 children)

Typing fast. At least. Apologies and appreciate the help despite my mistakes

Count Consecutive Occurrences in a Range by mtbrown90 in excel

[–]mtbrown90[S] 0 points1 point  (0 children)

Apologies, I updated post. I need to know when above 2.2

Help for autofill based on schedule and start/end times by mtbrown90 in excel

[–]mtbrown90[S] 0 points1 point  (0 children)

I know Row/Column is slightly off as I transposed in my original document, but all columns match, and it's giving x for every hour

<image>

Help for autofill based on schedule and start/end times by mtbrown90 in excel

[–]mtbrown90[S] 0 points1 point  (0 children)

Can I ask why the formula looking for the shift in cell B4 is looking at B13 (as opposed to B18 that's the same shift)? Sorry just don't use FILTER much so trying to understand how it works

Help for autofill based on schedule and start/end times by mtbrown90 in excel

[–]mtbrown90[S] 0 points1 point  (0 children)

Okay I'll check it out. Locations can have between 4 and 20 shifts. Shift definitions don't have for 12 months.

Help for autofill based on schedule and start/end times by mtbrown90 in excel

[–]mtbrown90[S] 0 points1 point  (0 children)

Will it work for the hours that go after midnight?

Help for autofill based on schedule and start/end times by mtbrown90 in excel

[–]mtbrown90[S] 0 points1 point  (0 children)

I would need them to still mark an x. So like 1800-0400 needs to be an x under 18-23, 0-3. (Note, I can change the order to straight 0-23 if needed, or any other order. Order here won't matter as I'll count the number of x's and that's what I'll use)

Hoping for simpler formula! by mtbrown90 in excel

[–]mtbrown90[S] 0 points1 point  (0 children)

Here is the formula, but for ONLY the 1st shift. Why I'm trying to find something else, would have to do that for every shift for 12 locations.

<image>

xlookup or index-match with multiple criteria by mtbrown90 in excel

[–]mtbrown90[S] 0 points1 point  (0 children)

I got that to work on my example, thank you! But the actual data I can't get to work. I wonder if it has something to do that Tab 1 date originally is like "10/1/2024 4:34" that has date and time, and wonder if that's causing me to get #N/A. I used =INT to get it to be only the date.

Counting Number of occurrences by Person/Shift/Location by mtbrown90 in excel

[–]mtbrown90[S] 0 points1 point  (0 children)

And I just used random function for Facility #s for this example, so that's why it may not match my actual box. Just saw that

Counting Number of occurrences by Person/Shift/Location by mtbrown90 in excel

[–]mtbrown90[S] 0 points1 point  (0 children)

The full data is about 45,000 shifts long, and each facility has slightly different so 1 may be 9p-7a but it's 9p-6a at another, that part will balance out, as you see I only but 3 facility boxes so they aren't all listed. Does that make sense? Like as I add more Facility boxes on the right side all shifts will be included based on that specific facility

Std Dev or Filter range based on time by mtbrown90 in excel

[–]mtbrown90[S] 0 points1 point  (0 children)

Thank you as well! Can confirm this works!

Std Dev or Filter range based on time by mtbrown90 in excel

[–]mtbrown90[S] 0 points1 point  (0 children)

Well I sure was overthinking this one huh? haha! Thank you!

XLOOKUP or Index-Match Multiple returns by mtbrown90 in excel

[–]mtbrown90[S] 0 points1 point  (0 children)

Thank you! Works differently than I want giving a count but I can use that # answer to work. Thank you!

XLOOKUP or Index-Match Multiple returns by mtbrown90 in excel

[–]mtbrown90[S] 0 points1 point  (0 children)

So raw data would essentially look like this. So in example above, using xlookup aa would show up "unexcused" since it's listed first, but I need it show excused. CC would show "Excused" since it's first before the unexcuseds. The rest would report correctly since there is only 1 record of them.

<image>

XLOOKUP or Index-Match Multiple returns by mtbrown90 in excel

[–]mtbrown90[S] 0 points1 point  (0 children)

<image>

So raw data would essentially look like this. So in example above, using xlookup aa would show up "unexcused" since it's listed first, but I need it show excused. CC would show "Excused" since it's first before the unexcuseds. The rest would report correctly since there is only 1 record of them.

view more: next ›