Solved: Amend and Move

[Hoopsah]

I have used them (briefly), hadn't thought about them for this project though.

[Bob Phillips]

With just one database table now, pivotting it might provide most of the stats that you need.

[Hoopsah]

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

[Hoopsah]

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

[Bob Phillips]

Gerry,

That is the old formula, it changed significantly in #34. Are you using the new on?

[Hoopsah]

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.

[Hoopsah]

Going on holiday for 1 week

Take Care

[Hoopsah]

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

[Hoopsah]

Final bump!

I know I keep on Bob, but if you could possibly have a wee look at this one again

[Bob Phillips]

Sorry Gerry, I lost track of this one. I will refamiliarise today and see what I can do.

[Hoopsah]

Thanks Bob

[Hoopsah]

** 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

[Hoopsah]

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