Excel sheet attached to try and show what i am trying to achieve.
The first 7 fields are exported straight out of access as a select query. the 8th field is a formula that i have to input into excel, and is a check for a unique reference and if unique give me a "1", if duplicated gives me a "0". =IF(G3=G2,"",1)
How can i replicate this formula is my query so i do not have to carry out any additional calculations in excel ?
The first 7 fields are exported straight out of access as a select query. the 8th field is a formula that i have to input into excel, and is a check for a unique reference and if unique give me a "1", if duplicated gives me a "0". =IF(G3=G2,"",1)
How can i replicate this formula is my query so i do not have to carry out any additional calculations in excel ?