Name multiple instances of a value.
I could just look this up, but I'll be lazy.
I want to name multiple instances of a value.
Ref.No - Date - Instance
123 01/01/2009 1st
123 06/01/2009 2nd
122 07/02/2009 1st
Column "Instance" to look at "Ref.No" and "Date", giving the result of "1st instance", etc. (Using dates order)
I've tried arrays of Match and count, but I'm stuck.
well the answer is........
nope too lazy to type sorry
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and a dabbler in Cisco
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Thanks, I'll try another site.
With the OP's attitude I have closed this thread
Please Read Forum Rules Before Posting
Wrap VBA code by selecting the code and clicking the # icon or Read This
How To Cross Post politely
Top Excel links for beginners to Experts
If you are pleased with a member's answer then use the Scales icon to rate it
If my reply has assistedor failed to assist you
I welcome your Feedback.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Bookmarks