Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Get number of a cell in a list.
Hi there im new and been using excel for a week or two now. What I wanted to know is this, say I had a list of dates all in a column and beside it I had another column and in this one I want a formula to say were abouts in the list the cell next to it is for example in cell D2 i want a formula that tells me what position in the list the date in cell C2 is. Sorry Im not very good at explaining this its for a group thing im doing and if i put in the date of when the person joined it would tell me what member they would be like the 93rd member or something. If you want me to explain better i'll try, Thanks for any help. -- Keno ------------------------------------------------------------------------ Keno's Profile: http://www.excelforum.com/member.php...o&userid=30832 View this thread: http://www.excelforum.com/showthread...hreadid=504956 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
In Cell Validation List & Linked Cell VLOOKUP | Excel Discussion (Misc queries) | |||
Instead of a negative number, I'd like to show zero... | Excel Worksheet Functions | |||
select cell based on a number in another cell | New Users to Excel | |||
Count Number of Characters in a cell? | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions |