Hello,
It has been some time since I have been on Excel Forum and I keep coming back because this Forum never fails me.
To my problem, I have sheet 1 and sheet 2 in my attachment. Sheet 1 i enter information manually at this time, but maybe later get some formulas for it.
I will continue at this time entering sheet 1 manually, but sheet 2 is where i need formulas in place that look at sheet 1 for information to put in sheet 2.
Column B is where the first formula will go and then starting in Column D is where the others will go. I explain this in more detail in the attachment.
I'm trying to count numbers from sheet 1 to put in column B by counting how many times it has been since that number showed up last, and then transfer that number to column D once it shows up again and have that number go back to 1 and start over.
This will be continuing pattern over time.
If you have any questions regarding what i'm trying to accomplish please dont hesitate to ask.
Thanks,
Brian
Bookmarks