randomdrafter
New Member
- Joined
- Feb 8, 2014
- Messages
- 7
I have an excel with different columns with various attributes & multiple rows with corresponding values for these attributes [Numbers,texts,YES/No etc]
1st column have range & rest 6 have values need to be counted based on the ranges.
There are 12 main items in the columns for which I need to count the values in rows.
Column 1 is called level , I have levels from 1 to 7....this will repeat for next 11 main items.
So I have to count values in other columns based on the column 1 level , first from 1 to 7 range , then repeat for other 11 main items - means range must be between 1 to 7 for first main item and should start from next 1 to 7 for second main item and should repeat for all remaining main items.
So I need to count if Name column contains any value which is not a number...also need these details for first 1 to 7 range in Level column, for second 1 to 7 range & so on separately.
Similarly have to count whether any value in Description column is Blank .
Add to this the Main item I mentioned in question is the Description value corresponding level 1 in each range.
Result expected
No error in first range for name - all values conform to standard
2nd range -Description have 2 error - one blank & another number [this
column must contain texts only]
No error in 3rd range as it conforms to all cases.
Please ignore the blanks where no values filled for both Name &
description bit difficult to fill all values
Name & description corresponding to level 1 are always constant.
Some more information - ABC/WES/WED are all Assemblies (level 1),underwhich there are different sub assemblies (level 2 to 7)..So need to group ABC and get count for values which comes under this group form level 2 to level 7.
1st column have range & rest 6 have values need to be counted based on the ranges.
There are 12 main items in the columns for which I need to count the values in rows.
Column 1 is called level , I have levels from 1 to 7....this will repeat for next 11 main items.
So I have to count values in other columns based on the column 1 level , first from 1 to 7 range , then repeat for other 11 main items - means range must be between 1 to 7 for first main item and should start from next 1 to 7 for second main item and should repeat for all remaining main items.
Code:
Level Number Description
1 6586 ABC
2 6579 XYZ
3 6689
3 7854 123
4
4
4
5
6
7 7145 CRI
1 8245 WES
2 wrong RED
3
3
4
5
6
7 7787 RTE
1 6652 WED
2
3
3
4
5
6
7 8889 RET
So I need to count if Name column contains any value which is not a number...also need these details for first 1 to 7 range in Level column, for second 1 to 7 range & so on separately.
Similarly have to count whether any value in Description column is Blank .
Add to this the Main item I mentioned in question is the Description value corresponding level 1 in each range.
Result expected
Code:
Name Description
ABC 0 1
WES 1 2
WED 0 0
No error in first range for name - all values conform to standard
2nd range -Description have 2 error - one blank & another number [this
column must contain texts only]
No error in 3rd range as it conforms to all cases.
Please ignore the blanks where no values filled for both Name &
description bit difficult to fill all values
Name & description corresponding to level 1 are always constant.
Some more information - ABC/WES/WED are all Assemblies (level 1),underwhich there are different sub assemblies (level 2 to 7)..So need to group ABC and get count for values which comes under this group form level 2 to level 7.
Last edited: