Formula Creation/Formula Help

Status
Not open for further replies.

yessir

Board Regular
Joined
Jun 7, 2019
Messages
91
Is there a formula that could total Freq number found in column B but only when the values in column A are the same?

ABCD
LocationFreqFreqLevel
AAA1Grew
AAA1Grew
AAA1Shrunk
BBB1Grew
BBB1Shrunk
BBB1Grew
CCC1Grew
CCC1Shrunk
CCC1Grew
CCC1Grew
CCC11No Change

Attached is an example of what the formula would output.

ABCDE
LocationFreqFreqLevelLevel Increase
AAA1Grew
AAA1Grew
AAA1Shrunk
2​
BBB1Grew
BBB1Shrunk
BBB1Grew
2​
CCC1Grew
CCC1Shrunk
CCC1Grew
CCC1Grew
CCC11No Change
4​
 
I do have another question for a different way to view data. Is there a way to measure the shifts time times from one date to another? For this

ABCD
LocationTime
7/1/2015​
6/1/2015​
AAA
10:10​
1​
AAA
10:16​
1​
AAA
13:53​
1​
AAA
15:37​
1​
AAA
16:25​
1​
AAA
17:35​
1​
AAA
21:35​
1​
AAA
21:44​
1​
BBB
14:03​
1​
BBB
14:13​
1​

To then look like something like this?

AAAKept 10:00
AAAKept 13:00
AAAKept 15:00
AAALost 16:00
AAAGained 17:00
AAAKept 21:00
BBBKept 14:00

I'm unsure about the format of it as well? But this is my best visualization. Anything helps! Thanks!
 
Upvote 0

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)
In future please do not duplicate your questions.
As you have already got an answer on your new thread, I will leave that running & close this one.
 
Upvote 0
Status
Not open for further replies.

Forum statistics

Threads
1,213,527
Messages
6,114,150
Members
448,552
Latest member
WORKINGWITHNOLEADER

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top