• Hi there and welcome to PC Help Forum (PCHF), a more effective way to get the Tech Support you need!
    We have Experts in all areas of Tech, including Malware Removal, Crash Fixing and BSOD's , Microsoft Windows, Computer DIY and PC Hardware, Networking, Gaming, Tablets and iPads, General and Specific Software Support and so much more.

    Why not Click Here To Sign Up and start enjoying great FREE Tech Support.

    This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Delete only the first entry in Microsoft Excel but keep the following entries (Excel 2016 or 2019)

Status
Not open for further replies.
N

Nousher

PCHF Member
Jan 1, 2022
2
0
31
#1
I have a large excel file with a lot of data.

I know how to delete the duplicate values but keep one value.

I need to learn another technique.

For example, a particular column repeats some data twice, some data thrice, and some data for four or five times.
I want to delete the first entry only. I don't want to delete the second, third or fourth entry. That means only the first entry or first data will be deleted, but all the second, third, fourth or the next entry will exist.

Will anybody please tell me how I can do this?
 
#2
not that this answers your question particularly, but when I need to find out how to do things in Excel of this in-depth nature, let Google be your friend.
I know I've come across some excellent VBS code that has helped me create my own macros.
 
#3
This has been answered on oter forums that you have posed the question on and you have not responded there.

Here are a few sites that may assit you with what you are looking for. Found by doing a google search using your title.

Clear cells of contents or formats - Microsoft Support

You can clear formats from cells (e.g., number formatting), clear comments from cells, or clear the cell contents altogether, which leaves formatting in place.
support.microsoft.com support.microsoft.com

Filter for unique values or remove duplicate values - Microsoft Support

How to filter for unique values in Excel, remove duplicate values, and more.
support.microsoft.com support.microsoft.com

Add, edit, find, and delete rows by using a data form - Microsoft Support

If a worksheet contains so many columns that you can't see them all at a glance, use a form to make entering and browsing for data easier.
support.microsoft.com support.microsoft.com

Delete or remove a formula - Microsoft Support

Learn to remove or delete formulas and array formulas in an Excel spreadsheet.
support.microsoft.com support.microsoft.com

Delete a row, column, or cell from a table - Microsoft Support

Use the right-click menus to delete cells, columns, or rows in a document table.
support.microsoft.com support.microsoft.com

Find and remove duplicates - Microsoft Support

How to find and remove duplicates in Excel. Filter for unique values in large or small datasets to clean up your worksheets and workbooks.
support.microsoft.com support.microsoft.com
 
Status
Not open for further replies.
Top Bottom
Back
Forums
Resources
Menu