Hi all,
I have a workbook with three Worksheets
breakdown
May08WFA
Apr08WFA
On "breakdown" I want to acheive a formula in cell O7 to count the number of occurances where a value in range(A1:A2000) on "May08WFA" is different to value in range(A1:A2000) on "Apr08WFA"
What this will show is a number reflecting a count of new entries (account names), between dataset Apr08WFA and May08WFA.
Also if range O8 also could count number of occurnaces where there is a MATCH on account name. This will allow me to see not only the number of new account names but also the number of account names, consistance between the two datasets.
I have experimented with a host of MATCH formula and nothing appears to work
If anyone could provide a formula for both O7 and O8 that would relieve alot of my problems and assist my knowledge of how to acheive this in future.
thanks
darren
I have a workbook with three Worksheets
breakdown
May08WFA
Apr08WFA
On "breakdown" I want to acheive a formula in cell O7 to count the number of occurances where a value in range(A1:A2000) on "May08WFA" is different to value in range(A1:A2000) on "Apr08WFA"
What this will show is a number reflecting a count of new entries (account names), between dataset Apr08WFA and May08WFA.
Also if range O8 also could count number of occurnaces where there is a MATCH on account name. This will allow me to see not only the number of new account names but also the number of account names, consistance between the two datasets.
I have experimented with a host of MATCH formula and nothing appears to work
If anyone could provide a formula for both O7 and O8 that would relieve alot of my problems and assist my knowledge of how to acheive this in future.
thanks
darren
Last edited: