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

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.
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
51
itsMelly
itsMelly
D
  • Solved
Auto fill dates and days of the week from month
Replies
3
Views
255
awoohaw
awoohaw
T
  • Question Question
Populate Names against Dates and Course Names
Replies
2
Views
96
TerryE123
T
C
  • Question Question
Create upload file based on order form
Replies
2
Views
141
Christine4711
C
T
  • Question Question
Create and auto-populate comments
Replies
3
Views
340
rlv01
R

Forum statistics

Threads
1,224,739
Messages
6,180,674
Members
452,993
Latest member
FDARYABEE

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