Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Office > OneNote

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 08-23-2017, 01:30 PM
enigmaprince enigmaprince is offline Windows 10 Office 2016
Novice
 
Join Date: Aug 2017
Posts: 1
enigmaprince is on a distinguished road
Lightbulb Need to delete duplicate of a column B based on column A and keep ColumnB if unique value to columnA

Hi Friends,

Am new to this forum, hoping to get some urgent help from THE EXPERTS
Pls read heading as - Need to delete duplicate of a column C based on column B and keep Column B if unique value(occurs more than once) to based on columnA
And expand the current selection(i mean delete that row if deleting the value of the cell)

Working on a spreadsheet which contains million record, 50 columns.
Which 1) I have sorted Column B Low to high, and Column C Latest to Oldest
Now i want to keep the latest time stamp(even if its repetitive N number of times, i would like to keep it like even once or even N times). But delete rest of the dates for that particular duplicated Column B value and expand the current selection.

I hope i could get some help. Many Thanks.

Illustrated an EXAMPLE

A B C
1 1111 12 Aug 2017 19:45:43:20


2 1111 12 Aug 2017 19:45:43:20
3 1111 12 Aug 2017 19:45:43:20
4 1111 12 Aug 2017 09:45:48:20
5 1111 12 Aug 2017 09:45:48:20
6 2222 17 Aug 2017 21:25:43:20
7 2222 17 Aug 2017 21:25:43:20
8 2222 11 Aug 2017 21:25:43:22
9 3333 20 Aug 2017 19:45:43:20
10 3333 20 Aug 2017 19:45:43:20
11 3333 20 Aug 2017 19:45:43:20
12 3333 20 Aug 2017 19:45:43:20
13 3333 20 Aug 2017 19:45:43:20
14 4444 25 Aug 2017 19:45:43:20
15 4444 21 Aug 2017 19:45:43:20


From above i want to keep 1,2,3,6,7,9,10,11,12,13,14
and delete 4,5,8,15 and also expand the current selection
Reply With Quote
Reply

Tags
#vlookup#help#formula

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Need to default the Cost Column based on another column's value ProjectCalcs Project 1 10-03-2016 07:02 AM
Merge duplicate rows but retain data from one column Willem113 Excel 1 09-21-2016 05:42 PM
Macro to Delete Duplicate Rows and Retain Unique Value expert4knowledge Excel Programming 1 02-17-2014 08:02 PM
Need help on duplicates in column; deciding which to keep based on other column nwcf Excel 3 01-31-2014 09:43 AM
Unique 3 char Alpha Numberic column mauricioaglr Excel 7 03-09-2012 06:45 PM


All times are GMT -7. The time now is 08:06 PM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft