Recent content by tonyvee1973

Thanks skip, works like a charm. now I just need to work out how I get into the query that the excel sheet runs from :) appreciate the help

sorry skip, don't think I can explain what I need properly. If the values in A, B, C and D match the row directly above then I need to colour BOTH rows GREEN If the values in A, B and C match the row directly above but D is different then I need to colour both lines in RED does this make any...

hi skip if I leave a blank row 1 as a header row, I insert this formula into row 3 at the end of the data. It shows me TRUE or FALSE if its true then I know the conditions I need match =IF(A3=A2,B3=B2,D3=D2)

Hi All Hopefully a quick one for someone but driving me nuts! I have an excel table that I need to compare a row against the row above it. If the row matches exactly I need to colour BOTH rows GREEN If the values in A, B and C match but NOT D then I need to colour both lines in RED. I have...

Hi Guys and apologies for the delayed response and appreciate the input. Last night I managed to resolve the issue by using different tables in CR. It seems that the where the tables were linked by order number they were producing duplicate values if the records held multiple invoices per order...

Ok thanks guys, appreciate the assistance. Will take another look at the report to see if I can find a workaround as maybe its better I get the tables linked better to avoid bringing in duplicates anyway and therefore kill the need for suppression :)

Thanks Skip, appreciate the info but cant get it to work. I place this in a formula and place in the group header but it just divides the qty of the detail line it seems - doesn't sum anything.

sorry Skip, what do I do with that?

Hi all Have a report which data has duplicates in that I need supressed. I have a formula (@qty) in the details section and in the section expert area to suppress I have the formula below. //This formula suppresses the Details line //when there are duplicate values contained in the fields...

Ah, so I wasn't a million miles away, need to read up on ABS :) Thanks Skip, works like a charm as always, much appreciated - have a great weekend!

Just a quick update on this formula (Which works perfectly btw) :) If I wanted to add a tolerance to the match (Instead of a perfect we will accept + or - 6pcs) how do I add this into the formula above? I have tried =IF(AND(A3=A4,B3=B4,D3=D4)<=6,"MATCH","") but that doesn't work - sure I am...

Ah ok, thanks all

Thank Skip, works like a treat so much appreciated. Huge apologies as didn't mean to appear disrespectful to you guys, just that I tried pasting in from an excel sheet and it pushed all the figures together - thought this may be a nightmare to read in the post. The image seemed much better but...

Hi All A little help needed if possible? I have a stocktake and data is being pushed into an excel sheet. Problem is that I need to be able to compare columns A, B and D between a row and the row underneath it - if they all match then put "Match" in an adjacent cell. Some sample data below, any...

Thanks again for this, however I tried that but no joy. When I put you're formula in the details section of the report, when I right click and choose "Insert" it only gives me the option of field heading and not summary.