Home |
Search |
Today's Posts |
#1
|
|||
|
|||
adjacent data count from a binary column
I have a column of investment expense % figures wherein some of the numbers
are the same. I'm trying to do an adjacent count of the data points, net of the duplicates. I have a binary string set up with 0 indicating the repeated entries. I can't seem to find an if statement combination that ranks the data rows numerically, i.e. 1 2 2 3 3 4 5 Any suggestions? |
#2
|
|||
|
|||
mike,
You need to give a better example of your data, and be a bit clearer about the results you expect. HTH, Bernie MS Excel MVP "mike" wrote in message ... I have a column of investment expense % figures wherein some of the numbers are the same. I'm trying to do an adjacent count of the data points, net of the duplicates. I have a binary string set up with 0 indicating the repeated entries. I can't seem to find an if statement combination that ranks the data rows numerically, i.e. 1 2 2 3 3 4 5 Any suggestions? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
COUNT NON-BLANK CELLS WITH REFERENCE TO ANOTHER COLUMN | Excel Worksheet Functions | |||
Macro to Synchronize data frm svrl workbooks & columns to 1 workbo | Excel Discussion (Misc queries) | |||
How do I sort a column of data and have each data row sort accordi | Excel Discussion (Misc queries) | |||
SUMPRODUCT Formula to Count Row of data Below Matched Criteria | Excel Worksheet Functions | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions |