Show Starting (Number 1) and Max only

ibmy

ibmy

Board Regular
Joined
Mar 4, 2020
Messages
134
Office Version
  1. 2016
Platform
  1. Windows
Hi,

How get the result in column B?

Appreaciate all your help.

Book1
AB
1DataResult
2
311
40
50
611
71
81
914
100
1111
1212
130
Sheet1
 

Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes
Sort by date Sort by votes
I'm only taking 1 guess, if it's not right then you will need to explain what you want clearly.
Book5
AB
1DataResult
2
311
40 
50 
611
71 
81 
914
100 
1111
1212
130 
Sheet10
Cell Formulas
RangeFormula
B3:B13B3=IF(AND(A2=0,A3<>0),A3,IF(AND(A4=0,A3<>0),ROW(B3)-IFERROR(MATCH(1E+100,B$2:B2),0),""))
 
Upvote 0
Solution
You must log in or register to reply here.

Similar threads

S
  • Question Question
Linear Programming
Replies
1
Views
212
igold
igold
T
  • Solved
Formula to Number Multi-Part Transactions and Re-Start Count Each Day
Replies
6
Views
267
turn7or5
T
T
  • Solved
take a column of daily transaction numbers with duplicates and show in different table with its corresponding date and no duplicates
2
Replies
13
Views
516
Dave Patton
D
D
  • Question Question
Conditional formatting for specific number of cells
Replies
9
Views
386
Fluff
Fluff
N
  • Solved
Getting the max count of unique values
Replies
7
Views
270
Natit
N

Forum statistics

Threads
1,223,702
Messages
6,173,931
Members
452,539
Latest member
delvey

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top