how can i check for #Value! ? ... or how do I do MaxIf??

G

Guest

How can I check for #Value! in a cell? ie If(c4 = #Value!, 0, 1).

Alternatively, is there a way of looking for the maximum value in a column
based upon a second column meeting a certain criteria?

The example is
1
2a
3
2b
2b
4
2c

I need to know that stream 2 has three splits (the double 2b entry is
intentional).

Thanks,
Brett
 
G

Guest

Hi,

try to use

if(iserror(c4),0,1)

hope this help
regards from Brazil
Marcelo

"Brett" escreveu:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel formula to extract a group of data from another list 2
IF command, limit to number of entries? 2
HOW DO I GET THE EQUIVALENT OF MAXIF(RANGE,CRITERIA)? 11
Can it be done 10
Solving a puzzle using "Solver"? Can already do by Iteration & functions. 2
Need VBA script to auto-insert value upon row insert 4
looping colums and rows 11
#1) value vs. formula #2) personal.xls and xlstart pathway 2

Top