Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2002: How to identify row of data ?
Hi,
Happy New Year to you. I have the following table: A B C D E Total Type 1 0 -100 0 +100 0 0 B 2 0 0 0 0 0 0 A 3 0 0 0 0 0 0 A 4 -500 0 +500 0 -750 +750 B I would like to assign row type as "A" when all the cells from column A to E are 0, otherwise it is type "B" I find that the formula I am using now is too long i.e. =IF(AND(A1=0,B1=0,C1=0,D1=0,E1=0),"A","B"). Are there any shorter formulas ? Thanks Low |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2002: How to identify row of data ?
Hi,
Maybe this =IF(COUNTIF(A1:E1,0)=5,"A","B") Mike "Mr. Low" wrote: Hi, Happy New Year to you. I have the following table: A B C D E Total Type 1 0 -100 0 +100 0 0 B 2 0 0 0 0 0 0 A 3 0 0 0 0 0 0 A 4 -500 0 +500 0 -750 +750 B I would like to assign row type as "A" when all the cells from column A to E are 0, otherwise it is type "B" I find that the formula I am using now is too long i.e. =IF(AND(A1=0,B1=0,C1=0,D1=0,E1=0),"A","B"). Are there any shorter formulas ? Thanks Low |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2002: How to identify row of data ?
This is for A thru Z:
=IF(COUNTIF(A1:Z1,"<0")=0,"A","B") -- Gary''s Student - gsnu200909 "Mr. Low" wrote: Hi, Happy New Year to you. I have the following table: A B C D E Total Type 1 0 -100 0 +100 0 0 B 2 0 0 0 0 0 0 A 3 0 0 0 0 0 0 A 4 -500 0 +500 0 -750 +750 B I would like to assign row type as "A" when all the cells from column A to E are 0, otherwise it is type "B" I find that the formula I am using now is too long i.e. =IF(AND(A1=0,B1=0,C1=0,D1=0,E1=0),"A","B"). Are there any shorter formulas ? Thanks Low |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2002: How to identify row of data ?
Hello Mike,
Thanks for the formulka. Low "Mike H" wrote: Hi, Maybe this =IF(COUNTIF(A1:E1,0)=5,"A","B") Mike "Mr. Low" wrote: Hi, Happy New Year to you. I have the following table: A B C D E Total Type 1 0 -100 0 +100 0 0 B 2 0 0 0 0 0 0 A 3 0 0 0 0 0 0 A 4 -500 0 +500 0 -750 +750 B I would like to assign row type as "A" when all the cells from column A to E are 0, otherwise it is type "B" I find that the formula I am using now is too long i.e. =IF(AND(A1=0,B1=0,C1=0,D1=0,E1=0),"A","B"). Are there any shorter formulas ? Thanks Low |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2002: How to identify row of data ?
Hi Gary's Student,
Thanks for the formulka. Low "Gary''s Student" wrote: This is for A thru Z: =IF(COUNTIF(A1:Z1,"<0")=0,"A","B") -- Gary''s Student - gsnu200909 "Mr. Low" wrote: Hi, Happy New Year to you. I have the following table: A B C D E Total Type 1 0 -100 0 +100 0 0 B 2 0 0 0 0 0 0 A 3 0 0 0 0 0 0 A 4 -500 0 +500 0 -750 +750 B I would like to assign row type as "A" when all the cells from column A to E are 0, otherwise it is type "B" I find that the formula I am using now is too long i.e. =IF(AND(A1=0,B1=0,C1=0,D1=0,E1=0),"A","B"). Are there any shorter formulas ? Thanks Low |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
data sort with excel 2002 | Excel Worksheet Functions | |||
Excel 2002: How to identify error in a column ? | Excel Discussion (Misc queries) | |||
Is there a macro to identify and remove duplicate data in Excel? | Excel Worksheet Functions | |||
identify duplicate data in excel spreadsheet | Excel Discussion (Misc queries) | |||
Data Forms in Excel 2002 | Setting up and Configuration of Excel |