I am working on too many files and where I need a to estimate frequecy or counts each events with start and end date of each events in separate coulumns. A sample file which is mannualy estimated is attached herewith.
I am working on too many files and where I need a to estimate frequecy or counts each events with start and end date of each events in separate coulumns. A sample file which is mannualy estimated is attached herewith.
Welcome to the forum.
10 is not an Office version - which do you have? If your version is relatively new, then you can use SUMIFS and MINIFS for these calculations.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Thank you for your consideration and time, i am using MS office excel 2010. i cannot catchup your idea. In the attached file i need 'Output' part and seeking following solutions:
(1) running count of each events (PET in file) either it occurs in single date or continuous increasing date until it breaks. After break of date another count will start and so on,
(2) Finding sum and minimum values for each count (event wise)
(3) finding start date and end date if there is break in event. If there is one date of one event then only such date is mention in start or end column
H3 cell formula
O3 cell formulaHTML Code:
J3 cel array formulaHTML Code:
HTML Code:
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks