Forum Discussion
Solved
Hey!
i need help for creating a code, Count several variables in the same column. like 1R, 1B, 1G and so on thank you!
If combine mtarler formulas in one
=FILTER(IF({1,0},SORT(UNIQUE(LEFT($A$2:$A$1500,LEN($A$2:$A$1500)-1))), COUNTIFS($A$2:$A$1500,SORT(UNIQUE(LEFT($A$2:$A$1500,LEN($A$2:$A$1500)-1)))&"?")), COUNTIFS($A$2:$A$1500,SORT(UNIQUE(LEFT($A$2:$A$1500,LEN($A$2:$A$1500)-1)))&"?") >0)
TheAntony hope it will explain what i mean
If combine mtarler formulas in one
=FILTER(IF({1,0},SORT(UNIQUE(LEFT($A$2:$A$1500,LEN($A$2:$A$1500)-1))),
COUNTIFS($A$2:$A$1500,SORT(UNIQUE(LEFT($A$2:$A$1500,LEN($A$2:$A$1500)-1)))&"?")),
COUNTIFS($A$2:$A$1500,SORT(UNIQUE(LEFT($A$2:$A$1500,LEN($A$2:$A$1500)-1)))&"?") >0)
- it's work fast and exactly like i want to. but how i expand it, if i want much bigger range of numbers?
You may use another range instead of $A$2:$A$1500 or use dynamic range like A2:INDEX(A:A,COUNTA(A:A))
SergeiBaklan i meant to the kinds of the number it counts 1-3,i want that it will count 1-100 how can i expand it. the code to hard for to understand how to do it myself.
thanks for the help
- I am not sure if this is meant ... please have a look and if it is not what you are looking for, please give me a little feedback.
Nikolino
I know I don't know anything (Socrates)- Hey i don't need it will count the letters, i need it will count the numbers without the letters.
And i need it will be in column not in line
