Good Afternoon, I am trying to find a way to do conditional functions based on multiple criteria and I can't seem to find a way to do this.
*What I have:* Multiple columns of information: ID, Day of week, Week of, and Start Date/time, End day/time *What I would like:* I'd like to subtract the start date/times from each other IF the 'ID' and 'Week of' match each other. *A bit more detail:* The file contains a list of various IDs and the Start date which is associated with each ID. Some IDs are active a few times per week whereas others are active only once per week. I'm trying to find out the time between the same active ID if it are active multiple times during that same week. The same type of question can be used for other analysis that I need to do -- do X if Y and Z are the same. The only thing is that it needs to be able to look through the excel sheet to see if there are multiple Y and Z's. Does my request make sense? Thank you so much! -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
test.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
