Automating multiple sheets data display

[Sacred Creationz]

First off, sorry for the confusing title. Second, I am an average excel user. Just starting into if's and formatting. I need to know how to get certain information from cells and modify it in other cells. I am doing this for a racing time sheet, payout and placement.

My first goal. I want to be able to input contestant name, then contestant car model, and last their time all into one sheet. I.E.;

race test1.xlsx


what I want to to is sort the chart by times with lowest first and having the corresponding name and car model attached. I would like the columns F,G, and H filled with this information. Column H would be times.

That isn't all I need help with, but I will see if anyone can help me with this first. I really appreciate anyone who does spend their time on me.

[JBeaucaire]

Like so...

[Sacred Creationz]

Thank you, Thank you, Thank you.

What is the Money sign in the formula for, What does it do?

[JBeaucaire]

$ symbols lock parts of cell references. A locked cell reference won't adjust itself as the cell is copied from place to place, the reference is absolute. With no $ sign, that part of the reference is relative and will adjust as the cell is copied.

$A$1 - absolute column, absolute row
A$1 - relative column, absolute row
$A1 - absolute column, relative row
A1 - relative column, relative row

[Sacred Creationz]

I am soooo close. I really tried to figure it out on my own, hopefully I don't look that dumb to you.

Anyways, I need this last bit of help. On sheet2 I have the times divided into divisions. I need to get the times in order as you can see I tried to do. Also I used your formula on this new sheet and I get an extra cell with information and I don't know where it gets it. I don't want it either. that is cell J7, K7, L7. I need it so that if there is no information in that division then I can't have it shown in that box.

Racetest123.xlsx


Thank you, you have already been a world of help!!!

[Sacred Creationz]

I got it. I finally understand the "count", "row", and "small" Thanks again!!

[JBeaucaire]

You can't use the entire column to "count" if you're going to add "other numeric data" above / below the counted data. You have to restrict the range to just the cells to count.

I've constructed a single formula in C4 that is copyable across/down through G75.
I've added a formula for your No Place column H.
I've updated the column I formula to work cleanly on this new sheet.
Your tables on the right now have formulas for each group.

[Sacred Creationz]

The file attached is my original file.

[Sacred Creationz]

how do I count from a starting cell through the rest of the column?

=IF(ROW(A2)>COUNT($C$4:$C$75), "", SMALL($C$4:$C$75, ROW(A2)))

I understand the Formula above counts from c4 to c75, I would like it to count from c4 to infinity or just the rest of the column.