Results 1 to 3 of 3

Formula to copy cell from source column and add +1 for each duplicate found.

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

07-29-2020, 10:13 AM #3
PaulM100

View Profile

View Forum Posts

Visit Homepage
Forum Expert

Join Date

10-09-2017

Location

UK

MS-Off Ver

Office 365

Posts

2,108
Re: Formula to copy cell from source column and add +1 for each duplicate found.

If your data is in A, then in B: =A2&"-"&COUNTIF(A$1:A1,A1)+1

Click the * to say thanks.
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

[SOLVED] Search for value in row. if found, copy column formulas into found column range

By Groovicles in forum Excel Programming / VBA / Macros

Replies: 3
Last Post: 05-23-2017, 10:42 AM
[SOLVED] Macro to copy cell from the next column if a certain word is found

By prvimoon in forum Excel Programming / VBA / Macros

Replies: 2
Last Post: 02-05-2016, 07:18 PM
Search a column for a name and if found copy cell from the same row in a different column

By Graham987 in forum Excel Formulas & Functions

Replies: 8
Last Post: 06-04-2013, 04:36 AM
Multi-Column Duplicate Finder and If duplicate found, make cell blank in 1st column

By ImStanding in forum Excel Formulas & Functions

Replies: 1
Last Post: 06-01-2013, 01:27 AM
Is a Macro going to be the best way to copy Column range if value cell D87 is found

By extremecorvette in forum Excel Programming / VBA / Macros

Replies: 1
Last Post: 12-21-2011, 12:00 PM
Copy source cell down a column

By rhudgins in forum Excel Programming / VBA / Macros

Replies: 9
Last Post: 10-20-2010, 05:05 PM
user box options if cell entry is a duplicate found in a table column

By humboldtguy in forum Excel Programming / VBA / Macros

Replies: 8
Last Post: 08-24-2009, 02:04 PM

Tags for this Thread

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 11:43 AM.

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1