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

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.
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
232
igold
igold
T
  • Solved
Formula to Number Multi-Part Transactions and Re-Start Count Each Day
Replies
6
Views
285
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
562
Dave Patton
D
D
  • Question Question
Conditional formatting for specific number of cells
Replies
9
Views
517
Fluff
Fluff
N
  • Solved
Getting the max count of unique values
Replies
7
Views
279
Natit
N

Forum statistics

Threads
1,224,738
Messages
6,180,673
Members
452,993
Latest member
FDARYABEE

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