R
Ranjith Kurian
I have a column called as COST as shown below, i need a excel formula to pick
the data count from cost column to my count column based on Cost Range column.
example:
Cost column
3
3.5
4
2
2.5
1
Cost Range column count column
4-3
2-1
Answer expected:
Cost Range column count column
4-3 3
2-1 3
Count column is nothing but it should count less than 4 and greater than 3
(3,3.5 and 4 are the answers)
the data count from cost column to my count column based on Cost Range column.
example:
Cost column
3
3.5
4
2
2.5
1
Cost Range column count column
4-3
2-1
Answer expected:
Cost Range column count column
4-3 3
2-1 3
Count column is nothing but it should count less than 4 and greater than 3
(3,3.5 and 4 are the answers)