I have used them (briefly), hadn't thought about them for this project though.
I have used them (briefly), hadn't thought about them for this project though.
I am playing all the right notes, but not necessarily in the right order.
Eric Morecambe
With just one database table now, pivotting it might provide most of the stats that you need.
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
Yes, I think your right.
I had a quick play there just looking at the pivots available and your right, it would do the job without me cluttering it up with formulas.
I will try and get it finished of today and tomorrow and let you know
I am playing all the right notes, but not necessarily in the right order.
Eric Morecambe
Hi Bob
Ran in to another wee problem.
You supplied the formula:
[VBA]=IF(ROWS(U$1:U2)<=SUM(--(COUNTIF(Database!$B$1:$B$500,Database!$B$1:$B$500)=1)),
SMALL(IF(COUNTIF(Database!$B$1:$B$500,Database!$B$1:$B$500)=1, Database!$B$1:$B$500),ROWS(U$1:U2)-1),"")[/VBA]
But, it has now dawned on me that some of the references will have letters as well as numbers (Typically in the format of XX999999)
Do you know how to amend the formula to accept letters too?
Again accept my apolgies for not making this clear first time round - it's like the gift that keeps giving!!
Cheers Bob
Gerry
I am playing all the right notes, but not necessarily in the right order.
Eric Morecambe
Gerry,
That is the old formula, it changed significantly in #34. Are you using the new on?
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
Hi Bob
(Sorry for the delay in getting back to you - Easter illness!!)
Yes, I have checked and this is the same formula from #34 - held in the Workings tab under the Reference header.
I am playing all the right notes, but not necessarily in the right order.
Eric Morecambe
Going on holiday for 1 week
Take Care
I am playing all the right notes, but not necessarily in the right order.
Eric Morecambe
Hi
Back from hols ;(
Still stuck with this one Bob. I have doublechecked that I am using the same formula that you provided in #34 and I am.
Whenever I enter a reference with a non-numeric (Letter) character then it saves it in the list as #NUM!
I can think of a way around this but it would be very longwinded, could you have another wee look at it for me please,
Cheers Bob
Gerry
I am playing all the right notes, but not necessarily in the right order.
Eric Morecambe
Final bump!
I know I keep on Bob, but if you could possibly have a wee look at this one again
I am playing all the right notes, but not necessarily in the right order.
Eric Morecambe
Sorry Gerry, I lost track of this one. I will refamiliarise today and see what I can do.
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
Thanks Bob
I am playing all the right notes, but not necessarily in the right order.
Eric Morecambe
** BUMP **
Sorry Bob, I don't want to harass you but I am no further with this one.
Still can't get it to accept letters but only numbers and it has now transpired that a lot of our applications will begin with 2 letters.
Can I ask you to have a wee look again - If you need anything further then please let me know,
Cheers Bob
Gerry
I am playing all the right notes, but not necessarily in the right order.
Eric Morecambe
Hi Bob
Still trying to get this to work!!
I am now encounternig another problem.
When I am on the Search tab, I cannot amend the details in column A as I keep getting a message: The Text string you entered is too long
I can't even see what is in there to make it any shorter - can you help?
Cheers Bob
Gerry
I am playing all the right notes, but not necessarily in the right order.
Eric Morecambe