adjacent data count from a binary column

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
Using COUNTIF with criteria in an adjacent column? 5
Using =IF(B10<>"",COUNTA($B$10:B10),"") to number rows in columns other than A 2
Counting Unique 1
Count continuous duplicates 2
Adding data only if adjacent to cell labeled "male"/"female" 1
Dragging values down a range using a colum to determine its length 4
Count occurences and return total 2

Back
Top