do nothing when false is returned

  • Thread starter Thread starter curtkram
  • Start date Start date
C

curtkram

Hi. I am trying to bring information from one worksheet to another.
do not want multiple entries to appear multiple times. I have bee
using the if() command, but it returns a false value instead of doin
nothing. is there any way to tell the if() command to do nothing i
the value is false? otherwise, is there another way i can remov
duplicate rows? thank you for your help.

curt
:confused
 
If(condition = True, "Do you stuff", "")

to remove duplicate rows based on formula
Assuming data in column A, type in B1
= If(Countif(A1:A100,A1)>1,"Duplicate","")

HTH
Kolyan
 
Hi,

If you want blanks where the result is false, you can use

IF( CONDITION,RESULT IF TRUE,"")

For Eg. If(B1>100,B1,"")

Regards

Govind.
 
-If(condition = True, "Do you stuff", "")-

ok, so i got that, but it returns an empty cell when the value i
false


-to remove duplicate rows based on formula
Assuming data in column A, type in B1
= If(Countif(A1:A100,A1)>1,"Duplicate","")-

so this makes the cell say 'duplicate' when there are multiple entries


i need to find a way for excel to not put in a cell or row at all. so
say i have a list of 50 things, and 10 of them are duplicates. then i
there a way i can narrow it down to only 40 rows? i have it set up s
it counts how many of each item there is. what i don't know how to d
is put in only 1 row if there are 6 instances of the same thing.

so, in the end, can i take that list of 6 identical rows, and narrow i
down to 1 row, where it says '6' in a column (appropriately title
qty.)

sorry if i was too vague, and thank you for your help :
 
Back
Top