Question description:
This user has given permission to use the problem statement for this
blog.
I have a question about Excel, and was wondering if you had a solution.
When I am analyzing scores from patients, I typically have to state how many clients had an improved score. So far, I have done this manually by looking at each score from each client. This gets tedious as I have 15-200 or more clients to look at. Is there a formula or program that can compare scores to see if there is an increase or decrease between multiple scores?
Thank You,
Solved by I. Y. in 40 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
07/06/2018 - 09:10
Hello there, welcome to Got It Pro.
User
07/06/2018 - 09:10
150 Employees
Excelchat Expert
07/06/2018 - 09:11
Hope you are doing well.
User
07/06/2018 - 09:11
Yes
User
07/06/2018 - 09:11
Did you see the users question, I am in the IT dept
Excelchat Expert
07/06/2018 - 09:11
Yes.
User
07/06/2018 - 09:12
Do you know what formula to use ??
Excelchat Expert
07/06/2018 - 09:12
Okay let me show you a few ways.
Excelchat Expert
07/06/2018 - 09:13
Please have a look at the Excel Online Panel on the middle of the screen.
User
07/06/2018 - 09:13
I am seeing it,,
Excelchat Expert
07/06/2018 - 09:14
Alright.
Excelchat Expert
07/06/2018 - 09:14
So, does the dataset look okay?
User
07/06/2018 - 09:15
Yes,,,
Excelchat Expert
07/06/2018 - 09:15
Alright.
Excelchat Expert
07/06/2018 - 09:16
Does this work?
User
07/06/2018 - 09:17
I think so....I am not the one asking. Its a data analyst. Did you use a formulac??
Excelchat Expert
07/06/2018 - 09:18
Alright. No I didn't use a formula. I used conditional formatting.
User
07/06/2018 - 09:18
He send an email with the question I presented to you guys
Excelchat Expert
07/06/2018 - 09:18
I can add a formula to the condition as well.
Excelchat Expert
07/06/2018 - 09:18
Okay, so this would do fine.
User
07/06/2018 - 09:18
Add the formula,,,please
Excelchat Expert
07/06/2018 - 09:18
Analysts always prefer visual stuff.
Excelchat Expert
07/06/2018 - 09:18
Alright.
Excelchat Expert
07/06/2018 - 09:20
Okay I have added the formula.
Excelchat Expert
07/06/2018 - 09:20
Let me explain how I did it.
Excelchat Expert
07/06/2018 - 09:21
May I know at first which version of Excel are you using?
User
07/06/2018 - 09:21
2007
Excelchat Expert
07/06/2018 - 09:21
Alright
User
07/06/2018 - 09:21
I dont see the formula on there,,
Excelchat Expert
07/06/2018 - 09:22
Okay, so at first you select the cells D3:D12
Excelchat Expert
07/06/2018 - 09:22
Go to Home> Conditional Formatting
Excelchat Expert
07/06/2018 - 09:22
Manage rules
Excelchat Expert
07/06/2018 - 09:23
First you'll have to copy this data to Excel on your computer.
Excelchat Expert
07/06/2018 - 09:23
Now select the cells D3:D12
Excelchat Expert
07/06/2018 - 09:23
Home > Conditional Formatting>New Rule
Excelchat Expert
07/06/2018 - 09:24
Select Use a formula to determine which cells to format
Excelchat Expert
07/06/2018 - 09:24
On the input bar add =D3:D12>56
User
07/06/2018 - 09:25
Alright,,,,hold on. I am creating it in Excel
Excelchat Expert
07/06/2018 - 09:25
Click format
Excelchat Expert
07/06/2018 - 09:25
Okay.
Excelchat Expert
07/06/2018 - 09:27
Were you able to do it?
User
07/06/2018 - 09:28
Yes,,,thx for you help
Excelchat Expert
07/06/2018 - 09:28
Excellent
Excelchat Expert
07/06/2018 - 09:28
You're welcome
Excelchat Expert
07/06/2018 - 09:28
Thanks for using Got It Pro.
Excelchat Expert
07/06/2018 - 09:28
Have a good day!!
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.