excelnoob123123
New Member
- Joined
- Oct 4, 2021
- Messages
- 3
- Platform
- Windows
Hi, I have illustrated here what I am trying to do
I am trying to make a formula for "max days" and "recent consecutive days". Columns C and beyond are from a pivot table, whereas A and B cells are within that sheet. So eventually, columns J, K, L, and so on will be added and I need a function that will match this when the pivot table recalls information from new entries
Thank you so much for your time. Had a headache trying to figure this out on my own spending over 5 hours that I decided its best I ask for help before I go crazy
I am trying to make a formula for "max days" and "recent consecutive days". Columns C and beyond are from a pivot table, whereas A and B cells are within that sheet. So eventually, columns J, K, L, and so on will be added and I need a function that will match this when the pivot table recalls information from new entries
Thank you so much for your time. Had a headache trying to figure this out on my own spending over 5 hours that I decided its best I ask for help before I go crazy