Recent content by greengo204

Hi, Could someone please assist me with the below: I have two tables 1.) Table A - Which contains data that changes regularly 2.) Mapping Table - Which has a static table that will hold static data used in a lookup formula to allocate segments (groups) to table A My end goal is have a...

Skipvought: Yes you right, I think I need to improve expressing my requirements Lionelhill: 99.9% of the time I would use a unique key or request the DBAs to provide me with something unique. In this situation I have no option for this due to the nature of the source of the data (bank...

SkipVought Thanks for your advice on this. The text to column method does work but I was hoping to find a formula based method that would work. Suppose my question is, is it possible to complete a vlookup (or alternative) based on a string appearing in the target range?: e.g. tableA: NAME...

Hi, I have 2 tables both with a field 'COMPANY_NAME/CUSTOMER_NAME' but they appear in a different format on each table e.g. tableA COMPANY_NAME/CUSTOMER_NAME AMOUNT Mr John Smith 100 Doctor Andrew Brown 500 Microsoft...

Just wondering if any other people have been experiencing disappearing cells when using Excel 2007 to open Excel 2003 files? When scrolling through various different spreadsheets cell visability dissapears for some cells. Just to be clear its just the visibility that is hidden, when you click...

old post but found some useful VBA code thats solved my problems: http://www.contextures.com/xlPivot12.html

xlhelp: Thanks thats what i was looking for. Petermoran: Cheers i will look into that plugin as im sure i may have other uses for it. Regards,

I've tried all three 'IS' functions unsuccessfully, the 'ISREF' funtions conditional formatting always returned TRUE? I've found a macro which is doing the job, but cant help thinking theres an easier method... Macro...

fair point. i am trying to conditionally format a cell (fill colour) if the cell contains any formula. any suggestions?

Possible i have been attempting that method unsuccessfully. Additional info: I am trying to fill a cell conditionally with colour is the cell contains a formula. I have been using a custom function (VBA) to identify if the relevant cell has a formula and then coditionally format the cell if...

Not sure if this is possible but is there a way to copy any paste just the fill colour of a cell? I've tried "copy & paste special > formats" but that paste all the cells formatting. I am specifically looking for just the fill colour. If this can't be done with the usual features i would be...

Spot on. thanks

HI, For displaying Multiple Discrete values separated by a comma, i generally use the below formula: whileprintingrecords; stringvar Output:=""; numbervar Counter; For Counter := 1 to ubound({?MyNumericParameter}) do( Output:= Output& totext({?MyNumericParameter}[Counter],0,"")& "," )...

Was not entirely sure what you suggestion meant as i would be running this report for a large amount of customers so i was a bit unsure how to pass the MAX's to limit the data in the report. I have found a SQL solution though which is working in the Crosstab: ( SELECT...

if your parameters included in yor record selction criteria then the only invoices for the year will be returned. So if you add a Grand Total summary (Insert>Grand Total) on the {Invoice.TotalGst} then that should return what you are looking for.