Hi Guys,
I have a workbook which has multiple sheets and a summary sheet. Lets say I have 11 sheets on the workbook with the first being my summary and the other 10 being pages with my data.
On each of my data sheets there are columns which then have rows filtered based on critea for each column. The column I'm focusing on is the "rejection reason". Basically what I want it to do is copy the reason that appears (if there is one) from the filtered data, back into my summary sheet.
I could get it to work with the following as it calculates the modal value, the only problem is there needs to be a minimum of 3 rejection reasons for it to work, with at least one re-occuring twice.
I am really in a bind and have been for a week or so now over this, any help would be really greatly appreciated.
If you need more information or a better explanation don't hesitate to shout!
Regards,
A very stuck Farmertml!
I have a workbook which has multiple sheets and a summary sheet. Lets say I have 11 sheets on the workbook with the first being my summary and the other 10 being pages with my data.
On each of my data sheets there are columns which then have rows filtered based on critea for each column. The column I'm focusing on is the "rejection reason". Basically what I want it to do is copy the reason that appears (if there is one) from the filtered data, back into my summary sheet.
I could get it to work with the following as it calculates the modal value, the only problem is there needs to be a minimum of 3 rejection reasons for it to work, with at least one re-occuring twice.
I am really in a bind and have been for a week or so now over this, any help would be really greatly appreciated.
If you need more information or a better explanation don't hesitate to shout!
Regards,
A very stuck Farmertml!
