Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. LtCmdrData

    hi lo from a text range

    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...
  2. LtCmdrData

    Selecting unique value from inside a dynamic range

    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
  3. LtCmdrData

    Selecting unique value from inside a dynamic range

    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
  4. LtCmdrData

    Selecting unique value from inside a dynamic range

    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...
  5. LtCmdrData

    Duplicate flagging variation

    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...
  6. LtCmdrData

    Duplicate flagging variation

    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...
  7. LtCmdrData

    Relatioanal Count

    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...
  8. LtCmdrData

    Relatioanal Count

    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...
  9. LtCmdrData

    Relatioanal Count

    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...
  10. LtCmdrData

    Unique Reference Number Allocation

    many thanks for your help everything is up and running again
  11. LtCmdrData

    Unique Reference Number Allocation

    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...

Part and Inventory Search

Back
Top