auto populate

SteveO59L

Well-known Member
Joined
Apr 21, 2004
Messages
7,896
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
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
30,249
Office Version
365
Platform
Windows
How about
=IFERROR(AGGREGATE(15,6,$D$2:$S$2/($D3:$S3<>""),1),"")
 

Forum statistics

Threads
1,077,851
Messages
5,336,753
Members
399,100
Latest member
darcob

Some videos you may like

This Week's Hot Topics

Top