Recount for Period (i.e. change period number Start)

HotNumbers

HotNumbers

Well-known Member
Joined
Feb 14, 2005
Messages
732
PLEASE HELP. This issue has been a mystery for me for over a week.

How do I adjust the count on Column J (Adjusted Period) according to what I select in Column C (Quantity).

When I select In Column C -1130417 I want Column J to data for that row to start with one.
Example shown in Column L
Can A Macro be run that as you can see the determining factor on when to stop the count is Column A (Issue)

I want a macro button that will provide me a with some sort of a selection that I can choice which Quantity I want to adjust for Column J Period

******************************************************************
Excel Workbook
ABCDEFGHIJKL
1IssueDescriptionQuantityYearQtrDatePeriodFamilyNameAdjusted PeriodEXAMPLe for Column J
2017SEASON 22007112/31/20061423MONT00
3017SEASON 2200723/31/20072423MONT00
4017SEASON 2-730041200736/30/20073423MONT10
5017SEASON 2-677351200749/30/20074423MONT20
6017SEASON 2-11304172008112/31/20075423MONT31
7017SEASON 2-108749200823/31/20086423MONT42
8017SEASON 2-7765200836/30/20087423MONT53
9017SEASON 2-1801201023/31/201014423MONT64
10017SEASON 2-1122011112/31/201017423MONT75
11017SEASON 2829201123/31/201118423MONT86
12018MEET2007112/31/20061613CIRCUS0
13018MEET200723/31/20072613CIRCUS0
14018MEET-729012200736/30/20073613CIRCUS10
15018MEET-672894200749/30/20074613CIRCUS20
16018MEET-11236712008112/31/20075613CIRCUS31
17018MEET-106542200823/31/20086613CIRCUS42
18018MEET-10504200836/30/20087613CIRCUS53
19018MEET3052200849/30/20088613CIRCUS64
20018MEET-355201036/30/201015613CIRCUS75
21018MEET-494201049/30/201016613CIRCUS86
22018MEET-1132011112/31/201017613CIRCUS97
23018MEET829201123/31/201118613CIRCUS108
24194CONCERT2007112/31/20061700CHEET0
25194CONCERT200723/31/20072700CHEET0
26194CONCERT200736/30/20073700CHEET0
27194CONCERT-49906200749/30/20074700CHEET1
28194CONCERT126072008112/31/20075700CHEET2
29194CONCERT3665200823/31/20086700CHEET3
30194CONCERT5393200836/30/20087700CHEET4
Sheet1
Excel 2007
 

Excel Facts

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.
You must log in or register to reply here.

Similar threads

P
  • Question Question
Analytics Project - Sumifs
Replies
1
Views
549
bobaol
B
C
  • Question Question
TIME LIMITATIONS
Replies
1
Views
84
cooleomter
C
Y
  • Question Question
VBA filter not correctly filtering dates from date/time data
2
Replies
11
Views
590
Georgiboy
Georgiboy
Cubist
  • Solved
Dynamic Formula To Label Rolling 3 Months.
Replies
1
Views
309
Eric W
Eric W
N
  • Question Question
Help creating a formula
2
Replies
11
Views
527
Fluff
Fluff

Forum statistics

Threads
1,224,585
Messages
6,179,696
Members
452,938
Latest member
babeneker

Share this page

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