Count unique with criteria
1
I need a bit of help,
I am in need of counting a few things but I need to ensure they are unique to avoid a duplication issue.
So here it is
Column 1 Column2 Column3
1030 12344 1030
So if column 1 and 3 match count column 3 if unique.
=COUNTIFS('Signature '!J$3:J$1048576,L2)
But I need to be able to check to ensure it's not counting a row twice if it's a duplicate.
Alternatively I can just remove the counted duplicates if. I can I check the count just the unique numbers in C2.
Thank you in advance
microsoft-excel worksheet-function microsoft-excel-2010
edited Feb 21 at 19:06
Alex M
511312
asked Feb 20 at 0:34
ndocdsndocds
226
add a comment |
1
I need a bit of help,
I am in need of counting a few things but I need to ensure they are unique to avoid a duplication issue.
So here it is
Column 1 Column2 Column3
1030 12344 1030
So if column 1 and 3 match count column 3 if unique.
=COUNTIFS('Signature '!J$3:J$1048576,L2)
But I need to be able to check to ensure it's not counting a row twice if it's a duplicate.
Alternatively I can just remove the counted duplicates if. I can I check the count just the unique numbers in C2.
Thank you in advance
microsoft-excel worksheet-function microsoft-excel-2010
edited Feb 21 at 19:06
Alex M
511312
asked Feb 20 at 0:34
ndocdsndocds
226
Possible duplicate of I wanted to count unique numbers in a excel and combine it with a countifs function
– Selkie
Feb 20 at 0:39
You could make a pivot table first, then pivot it on a copy of the pivot table to get the count.
– Jerry
Feb 20 at 9:49
add a comment |
1
1
1
I need a bit of help,
I am in need of counting a few things but I need to ensure they are unique to avoid a duplication issue.
So here it is
Column 1 Column2 Column3
1030 12344 1030
So if column 1 and 3 match count column 3 if unique.
=COUNTIFS('Signature '!J$3:J$1048576,L2)
But I need to be able to check to ensure it's not counting a row twice if it's a duplicate.
Alternatively I can just remove the counted duplicates if. I can I check the count just the unique numbers in C2.
Thank you in advance
microsoft-excel worksheet-function microsoft-excel-2010
edited Feb 21 at 19:06
Alex M
511312
asked Feb 20 at 0:34
ndocdsndocds
226
I need a bit of help,
I am in need of counting a few things but I need to ensure they are unique to avoid a duplication issue.
So here it is
Column 1 Column2 Column3
1030 12344 1030
So if column 1 and 3 match count column 3 if unique.
=COUNTIFS('Signature '!J$3:J$1048576,L2)
But I need to be able to check to ensure it's not counting a row twice if it's a duplicate.
Alternatively I can just remove the counted duplicates if. I can I check the count just the unique numbers in C2.
Thank you in advance
microsoft-excel worksheet-function microsoft-excel-2010
microsoft-excel worksheet-function microsoft-excel-2010
edited Feb 21 at 19:06
Alex M
511312
asked Feb 20 at 0:34
ndocdsndocds
226
edited Feb 21 at 19:06
Alex M
511312
asked Feb 20 at 0:34
ndocdsndocds
226
edited Feb 21 at 19:06
Alex M
511312
edited Feb 21 at 19:06
Alex M
511312
edited Feb 21 at 19:06
Alex M
511312
511312
asked Feb 20 at 0:34
ndocdsndocds
226
asked Feb 20 at 0:34
ndocdsndocds
226
asked Feb 20 at 0:34
ndocdsndocds
226
226
Possible duplicate of I wanted to count unique numbers in a excel and combine it with a countifs function
– Selkie
Feb 20 at 0:39
You could make a pivot table first, then pivot it on a copy of the pivot table to get the count.
– Jerry
Feb 20 at 9:49
add a comment |
Possible duplicate of I wanted to count unique numbers in a excel and combine it with a countifs function
– Selkie
Feb 20 at 0:39
You could make a pivot table first, then pivot it on a copy of the pivot table to get the count.
– Jerry
Feb 20 at 9:49
Possible duplicate of I wanted to count unique numbers in a excel and combine it with a countifs function
– Selkie
Feb 20 at 0:39
Possible duplicate of I wanted to count unique numbers in a excel and combine it with a countifs function
– Selkie
Feb 20 at 0:39
You could make a pivot table first, then pivot it on a copy of the pivot table to get the count.
– Jerry
Feb 20 at 9:49
You could make a pivot table first, then pivot it on a copy of the pivot table to get the count.
– Jerry
Feb 20 at 9:49
add a comment |
3 Answers
3
active
oldest
votes
1
=SUM(--(FREQUENCY(IF($J$2:$J$9999=L2,$D$2:$D$9999),$D$2:$D$9999)>0))
This is an array formula and must be entered with ctrl+shift+enter. In cell M2 press F2 then paste then ctrl+shift+enter. From there, you can ctrl+c M2 and copy down.
It's adapted from an explanation of using FREQUENCY to count unique with criteria that you can find at www dot exceljet dot net.
answered Feb 21 at 19:02
Alex MAlex M
511312
Alex, I literally just saw your post, Thank you for replying! I am going to give this a try. It most likely works better then mine 😃
– ndocds
Feb 21 at 19:05
add a comment |
0
=SUMPRODUCT(1/COUNTIF(data,data))
Where Data is the range where you have data.
Try tables out!
answered Feb 20 at 0:38
SelkieSelkie
222115
I’ll try this out as soon as I get home! Thank you. I typically use tables but I am giving this as a template and it has to be idiot proof. They are coping Dara from another report here and I’m worried if I use a table someone some where will some how will screw it up :)
– ndocds
Feb 20 at 1:39
No, that didn't work. I am able to use just COUNTIFS to compare and do a single cost the issue is column D may contain duplicates which means I'm counting column J twice. ideally I'd only want to count unique fields or remove duplicates automatically once the information is pasted into the excel.
– ndocds
Feb 20 at 2:31
Is it possible to train your end-users to paste things into a table, then run a bunch of power query off of that table?
– Selkie
Feb 20 at 16:14
It's possible however the end user may not be the only one to ever use it. We did a test run this morning and it came out pretty horrible. I ended up using a VBA macro to delete duplicates
– ndocds
Feb 20 at 18:16
add a comment |
0
I ended up using
=SUMIFS('Order Data'!AI:AI,'Order Data'!C:C,A:A)
Which worked out great
answered Feb 21 at 19:03
ndocdsndocds
226
Not clear how columns AI, C or A relate to the question as posted
– Alex M
Feb 21 at 19:06
No, but for the final output I place the value on a separate page to give it a clean look but for sake of ease and to prevent confusion while asking the question I pasted everything in a single sheet. I can easily link to other sheets for the data but I felt like posting 2 different screenshots of 2 different sheets would cause confusion. Driver data and the total remain on 1 sheet and isn't altered while the reference data is on another and is altered by the user. Does that make sense? but the answer whatever the formula is I can link back to those sheets without confusing those who helped me
– ndocds
Feb 21 at 19:09
1
I get where you're coming from but it's kind of a community norm (it seems; I'm fairly new here myself) to write answers that correspond to the data in the question - you'll note that the arrangement of data in my answer matched that of your question - perhaps this answer works for you but it's of little use to other users who may have the same/similar question, and it's difficult to evaluate its worth as an answer when the data doesn't match. Put simply, if this answer were submitted by someone not the asker, it would probably receive downvotes.
– Alex M
Feb 21 at 19:40
1
That makes a really good point Alex, one I selfishly hadn't considered. Thank you! moving forward instead of trying to simplify it I'll post in it's entirety to better help the community. Thanks for your feedback man!
– ndocds
Feb 21 at 20:01
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1407652%2fcount-unique-with-criteria%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
3 Answers
3
active
oldest
votes
3 Answers
3
active
oldest
votes
active
oldest
votes
active
oldest
votes
1
=SUM(--(FREQUENCY(IF($J$2:$J$9999=L2,$D$2:$D$9999),$D$2:$D$9999)>0))
This is an array formula and must be entered with ctrl+shift+enter. In cell M2 press F2 then paste then ctrl+shift+enter. From there, you can ctrl+c M2 and copy down.
It's adapted from an explanation of using FREQUENCY to count unique with criteria that you can find at www dot exceljet dot net.
answered Feb 21 at 19:02
Alex MAlex M
511312
Alex, I literally just saw your post, Thank you for replying! I am going to give this a try. It most likely works better then mine 😃
– ndocds
Feb 21 at 19:05
add a comment |
1
=SUM(--(FREQUENCY(IF($J$2:$J$9999=L2,$D$2:$D$9999),$D$2:$D$9999)>0))
This is an array formula and must be entered with ctrl+shift+enter. In cell M2 press F2 then paste then ctrl+shift+enter. From there, you can ctrl+c M2 and copy down.
It's adapted from an explanation of using FREQUENCY to count unique with criteria that you can find at www dot exceljet dot net.
answered Feb 21 at 19:02
Alex MAlex M
511312
Alex, I literally just saw your post, Thank you for replying! I am going to give this a try. It most likely works better then mine 😃
– ndocds
Feb 21 at 19:05
add a comment |
1
1
1
=SUM(--(FREQUENCY(IF($J$2:$J$9999=L2,$D$2:$D$9999),$D$2:$D$9999)>0))
This is an array formula and must be entered with ctrl+shift+enter. In cell M2 press F2 then paste then ctrl+shift+enter. From there, you can ctrl+c M2 and copy down.
It's adapted from an explanation of using FREQUENCY to count unique with criteria that you can find at www dot exceljet dot net.
answered Feb 21 at 19:02
Alex MAlex M
511312
=SUM(--(FREQUENCY(IF($J$2:$J$9999=L2,$D$2:$D$9999),$D$2:$D$9999)>0))
This is an array formula and must be entered with ctrl+shift+enter. In cell M2 press F2 then paste then ctrl+shift+enter. From there, you can ctrl+c M2 and copy down.
It's adapted from an explanation of using FREQUENCY to count unique with criteria that you can find at www dot exceljet dot net.
answered Feb 21 at 19:02
Alex MAlex M
511312
answered Feb 21 at 19:02
Alex MAlex M
511312
answered Feb 21 at 19:02
Alex MAlex M
511312
answered Feb 21 at 19:02
Alex MAlex M
511312
511312
Alex, I literally just saw your post, Thank you for replying! I am going to give this a try. It most likely works better then mine 😃
– ndocds
Feb 21 at 19:05
add a comment |
Alex, I literally just saw your post, Thank you for replying! I am going to give this a try. It most likely works better then mine 😃
– ndocds
Feb 21 at 19:05
Alex, I literally just saw your post, Thank you for replying! I am going to give this a try. It most likely works better then mine 😃
– ndocds
Feb 21 at 19:05
Alex, I literally just saw your post, Thank you for replying! I am going to give this a try. It most likely works better then mine 😃
– ndocds
Feb 21 at 19:05
add a comment |
0
=SUMPRODUCT(1/COUNTIF(data,data))
Where Data is the range where you have data.
Try tables out!
answered Feb 20 at 0:38
SelkieSelkie
222115
I’ll try this out as soon as I get home! Thank you. I typically use tables but I am giving this as a template and it has to be idiot proof. They are coping Dara from another report here and I’m worried if I use a table someone some where will some how will screw it up :)
– ndocds
Feb 20 at 1:39
No, that didn't work. I am able to use just COUNTIFS to compare and do a single cost the issue is column D may contain duplicates which means I'm counting column J twice. ideally I'd only want to count unique fields or remove duplicates automatically once the information is pasted into the excel.
– ndocds
Feb 20 at 2:31
Is it possible to train your end-users to paste things into a table, then run a bunch of power query off of that table?
– Selkie
Feb 20 at 16:14
It's possible however the end user may not be the only one to ever use it. We did a test run this morning and it came out pretty horrible. I ended up using a VBA macro to delete duplicates
– ndocds
Feb 20 at 18:16
add a comment |
0
=SUMPRODUCT(1/COUNTIF(data,data))
Where Data is the range where you have data.
Try tables out!
answered Feb 20 at 0:38
SelkieSelkie
222115
I’ll try this out as soon as I get home! Thank you. I typically use tables but I am giving this as a template and it has to be idiot proof. They are coping Dara from another report here and I’m worried if I use a table someone some where will some how will screw it up :)
– ndocds
Feb 20 at 1:39
No, that didn't work. I am able to use just COUNTIFS to compare and do a single cost the issue is column D may contain duplicates which means I'm counting column J twice. ideally I'd only want to count unique fields or remove duplicates automatically once the information is pasted into the excel.
– ndocds
Feb 20 at 2:31
Is it possible to train your end-users to paste things into a table, then run a bunch of power query off of that table?
– Selkie
Feb 20 at 16:14
It's possible however the end user may not be the only one to ever use it. We did a test run this morning and it came out pretty horrible. I ended up using a VBA macro to delete duplicates
– ndocds
Feb 20 at 18:16
add a comment |
0
0
0
=SUMPRODUCT(1/COUNTIF(data,data))
Where Data is the range where you have data.
Try tables out!
answered Feb 20 at 0:38
SelkieSelkie
222115
=SUMPRODUCT(1/COUNTIF(data,data))
Where Data is the range where you have data.
Try tables out!
answered Feb 20 at 0:38
SelkieSelkie
222115
answered Feb 20 at 0:38
SelkieSelkie
222115
answered Feb 20 at 0:38
SelkieSelkie
222115
answered Feb 20 at 0:38
SelkieSelkie
222115
222115
I’ll try this out as soon as I get home! Thank you. I typically use tables but I am giving this as a template and it has to be idiot proof. They are coping Dara from another report here and I’m worried if I use a table someone some where will some how will screw it up :)
– ndocds
Feb 20 at 1:39
No, that didn't work. I am able to use just COUNTIFS to compare and do a single cost the issue is column D may contain duplicates which means I'm counting column J twice. ideally I'd only want to count unique fields or remove duplicates automatically once the information is pasted into the excel.
– ndocds
Feb 20 at 2:31
Is it possible to train your end-users to paste things into a table, then run a bunch of power query off of that table?
– Selkie
Feb 20 at 16:14
It's possible however the end user may not be the only one to ever use it. We did a test run this morning and it came out pretty horrible. I ended up using a VBA macro to delete duplicates
– ndocds
Feb 20 at 18:16
add a comment |
I’ll try this out as soon as I get home! Thank you. I typically use tables but I am giving this as a template and it has to be idiot proof. They are coping Dara from another report here and I’m worried if I use a table someone some where will some how will screw it up :)
– ndocds
Feb 20 at 1:39
No, that didn't work. I am able to use just COUNTIFS to compare and do a single cost the issue is column D may contain duplicates which means I'm counting column J twice. ideally I'd only want to count unique fields or remove duplicates automatically once the information is pasted into the excel.
– ndocds
Feb 20 at 2:31
Is it possible to train your end-users to paste things into a table, then run a bunch of power query off of that table?
– Selkie
Feb 20 at 16:14
It's possible however the end user may not be the only one to ever use it. We did a test run this morning and it came out pretty horrible. I ended up using a VBA macro to delete duplicates
– ndocds
Feb 20 at 18:16
I’ll try this out as soon as I get home! Thank you. I typically use tables but I am giving this as a template and it has to be idiot proof. They are coping Dara from another report here and I’m worried if I use a table someone some where will some how will screw it up :)
– ndocds
Feb 20 at 1:39
I’ll try this out as soon as I get home! Thank you. I typically use tables but I am giving this as a template and it has to be idiot proof. They are coping Dara from another report here and I’m worried if I use a table someone some where will some how will screw it up :)
– ndocds
Feb 20 at 1:39
No, that didn't work. I am able to use just COUNTIFS to compare and do a single cost the issue is column D may contain duplicates which means I'm counting column J twice. ideally I'd only want to count unique fields or remove duplicates automatically once the information is pasted into the excel.
– ndocds
Feb 20 at 2:31
No, that didn't work. I am able to use just COUNTIFS to compare and do a single cost the issue is column D may contain duplicates which means I'm counting column J twice. ideally I'd only want to count unique fields or remove duplicates automatically once the information is pasted into the excel.
– ndocds
Feb 20 at 2:31
Is it possible to train your end-users to paste things into a table, then run a bunch of power query off of that table?
– Selkie
Feb 20 at 16:14
Is it possible to train your end-users to paste things into a table, then run a bunch of power query off of that table?
– Selkie
Feb 20 at 16:14
It's possible however the end user may not be the only one to ever use it. We did a test run this morning and it came out pretty horrible. I ended up using a VBA macro to delete duplicates
– ndocds
Feb 20 at 18:16
It's possible however the end user may not be the only one to ever use it. We did a test run this morning and it came out pretty horrible. I ended up using a VBA macro to delete duplicates
– ndocds
Feb 20 at 18:16
add a comment |
0
I ended up using
=SUMIFS('Order Data'!AI:AI,'Order Data'!C:C,A:A)
Which worked out great
answered Feb 21 at 19:03
ndocdsndocds
226
Not clear how columns AI, C or A relate to the question as posted
– Alex M
Feb 21 at 19:06
No, but for the final output I place the value on a separate page to give it a clean look but for sake of ease and to prevent confusion while asking the question I pasted everything in a single sheet. I can easily link to other sheets for the data but I felt like posting 2 different screenshots of 2 different sheets would cause confusion. Driver data and the total remain on 1 sheet and isn't altered while the reference data is on another and is altered by the user. Does that make sense? but the answer whatever the formula is I can link back to those sheets without confusing those who helped me
– ndocds
Feb 21 at 19:09
1
I get where you're coming from but it's kind of a community norm (it seems; I'm fairly new here myself) to write answers that correspond to the data in the question - you'll note that the arrangement of data in my answer matched that of your question - perhaps this answer works for you but it's of little use to other users who may have the same/similar question, and it's difficult to evaluate its worth as an answer when the data doesn't match. Put simply, if this answer were submitted by someone not the asker, it would probably receive downvotes.
– Alex M
Feb 21 at 19:40
1
That makes a really good point Alex, one I selfishly hadn't considered. Thank you! moving forward instead of trying to simplify it I'll post in it's entirety to better help the community. Thanks for your feedback man!
– ndocds
Feb 21 at 20:01
add a comment |
0
I ended up using
=SUMIFS('Order Data'!AI:AI,'Order Data'!C:C,A:A)
Which worked out great
answered Feb 21 at 19:03
ndocdsndocds
226
Not clear how columns AI, C or A relate to the question as posted
– Alex M
Feb 21 at 19:06
No, but for the final output I place the value on a separate page to give it a clean look but for sake of ease and to prevent confusion while asking the question I pasted everything in a single sheet. I can easily link to other sheets for the data but I felt like posting 2 different screenshots of 2 different sheets would cause confusion. Driver data and the total remain on 1 sheet and isn't altered while the reference data is on another and is altered by the user. Does that make sense? but the answer whatever the formula is I can link back to those sheets without confusing those who helped me
– ndocds
Feb 21 at 19:09
1
I get where you're coming from but it's kind of a community norm (it seems; I'm fairly new here myself) to write answers that correspond to the data in the question - you'll note that the arrangement of data in my answer matched that of your question - perhaps this answer works for you but it's of little use to other users who may have the same/similar question, and it's difficult to evaluate its worth as an answer when the data doesn't match. Put simply, if this answer were submitted by someone not the asker, it would probably receive downvotes.
– Alex M
Feb 21 at 19:40
1
That makes a really good point Alex, one I selfishly hadn't considered. Thank you! moving forward instead of trying to simplify it I'll post in it's entirety to better help the community. Thanks for your feedback man!
– ndocds
Feb 21 at 20:01
add a comment |
0
0
0
I ended up using
=SUMIFS('Order Data'!AI:AI,'Order Data'!C:C,A:A)
Which worked out great
answered Feb 21 at 19:03
ndocdsndocds
226
I ended up using
=SUMIFS('Order Data'!AI:AI,'Order Data'!C:C,A:A)
Which worked out great
answered Feb 21 at 19:03
ndocdsndocds
226
answered Feb 21 at 19:03
ndocdsndocds
226
answered Feb 21 at 19:03
ndocdsndocds
226
answered Feb 21 at 19:03
ndocdsndocds
226
226
Not clear how columns AI, C or A relate to the question as posted
– Alex M
Feb 21 at 19:06
No, but for the final output I place the value on a separate page to give it a clean look but for sake of ease and to prevent confusion while asking the question I pasted everything in a single sheet. I can easily link to other sheets for the data but I felt like posting 2 different screenshots of 2 different sheets would cause confusion. Driver data and the total remain on 1 sheet and isn't altered while the reference data is on another and is altered by the user. Does that make sense? but the answer whatever the formula is I can link back to those sheets without confusing those who helped me
– ndocds
Feb 21 at 19:09
1
I get where you're coming from but it's kind of a community norm (it seems; I'm fairly new here myself) to write answers that correspond to the data in the question - you'll note that the arrangement of data in my answer matched that of your question - perhaps this answer works for you but it's of little use to other users who may have the same/similar question, and it's difficult to evaluate its worth as an answer when the data doesn't match. Put simply, if this answer were submitted by someone not the asker, it would probably receive downvotes.
– Alex M
Feb 21 at 19:40
1
That makes a really good point Alex, one I selfishly hadn't considered. Thank you! moving forward instead of trying to simplify it I'll post in it's entirety to better help the community. Thanks for your feedback man!
– ndocds
Feb 21 at 20:01
add a comment |
Not clear how columns AI, C or A relate to the question as posted
– Alex M
Feb 21 at 19:06
No, but for the final output I place the value on a separate page to give it a clean look but for sake of ease and to prevent confusion while asking the question I pasted everything in a single sheet. I can easily link to other sheets for the data but I felt like posting 2 different screenshots of 2 different sheets would cause confusion. Driver data and the total remain on 1 sheet and isn't altered while the reference data is on another and is altered by the user. Does that make sense? but the answer whatever the formula is I can link back to those sheets without confusing those who helped me
– ndocds
Feb 21 at 19:09
1
I get where you're coming from but it's kind of a community norm (it seems; I'm fairly new here myself) to write answers that correspond to the data in the question - you'll note that the arrangement of data in my answer matched that of your question - perhaps this answer works for you but it's of little use to other users who may have the same/similar question, and it's difficult to evaluate its worth as an answer when the data doesn't match. Put simply, if this answer were submitted by someone not the asker, it would probably receive downvotes.
– Alex M
Feb 21 at 19:40
1
That makes a really good point Alex, one I selfishly hadn't considered. Thank you! moving forward instead of trying to simplify it I'll post in it's entirety to better help the community. Thanks for your feedback man!
– ndocds
Feb 21 at 20:01
Not clear how columns AI, C or A relate to the question as posted
– Alex M
Feb 21 at 19:06
Not clear how columns AI, C or A relate to the question as posted
– Alex M
Feb 21 at 19:06
No, but for the final output I place the value on a separate page to give it a clean look but for sake of ease and to prevent confusion while asking the question I pasted everything in a single sheet. I can easily link to other sheets for the data but I felt like posting 2 different screenshots of 2 different sheets would cause confusion. Driver data and the total remain on 1 sheet and isn't altered while the reference data is on another and is altered by the user. Does that make sense? but the answer whatever the formula is I can link back to those sheets without confusing those who helped me
– ndocds
Feb 21 at 19:09
No, but for the final output I place the value on a separate page to give it a clean look but for sake of ease and to prevent confusion while asking the question I pasted everything in a single sheet. I can easily link to other sheets for the data but I felt like posting 2 different screenshots of 2 different sheets would cause confusion. Driver data and the total remain on 1 sheet and isn't altered while the reference data is on another and is altered by the user. Does that make sense? but the answer whatever the formula is I can link back to those sheets without confusing those who helped me
– ndocds
Feb 21 at 19:09
1
1
I get where you're coming from but it's kind of a community norm (it seems; I'm fairly new here myself) to write answers that correspond to the data in the question - you'll note that the arrangement of data in my answer matched that of your question - perhaps this answer works for you but it's of little use to other users who may have the same/similar question, and it's difficult to evaluate its worth as an answer when the data doesn't match. Put simply, if this answer were submitted by someone not the asker, it would probably receive downvotes.
– Alex M
Feb 21 at 19:40
I get where you're coming from but it's kind of a community norm (it seems; I'm fairly new here myself) to write answers that correspond to the data in the question - you'll note that the arrangement of data in my answer matched that of your question - perhaps this answer works for you but it's of little use to other users who may have the same/similar question, and it's difficult to evaluate its worth as an answer when the data doesn't match. Put simply, if this answer were submitted by someone not the asker, it would probably receive downvotes.
– Alex M
Feb 21 at 19:40
1
1
That makes a really good point Alex, one I selfishly hadn't considered. Thank you! moving forward instead of trying to simplify it I'll post in it's entirety to better help the community. Thanks for your feedback man!
– ndocds
Feb 21 at 20:01
That makes a really good point Alex, one I selfishly hadn't considered. Thank you! moving forward instead of trying to simplify it I'll post in it's entirety to better help the community. Thanks for your feedback man!
– ndocds
Feb 21 at 20:01
add a comment |
draft saved
draft discarded
Thanks for contributing an answer to Super User!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1407652%2fcount-unique-with-criteria%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Possible duplicate of I wanted to count unique numbers in a excel and combine it with a countifs function
– Selkie
Feb 20 at 0:39
You could make a pivot table first, then pivot it on a copy of the pivot table to get the count.
– Jerry
Feb 20 at 9:49