Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi !
My data looks like this col1 col2 1/1/2014 species 1 2/1/2014 species 1 2/1/2014 species 2 3/1/2014 species 2 4/1/2014 species 1 8/1/2014 species 1 8/1/2014 species 3 15/1/2014 species 3 15/1/2014 species 4 21/1/2014 species 5 11/2/2014 species 1 26/2/2014 species 5 And so on... I need to figure out a way to get the time period in which I have got all the species. For eg in the above dataset, I get all 5 species by 21/1/2014. species1- 1/1/2014 species 2 - 2/1/2014 species 3 -8/1/2014.. My dataset is huge so i cannot do it manually, i basically need the period in which i get a unique list of the complete species set. Please help! Thanks in advance! Nitya |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Data Analysis disappears from the Data ribbon for no reason | Excel Discussion (Misc queries) | |||
Excel 2002 Analysis ToolPak Regression Analysis Help Requested | Excel Worksheet Functions | |||
Analysis Toolpak-Confidence Level and data analysis questions | Excel Worksheet Functions | |||
Why " data analysis plus " override " data analysis " once instal. | Excel Worksheet Functions | |||
Analysis ToolPak installed but no Data Analysis option | Excel Discussion (Misc queries) |