# Based on Month, select a cell

#### PCRIDE

##### Well-known Member
Hi, I have a helper cell that I need to get the current month. For example

Data is on one row , columns are month names.

Jan, Feb, Mar, Apr helper cell
10, 20, 26, 12 =Current month, so this would display 10
14, 27, 21, 82 =Current month, so this would display 14
66, 23, 25, 22 =Current month, so this would display 66
76, 25, 22, 11 =Current month, so this would display 76
10, 20, 76, 12 =Current month, so this would display 10
98, 20, 25, 18 =Current month, so this would display 98

So two questions here
If I average the month range to get one value, in the new month how do I move the average of 4 months to the new month, but drop the old month
Second question - How do i get the value of the last month at any given time? even when new months are added the cell needs to change to the current month

### Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.

Replies
5
Views
177
Replies
10
Views
2K
Replies
11
Views
345
Replies
3
Views
137
Replies
2
Views
430

1,196,102
Messages
6,013,476
Members
441,767
Latest member
Craigh4444

### 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.

### Which adblocker are you using?

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

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