Question description:
This user has given permission to use the problem statement for this
blog.
Hi,
I'm trying to count if there was growth in a period and how much time the growth has sustained. So I need to start my count in a values greater than 0 to determine the length of time. My problem is, starting a count on the first negative number in a column determined by time, not counting every positive number in the same time series.
Solved by B. Q. in 25 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
02/05/2018 - 06:03
Hi
Excelchat Expert
02/05/2018 - 06:03
Hi
User
02/05/2018 - 06:03
hi, couldnt answer the last question
Excelchat Expert
02/05/2018 - 06:03
Welcome to Got it Pro
Excelchat Expert
02/05/2018 - 06:03
Can you paste your sample data and let me know your requirement
User
02/05/2018 - 06:04
the yellow determine the first start of growth
User
02/05/2018 - 06:04
i want to learn how to count it instead of selecting it one by one
Excelchat Expert
02/05/2018 - 06:04
Which yellow?
User
02/05/2018 - 06:04
at the bottom
User
02/05/2018 - 06:04
on 2017/04
Excelchat Expert
02/05/2018 - 06:05
Yes
Excelchat Expert
02/05/2018 - 06:05
but how do i read it?
Excelchat Expert
02/05/2018 - 06:05
Please explain
User
02/05/2018 - 06:05
im trying to determine the quarterly grown of every state
User
02/05/2018 - 06:06
starting from the closest quarter
User
02/05/2018 - 06:06
that is 2017/04
Excelchat Expert
02/05/2018 - 06:06
ok
Excelchat Expert
02/05/2018 - 06:06
So?
User
02/05/2018 - 06:06
I want to know the period of time there has been growth
User
02/05/2018 - 06:07
and the only way to count it starting from the closest negative number is one by one
Excelchat Expert
02/05/2018 - 06:07
In cell B2
Excelchat Expert
02/05/2018 - 06:07
there has been growth as it is positive
User
02/05/2018 - 06:07
yes
User
02/05/2018 - 06:07
But the count needs to start from the bottom up sinse its the closest to the present
User
02/05/2018 - 06:07
since*
Excelchat Expert
02/05/2018 - 06:08
why do we need to count only the yellow ones?
User
02/05/2018 - 06:09
so, the yellow ones represent growth, I marked them because I already counted them one by one, what I want you to teach me is how to do it by formula, like count if
User
02/05/2018 - 06:09
the thing is count if would count every positive number in one column
User
02/05/2018 - 06:09
and I want to start counting from the first negative from the bottom up
Excelchat Expert
02/05/2018 - 06:09
Ohk
Excelchat Expert
02/05/2018 - 06:09
Let me see
User
02/05/2018 - 06:12
I know my explanation is confusing im sorry
Excelchat Expert
02/05/2018 - 06:12
Can you arrange this data from recent to alst
User
02/05/2018 - 06:12
yes
Excelchat Expert
02/05/2018 - 06:12
Have put on sheet 2
User
02/05/2018 - 06:14
for example in column B growth start in 2009/04 being B34 and goes till 2017/04
Excelchat Expert
02/05/2018 - 06:18
Can you see the formula that i have created
Excelchat Expert
02/05/2018 - 06:18
Row 58 to row 112
Excelchat Expert
02/05/2018 - 06:18
Do you see?
User
02/05/2018 - 06:18
yes
Excelchat Expert
02/05/2018 - 06:19
So your answer will be the number before first blank
Excelchat Expert
02/05/2018 - 06:19
See and match with previous sheet
Excelchat Expert
02/05/2018 - 06:20
Let me know of that helps
Excelchat Expert
02/05/2018 - 06:20
Are you there?
User
02/05/2018 - 06:20
yes im here
Excelchat Expert
02/05/2018 - 06:21
This is the best method i could think of
User
02/05/2018 - 06:21
we are looking at it, figuring it out thank you
Excelchat Expert
02/05/2018 - 06:21
rather than manually colour coding
Excelchat Expert
02/05/2018 - 06:21
Cool
User
02/05/2018 - 06:23
So, we just extend the formula for all the spaces?
Excelchat Expert
02/05/2018 - 06:23
Since it is on columns there is no way to stop at first blank
Excelchat Expert
02/05/2018 - 06:23
But your answer will be value just before the blank
Excelchat Expert
02/05/2018 - 06:25
Are you able to get it?
User
02/05/2018 - 06:27
yes
User
02/05/2018 - 06:27
thank you, we are gonna copy the formula
Excelchat Expert
02/05/2018 - 06:27
Great
Excelchat Expert
02/05/2018 - 06:27
Cool
Excelchat Expert
02/05/2018 - 06:27
Please do give good rating
Excelchat Expert
02/05/2018 - 06:27
It would really help a lot
User
02/05/2018 - 06:28
sure, we are very grateful have a nice day! :)
Excelchat Expert
02/05/2018 - 06:28
You too have a good day
Excelchat Expert
02/05/2018 - 06:28
:)
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.