Results 1 to 14 of 14

Sequential number in column but only if other column contains certain criteria

LinkBack
- LinkBack URL
- About LinkBacks
Thread Tools
- Show Printable Version
- Subscribe to this Thread…
Rate This Thread
- Current Rating
- ‎ Excellent
- ‎ Good
- ‎ Average
- ‎ Bad
- ‎ Terrible
Display
- Switch to Linear Mode
- Switch to Hybrid Mode
- Threaded Mode

Threaded View

12-15-2023, 05:43 AM #6
TMS

View Profile

View Forum Posts
Forum Guru

Join Date

07-15-2010

Location

The Great City of Manchester, NW England ;-)

MS-Off Ver

MSO 2007,2010,365

Posts

48,581
Re: Sequential number in column but only if other column contains certain criteria
Another way:

Formula:

=IF(E4=1,SUMIF(E$4:E4,1,E$4:E4),"")
Register To Reply

« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

how to highlight more than one column after non sequential number/Date?

By FakeFace in forum Excel Formulas & Functions

Replies: 4
Last Post: 02-14-2023, 01:28 PM
[SOLVED] Combine Column Values + Sequential Number to Create Smart ID Number

By Nonoffensive Name in forum Excel Formulas & Functions

Replies: 4
Last Post: 02-18-2020, 05:10 PM
VBA - Insert next sequential number from series in a column

By pingman3 in forum Excel Programming / VBA / Macros

Replies: 2
Last Post: 03-14-2018, 02:01 AM
[SOLVED] Summing row ranges based on non-sequential column criteria

By TexasKersh in forum Excel Formulas & Functions

Replies: 9
Last Post: 06-20-2014, 08:21 AM
How to add sequential numbering down a column until the next number 1 and start over

By diaphanous1138 in forum Excel Programming / VBA / Macros

Replies: 5
Last Post: 02-13-2014, 04:52 PM
Fill sequential number down empty column, save last number, use as first number next time

By shepardrf in forum Excel Programming / VBA / Macros

Replies: 10
Last Post: 10-30-2013, 07:29 PM
Populate column in sequential order by number of records

By araki in forum Excel General

Replies: 1
Last Post: 04-28-2006, 02:20 PM

Bookmarks

Bookmarks

Posting Permissions

You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off

All times are GMT -4. The time now is 02:36 PM.

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1