auto populate

S

SteveO59L

Well-known Member
Joined
Apr 21, 2004
Messages
7,899
ok, i'll explain as best I can

in d2:s2 I have week numbers

in a3:a100 I have part numbers

what I am looking to achieve is if I populate (as an example) h15

a formula in c15 will populate with the relevant week number from row 2
 

Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).
Sort by date Sort by votes
How about
=IFERROR(AGGREGATE(15,6,$D$2:$S$2/($D3:$S3<>""),1),"")
 
Upvote 0
You must log in or register to reply here.

Similar threads

itsMelly
  • Question Question
Auto Populate Running Average onto Second Sheet.
Replies
0
Views
46
itsMelly
itsMelly
D
  • Solved
Auto fill dates and days of the week from month
Replies
3
Views
245
awoohaw
awoohaw
T
  • Question Question
Populate Names against Dates and Course Names
Replies
2
Views
85
TerryE123
T
C
  • Question Question
Create upload file based on order form
Replies
2
Views
119
Christine4711
C
T
  • Question Question
Create and auto-populate comments
Replies
3
Views
327
rlv01
R

Forum statistics

Threads
1,223,703
Messages
6,173,977
Members
452,540
Latest member
haasro02

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