Major help Required

[khalid79m]

I need a forumla to look at sheet 1 coloum J and see how many unique record there are. ie.
Coloum J
John
John
Andy
Mark
Mark
Mark
Irvine
Irvine

the answer would be John Andy Mark Irvine. Please could someone help me the formula I have had some trouble with it.

Also once its found unique records I need it to do a counit if for each of them in that coloumn

the answet being
b2 b3
John 2
Andy 1
Mark 3
Irvine 2

plus all this info needs to be paste in B2 sheet 2

Help please spent 4 days on this cant make heads or tails of it.

[VBA Noob]

Hi,

Does the attached help.

Use advance filter explained on the attached link

http://www.contextures.com/xladvfilter01.html#FilterUR

Then uses the countif function

VBA Noob

[khalid79m]

Thanks VBA NOOB your the best.. also how can i put a sumproduct formula for each of the names. I cant see where to add it into the code you gave me

Please Login or Register  to view this content.

[VBA Noob]

If it' to replace the countif formula then change this line

Range("IV2").FormulaR1C1 = "=COUNTIF(C[-246],RC[-1])"

Try recording the action. On the stop recording toolbar select the relative relationship button next to the stop button.

VBA Noob

[khalid79m]

its not what i was looking for but after breaking down your formula achieved all my goals for this project. Your a superstar VBA, goodluck and all the best


Ps can u help with a new project ?

I am trying to write a scipt that once a user from my list say (my list is John Ian Micheal Tony)

Say tony puts a the Letter Y into column A SHEET1 a timer starts , if they close the file it stops and when Tony opens it up again the timer continues until they put a Y into column z sheet1

then i need to write user name "TONY" "FILENAME" and TIMETAKEN onto my stats gathering sheets.

[VBA Noob]

Hi,

Thanks for the feedback.

The new problem would be beyond my simple VBA skills so I would repost detailing what you want.

These links might help

http://msdn2.microsoft.com/en-us/lib...ffice.10).aspx

http://www.ozgrid.com/News/worksheet-scroll-limit.htm

VBA Noob