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...
the return value should be the lowest possible value in column a .... column a is a set of unique so there will not be any dupes within it.. from the example the return would be abc01 to go in the final column
i am not sure i follow you on this. is this something that will then be able to be used as an output field to populate the cells with? no guesses as to who uses pivot tables never at all
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...
still rather confused what i am lookin at code wise, we had a clean out in the office and migrated from act to access and one guess who wasn't told, the only one who uses the stuff. CUST_ID is not an ordered sequence although unique they do contain unordered alpha prefixes that was the reason...
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...
never really had any experience in VBA but i am guessing it is not that bad to use for simple queries and i think there might be a copy of VBA for dummies or some such literature in the office cupboard...
thankyou very much for your help it is certainly going to make my job a lot easier than...
Having just reread what i posted the second tanle should show as
Col_1 Col_2 Col_3 Col_4
Col_1 x 3 3 2
Col_2 3 x 2 1
Col_3 3 2 x 2
Col_4 2 1 2 x
The number results are generated from:
Col_1...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.