dynamic array

[Figboot]

Looking to create a dynamic array where a name will automatically be added to either column D or E once the appropriate information is entered in column B.(see example)


I've done something like this before...but can't find the file. DRAT!

[Pete_UK]

I've added formulae to C2 and to D3 and E3 and then copied these down. Just add names to column A and a day in column B and it will appear in the appropriate place in column D or E. No need for dynamic ranges.

Hope this helps.

Pete

[Figboot]

perfect...greatly appreciated. I had forgotten you needed to add the helper column...