automatically fill cells because other cells have been filled - SEE OPENING POST

Hello,

the title description is terrible, sorry.
ive attached my excel doc so you can see exactly what i mean.

okay here's the deal:
on the 'individual player raw data' sheet i input everything manually.
i would then like column A on the 'Team Data' sheet to automatically recognise that a NEW date has been entered on column B on the 'individual player raw data sheet'.
so instead of manually inputting the different dates in column A on the 'Team Data' sheet (as it is currently), i would like it to happen automatically?

thank you

Originally Posted by FDibbins

tallag how is this thread any different from this 1?

http://www.excelforum.com/excel-form...xt-values.html

If it is different, please explain how...if not, please dont post duplicate threads, continue on your other 1

it is different.
im currently asking for a formula that recognises a new date being imputed in column A of the 'individual player raw data' sheet.
my previous question was asking for a way to calculate the most common text in column g in the 'individual player raw data sheet' WITHIN each date.

im not very good with excel so to me they seem like 2 different things. maybe to you theyre very similar.
i dont know how to do it. if you could please help, id be hugely grateful.

thanks.

Originally Posted by ChemistB

In A3
=MIN('Individual Player Raw Data'!$B$3:$B$250)
In A4, entered as an array formula (use CONTRL SHFT ENTER instead of ENTER. If done correctly, you'll see {} around your formula)
=IFERROR(SMALL(IF('Individual Player Raw Data'!$B$3:$B$250>A3,'Individual Player Raw Data'!$B$3:$B$250),1),"")
Does that work for you?

so i drag down from A4 (not A3) to have the rest of the column to pick up new dates as they are inputed on the first sheet?

it works perfectly.
chemistb, you are the man!!!

He's done it again.
You never fail to impress!!!!!!!!!!!!!

Thank you chemistb