=if(series

		Microsoft Office Forums > Microsoft Excel > Excel
=if(series

FAQ

Thread Tools

Display Modes

10-01-2020, 06:43 AM

Urraco

Windows 8

Office 2016

Advanced Beginner

Join Date: Apr 2018

Posts: 30

thanks for the reply, it works
one more question
on the same example, can the numbers be repeated according to the cells in column A?

AAA 1
AAA 1
AAA 1
BBB 2
BBB 2
CCC 3
CCC 3
CCC 3

Quote:

Originally Posted by Purfleet

Its much easier if you add a workbook rather than a screen dump.

Try =COUNTIFS($A$1:A1,A1)

Note the locked first A1 then the unlocked second A1. That gives you an expanding range

Attached Files

Buffer.xlsx (9.9 KB, 9 views)

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to add dot after numbering series?	kingston123	Excel	44	06-25-2020 03:59 AM
Set up Series of events	GreenBoy	Outlook	1	07-09-2018 04:43 PM
Series numbering	ericjowens	Excel	2	09-03-2015 11:20 AM
Fill Series	alamorchgirl	Excel	1	08-15-2011 10:05 AM
Data Series	Zach	Excel	1	11-05-2010 02:45 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:49 PM.