Replies

That will do nicely. Thanks.

Alan

Ah, it’s a “feature”

Thanks for the information. Useful to know.

regards

Alan

Thanks, that worked. So did pressing then for each affected line. I think there’s a slight bug when the name definition is pasted in.

regards

Alan

Alan,

[*]Insert a new sheet.
[*]Click on A1 in the new sheet.
[*]Press F3
[*]Click on the Paste List button.
[*]Print the Sheet.

:cheers:
30074-PasteList

That works well but shows me the forumula rather than the result in Column B. If I copy the formula and paste it in column C, I get the result. So, what is different about column B? There must be a setting somewhere that says “show me the formula” but I have no idea what it is. The picture below illustrates it (I hope).

30095-t1

Yes, that works.

Alan

If I open in safe mode, it still does it.

Alan

Many thanks. I’ll give that a try.

[edit] – yes, that does exactly what I want.

Alan

If you have an MSDN subscription, you can still download the full version.

Alan

PS – I have no ideas why they didn’t keep updating this – it’s still the easiest web designer around.

Yes, that works. Thanks. Not the most elegant solution, but better than nothing.

Cheers

Alan

It doesn’t matter. I just need to find out how many unique identifiers I have.

Alan

Thanks John – that was it.

Cheers

Alan

Ah, so easy when someone else shows you. I never even thought about it just not being displayed.

Many thanks

Alan

Thanks Patrick – Number 2 is exactly what I need.

regards

Alan

So where in this SQL query would it go?

SELECT [All Known Services from the MSL].Service
FROM [All Known Services from the MSL] LEFT JOIN [Service List from the BUS] ON [All Known Services from the MSL].Service = [Service List from the BUS].[Vodafone Services]
WHERE ((([Service List from the BUS].[Vodafone Services]) Is Null));

thanks

Alan