Search results for query: *

Thanks to all for reading this. I have been struggling for a long while to work out an equation to return the highest or lowest text value by alphabetical order. The reason behind this is i have to present the high and low for each colomn in a spreadsheet of some size and having to manually...

Hello all i have a bit of a poser here, i have a set of values spread over 3 colomns and a unique reference number in a forth. i need to identify where there are duplications of the values and mark accordingly. i am using the equation =if(countif(b:d,b2)>1,"x","") what i would like to be...

How can i ask this with seming a little dense, i am however bashing my head against the desk in frustration. i have a table of data containing multiple unique customer id numbers and multiple non unique business codes, i also have a URN applied to each record in the database. What i need to do...

I have been asked to compile a chart to cross reference all fields within my database of 3 related tables with each other and show a count of how many fields can be matched on the basis that they are not of a null value. for example Col_1 Col_2 Col_3 Col_4 abc ABC 1 1...

Can anyone offer any ideas on the following poser. I am using Act Premium 2008. Is it possible to add a Unique Reference Number to each contact record? I am not needing to setup any system of auto allocation after i have completed this first instance as the number of new contacts is at present...