Dear all,
I have a excel table with duplicate bill id, i want to get the unique
count. However, it should also consider another criteria, which is
customer. Should I use advanced filter instead? How should the advanced
filter be set?
--
Darwin Chan
darwin.chankaw...@gmail.com
Hi Darwin
if your bill ids are in ascending order then
check the attachment see if it helps formula cells in red color
On Wed, Dec 14, 2011 at 9:10 PM, Darwin Chan darwin.chankaw...@gmail.comwrote:
Dear all,
I have a excel table with duplicate bill id, i want to get the unique
count.
Dear Darwin,
Please find attached sheet...hope it will help to u...
On Wed, Dec 14, 2011 at 9:10 PM, Darwin Chan darwin.chankaw...@gmail.comwrote:
Dear all,
I have a excel table with duplicate bill id, i want to get the unique
count. However, it should also consider another criteria,
PFA
On Wed, Dec 14, 2011 at 10:32 PM, NOORAIN ANSARI
noorain.ans...@gmail.comwrote:
Dear Darwin,
Please find attached sheet...hope it will help to u...
On Wed, Dec 14, 2011 at 9:10 PM, Darwin Chan darwin.chankaw...@gmail.com
wrote:
Dear all,
I have a excel table with duplicate
hi
use this Function to Count only Unique value in a List
{=SUM(IF(COUNTIF(A1:A24,A1:A24)=1,1,0))}
On 12/14/11, NOORAIN ANSARI noorain.ans...@gmail.com wrote:
PFA
On Wed, Dec 14, 2011 at 10:32 PM, NOORAIN ANSARI
noorain.ans...@gmail.comwrote:
Dear Darwin,
Please find attached