Search results

Actually, I figured it out. Or rather, someone else on the Internet figured it out. I'm posting a link to the solution in case anyone else has the same problem. It involves changing the format of the dates...

Thanks, Luke! It works beautifully...when my dates are formatted correctly. I'm having difficulty with that, as it works when I format the dates manually but not using formulas. Should I start a new thread for that? Thank you.

Oh wait, that's where my list comes in, right? I can just put my list of unique names in one column, put the formula in the column beside, and make it a relative reference and copy down the list.

But how do I tell the formula to move on to the next name? I want to do this calculation for each name in the worksheet. There are hundreds. Thanks.

Hi Luke, That made sense, but I guess I'm confused by your reference to having a list of the names. How am I to use that?

I'm not very familiar with array formulas.

Hello! I’ve been puzzling over how to subtract dates within a group of records when the groups are unequal sizes. I have data that is grouped by person, identified by an ID number. That is, each person has multiple records, or lines in the table, and their ID number is the same in each one...