Recent content by RogerBarton

Greetings Mufasa! Thanks for your reply ... I can now see how my request was somewhat vague! Thanks for correcting the error of my ways!!! I was actually after the last INSERT, UPDATE or DELETE - ie DML. So thankfully, you have given me an answer to this too. It was the answer that my...

Is there a way to find out the data / time a table was updated? Regards, Roger Barton

Greetings Brad! Thanks for sending the sample spreadsheet through. I have seen that your formulas work, and notice a very silly mistake on my behalf as to why your formulas weren't working for me (I had my two comparison values in cells A2 and A3 instead of A1 and A2 .... Oops!!! Funny, how...

Greeting Brad! Thanks for the additional information .... it just highlights how little I know about Excel!!! I have done the Control + Shift + Enter, and it has surrounded my formula with curly braces .... but it still produces an answer of 0 (zero).... which is not the desired result. I have...

Thanks Skip and Brad! Thanks too to the speed of reply! Skip - Your solution worked well for me, and produced the desired result! Brad - I cut & pasted your worksheet formula into my Excel spreadsheet and it did not produce the desired result - it produce an answer of 0. As to your question...

I have two cells which I want to compare and generate a result in a third cell which shows the common values. An example, probably best explains what I'm trying to achieve - A1: 1103056709 A2: 1120456089 The result I want to achieve is: A3: 1100056009 (ie. a digit by digit comparison, and if...

I'm only a new comer to CR, but had a similar problem. Exactly as you said, that the first page of my 10 x 2 label page was ok, but as you say, the top left label on the second and subsequent pages had the top part cut out. The right hand lable was fine! I noticed on my my report that on the...