Function/Formula in Excel to count Unique values matching criteria

M

mando415

New Member
Joined
Jun 4, 2013
Messages
8
Hi - I have a worksheet. I would like to count unique number of "Trans" in column A only if value of cells in column B "Type" equals "Return". In example below, I would want to see the value "3" as total.

I am banging my head over this and would appreciate any advise. :confused:

Trans Type
1 Return
2 Return
2 Return
3 Exch
4 Exch
5 Return
5 Return

Thank you
 
Sort by date Sort by votes
richh said:
...
Here's the table:

Sheet 1

Dealer | Num. People | Num. Apps. | Funded?
Ford |3|2||
Chevy |3|3||
Buick |3|2||


Sheet 2

Dealer | App. Num. | Funded?
Ford |1 |Funded
Ford |1 |Funded
Ford |2 |Pending
Chevy |3 |Pending
Chevy |4 |Pending
Chevy |5 |Funded
Buick |6 |Funded
Buick |6 |Funded
Buick |7 |Pending
Click to expand...

It's unclear what you want to count. Would you indicate that along with the actual result you want to see?
 
Upvote 0

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.
What I want to count is the number of people (applicants) that went to the Ford dealership(Num. People column). Of those people, how many applications were made (Num. Apps.). There are times when there are co-applicants, meaning two people per application. the forumula provided earlier in this thread seems to have worked for it. In the "Funded?" column, I want to count the applications that were marked funded but exclude dupliate entries in the App Num column.

In the "Funded?" column on sheet 1, I want to count the numbers of applications marked "Funded" on sheet 2 for the specific dealer that excludes duplicate app. numbers.

IE - App number 1 had two entries on sheet 2, meaning there were two people on this applcation. The single application was funded, but both cells are marked funded just because I'm keeping track of both number of applicants and the number of applications.
 
Upvote 0
Sure. I'm going to expand Sheet 2 a bit so it can be a little clearer. It'd look like this:

Sheet 1

Dealer | Num. People | Num. Apps. | Funded?
Ford |3|2|1|
Chevy |3|3|1|
Buick |3|2|1|


Sheet 2

Dealer | Name | App. Num. | Funded?
Ford | Billy J. | 1 |Funded
Ford | Bobby J. 1 |Funded
Ford | Jack H. | 2 |Pending
Chevy |Roger C. | 3 |Pending
Chevy | Kathy B. | 4 |Pending
Chevy |Arnold S. | 5 |Funded
Buick |Terry L. | 6 |Funded
Buick |Barry L. | 6 |Funded
Buick | Mona U. | 7 |Pending

The difference is in the "Funded?" column on sheet 1. They're all at 1 because that's how many unique applications were marked as such in column b in sheet 2. The three entries for "Ford" on sheet 2 represent three people. Two of the people are co-applicants on the same application, so that's why there are two "number 1" application numbers in column B. The same goes for App number 6; two people went to the Buick dealership and applied for a car. They have the same application number and it was funded. I want to count the number of unique applications for the specified dealer that were funded. If it counts "Ford | Billy J. | 1 | Funded" and "Ford | Bobby J. | 1 | Funded", it's not an accurate figure.
 
Upvote 0
Try...

Sheet1!D2, confirmed with CONTROL+SHIFT+ENTER, and copied down:

=SUM(IF(FREQUENCY(IF(Sheet2!$A$2:$A$10=Sheet1!A2,IF(Sheet2!$D$2:$D$10="Funded",MATCH("~"&Sheet2!$C$2:$C$10,Sheet2!$C$2:$C$10&"",0))),ROW(Sheet2!$C$2:$C$10)-ROW(Sheet2!$C$2)+1)>0,1))

Hope this helps!
 
Upvote 0
Ok I've been stumped with this all day.

Row A contains a random assortment of part numbers
Row B contains a random assortment of part numbers

Our Part Your Part
31 1
15 2
25 2
68 3
45 3
45 3
98 4
31 5
25 5
95 5
45 5
31 7
31 8


I want to count how many times b2 has a unique value in column A

So c2=1
so c3=2
so c4=3

and so on downing down using your part as criteria


I have over 8000 rows... When I use the

=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B2,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),IF($B$2:$B$8639=B2,MATCH($A$2:$A$8639,$A$2:$A$8639)))>0,1)) (ctrl-shift-enter) it takes forever
I have both text and numbers in both cells
 
Upvote 0
Superstar31 said:
Ok I've been stumped with this all day.

Row A contains a random assortment of part numbers
Row B contains a random assortment of part numbers

Our Part Your Part
31 1
15 2
25 2
68 3
45 3
45 3
98 4
31 5
25 5
95 5
45 5
31 7
31 8


I want to count how many times b2 has a unique value in column A

So c2=1
so c3=2
so c4=3

and so on downing down using your part as criteria


I have over 8000 rows... When I use the

=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B2,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),IF($B$2:$B$8639=B2,MATCH($A$2:$A$8639,$A$2:$A$8639)))>0,1)) (ctrl-shift-enter) it takes forever
I have both text and numbers in both cells
Click to expand...

You are creating too many array formulas...

Does the following set up fare better?

Let Sheet1 house the data and define accordingly Ivec as referring to:

=ROW($A$2:$A$8639)-ROW($A$2)+1

Control+shift+enter, not just enter:

=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B2,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),Ivec),1))

If still unsatisfactory, try a SQL set up (there are some posts on this board using SQL for unique counting).
 
Upvote 0
Aladin Akyurek said:
You are creating too many array formulas...

Does the following set up fare better?

Let Sheet1 house the data and define accordingly Ivec as referring to:

=ROW($A$2:$A$8639)-ROW($A$2)+1

Control+shift+enter, not just enter:

=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B2,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),Ivec),1))

If still unsatisfactory, try a SQL set up (there are some posts on this board using SQL for unique counting).
Click to expand...

am i doing this wrong


Excel 2010
ABCD
1My PartYour PartCountCount 2
3591part127521
3592part127521
3593part127521
3594part127521
3595part127521
3604part227421
3605part227421
3606part227421
3607part227421
4758part327421
4759part327421
4760part327421
4761part327421
4762part327421
4763part327421
4764part327421
4765part327421
4766part327421
4767part327421
4768part327421
4769part327521
4770part327521
4771part327521
4772part327521
4773part327521
4774part327521
4775part327521
4776part327521
4777part327521
4778part327521
4779part327521
4780part327521
4781part327521
4782part327611
4783part327611
Sheet1
Cell Formulas
RangeFormula
D3591=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B3591,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),Ivec),1))
D3592=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B3592,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),Ivec),1))
D3593=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B3593,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),Ivec),1))
D3594=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B3594,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),Ivec),1))
D3595=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B3595,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),Ivec),1))
D3604=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B3604,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),Ivec),1))
D3605=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B3605,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),Ivec),1))
D3606=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B3606,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),Ivec),1))
D3607=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B3607,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),Ivec),1))
D4758=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B4758,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),Ivec),1))
D4759=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B4759,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),Ivec),1))
D4760=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B4760,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),Ivec),1))
D4761=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B4761,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),Ivec),1))
D4762=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B4762,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),Ivec),1))
D4763=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B4763,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),Ivec),1))
D4764=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B4764,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),Ivec),1))
D4765=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B4765,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),Ivec),1))
D4766=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B4766,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),Ivec),1))
D4767=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B4767,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),Ivec),1))
D4768=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B4768,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),Ivec),1))
D4769=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B4769,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),Ivec),1))
D4770=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B4770,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),Ivec),1))
D4771=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B4771,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),Ivec),1))
D4772=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B4772,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),Ivec),1))
D4773=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B4773,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),Ivec),1))
D4774=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B4774,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),Ivec),1))
D4775=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B4775,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),Ivec),1))
D4776=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B4776,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),Ivec),1))
D4777=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B4777,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),Ivec),1))
D4778=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B4778,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),Ivec),1))
D4779=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B4779,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),Ivec),1))
D4780=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B4780,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),Ivec),1))
D4781=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B4781,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),Ivec),1))
D4782=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B4782,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),Ivec),1))
D4783=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B4783,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),Ivec),1))
C3591{=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B3591,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),IF($B$2:$B$8639=B3591,MATCH($A$2:$A$8639,$A$2:$A$8639)))>0,1))}
C3592{=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B3592,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),IF($B$2:$B$8639=B3592,MATCH($A$2:$A$8639,$A$2:$A$8639)))>0,1))}
C3593{=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B3593,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),IF($B$2:$B$8639=B3593,MATCH($A$2:$A$8639,$A$2:$A$8639)))>0,1))}
C3594{=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B3594,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),IF($B$2:$B$8639=B3594,MATCH($A$2:$A$8639,$A$2:$A$8639)))>0,1))}
C3595{=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B3595,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),IF($B$2:$B$8639=B3595,MATCH($A$2:$A$8639,$A$2:$A$8639)))>0,1))}
C3604{=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B3604,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),IF($B$2:$B$8639=B3604,MATCH($A$2:$A$8639,$A$2:$A$8639)))>0,1))}
C3605{=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B3605,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),IF($B$2:$B$8639=B3605,MATCH($A$2:$A$8639,$A$2:$A$8639)))>0,1))}
C3606{=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B3606,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),IF($B$2:$B$8639=B3606,MATCH($A$2:$A$8639,$A$2:$A$8639)))>0,1))}
C3607{=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B3607,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),IF($B$2:$B$8639=B3607,MATCH($A$2:$A$8639,$A$2:$A$8639)))>0,1))}
C4758{=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B4758,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),IF($B$2:$B$8639=B4758,MATCH($A$2:$A$8639,$A$2:$A$8639)))>0,1))}
C4759{=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B4759,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),IF($B$2:$B$8639=B4759,MATCH($A$2:$A$8639,$A$2:$A$8639)))>0,1))}
C4760{=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B4760,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),IF($B$2:$B$8639=B4760,MATCH($A$2:$A$8639,$A$2:$A$8639)))>0,1))}
C4761{=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B4761,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),IF($B$2:$B$8639=B4761,MATCH($A$2:$A$8639,$A$2:$A$8639)))>0,1))}
C4762{=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B4762,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),IF($B$2:$B$8639=B4762,MATCH($A$2:$A$8639,$A$2:$A$8639)))>0,1))}
C4763{=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B4763,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),IF($B$2:$B$8639=B4763,MATCH($A$2:$A$8639,$A$2:$A$8639)))>0,1))}
C4764{=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B4764,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),IF($B$2:$B$8639=B4764,MATCH($A$2:$A$8639,$A$2:$A$8639)))>0,1))}
C4765{=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B4765,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),IF($B$2:$B$8639=B4765,MATCH($A$2:$A$8639,$A$2:$A$8639)))>0,1))}
C4766{=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B4766,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),IF($B$2:$B$8639=B4766,MATCH($A$2:$A$8639,$A$2:$A$8639)))>0,1))}
C4767{=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B4767,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),IF($B$2:$B$8639=B4767,MATCH($A$2:$A$8639,$A$2:$A$8639)))>0,1))}
C4768{=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B4768,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),IF($B$2:$B$8639=B4768,MATCH($A$2:$A$8639,$A$2:$A$8639)))>0,1))}
C4769{=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B4769,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),IF($B$2:$B$8639=B4769,MATCH($A$2:$A$8639,$A$2:$A$8639)))>0,1))}
C4770{=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B4770,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),IF($B$2:$B$8639=B4770,MATCH($A$2:$A$8639,$A$2:$A$8639)))>0,1))}
C4771{=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B4771,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),IF($B$2:$B$8639=B4771,MATCH($A$2:$A$8639,$A$2:$A$8639)))>0,1))}
C4772{=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B4772,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),IF($B$2:$B$8639=B4772,MATCH($A$2:$A$8639,$A$2:$A$8639)))>0,1))}
C4773{=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B4773,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),IF($B$2:$B$8639=B4773,MATCH($A$2:$A$8639,$A$2:$A$8639)))>0,1))}
C4774{=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B4774,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),IF($B$2:$B$8639=B4774,MATCH($A$2:$A$8639,$A$2:$A$8639)))>0,1))}
C4775{=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B4775,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),IF($B$2:$B$8639=B4775,MATCH($A$2:$A$8639,$A$2:$A$8639)))>0,1))}
C4776{=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B4776,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),IF($B$2:$B$8639=B4776,MATCH($A$2:$A$8639,$A$2:$A$8639)))>0,1))}
C4777{=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B4777,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),IF($B$2:$B$8639=B4777,MATCH($A$2:$A$8639,$A$2:$A$8639)))>0,1))}
C4778{=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B4778,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),IF($B$2:$B$8639=B4778,MATCH($A$2:$A$8639,$A$2:$A$8639)))>0,1))}
C4779{=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B4779,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),IF($B$2:$B$8639=B4779,MATCH($A$2:$A$8639,$A$2:$A$8639)))>0,1))}
C4780{=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B4780,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),IF($B$2:$B$8639=B4780,MATCH($A$2:$A$8639,$A$2:$A$8639)))>0,1))}
C4781{=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B4781,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),IF($B$2:$B$8639=B4781,MATCH($A$2:$A$8639,$A$2:$A$8639)))>0,1))}
C4782{=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B4782,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),IF($B$2:$B$8639=B4782,MATCH($A$2:$A$8639,$A$2:$A$8639)))>0,1))}
C4783{=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B4783,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),IF($B$2:$B$8639=B4783,MATCH($A$2:$A$8639,$A$2:$A$8639)))>0,1))}
Press CTRL+SHIFT+ENTER to enter array formulas.
Named Ranges
NameRefers ToCells
Ivec=Sheet1!$A$2:$B$8639
 
Upvote 0
You can avoid posting so many formulas in the posting application you use.

By the way:

=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B2,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),Ivec),1))

too must be confirmed with control+shift+enter.

Ivec must be defined as referring to, this time the sheet prefix not omitted:

=ROW(Sheet1!$A$2:$A$8639)-ROW(Sheet1!$A$2)+1
 
Upvote 0
Aladin Akyurek said:
You can avoid posting so many formulas in the posting application you use.

By the way:

=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B2,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),Ivec),1))

too must be confirmed with control+shift+enter.

Ivec must be defined as referring to, this time the sheet prefix not omitted:

=ROW(Sheet1!$A$2:$A$8639)-ROW(Sheet1!$A$2)+1
Click to expand...

Worked perfect! Thanks... wish their was a simplier was to get unique counts thought.
 
Upvote 0
You must log in or register to reply here.

Similar threads

L
  • Solved
Count of Unique Values in a Column of data with Comma Delimitted, Multiple Cell Values
Replies
5
Views
125
Fluff
Fluff
sharky12345
  • Solved
Count unique values with criteria (non-formula solution)
Replies
4
Views
225
Peter_SSs
Peter_SSs
drom
  • Solved
Count unique values for filtered column
Replies
1
Views
196
myall_blues
myall_blues
M
  • Question
Dynamic Graphing - with source data from a "Unique" formula
Replies
5
Views
136
Cubist
Cubist
L
  • Question
Return text from cell in column containing text, as long as values in other columns match several criteria
Replies
7
Views
413
etaf
etaf

Forum statistics

Threads
1,215,343
Messages
6,124,405
Members
449,157
Latest member
mytux

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top