[image] I want to find out the A B and C column write them to another excel sheet and select column B start with FM7171 finally delete the same row,just save one row A=6 B=FM7171_A… C=C6 how can I do it with excel function or Excel VBA also ok thank you very much

Okay… I am gonna help you do this with just excel shortcuts. You can use Excel Application Scope to open excel Select Range Sheet1 - A1 to move to the header Send hotkey Ctrl + Shift + L - shortcuts for applying filter (make sure filter was not applied earlier) Select Range Sheet1 - B1 to mov…

How to distinct the excel

Help

indra (Indra) August 2, 2018, 2:24am 5

@jmy Follow below link
Select Distinct and obtain all row of it - #4 by Dominic

Topic		Replies	Views
Select Distinct and obtain all row of it Help	16	20709	June 25, 2022
Distinct column based on a condition Activities excel , activities , question	4	148	January 3, 2024
Eliminate Duplicates in Excel Help excel , activities , question	3	1814	November 6, 2019
How to remove duplicate andalso delete this row Activities excel , activities , question	7	146	January 12, 2024
Managing duplicate entries Studio studio , question , activities_panel	4	710	May 25, 2021

Most Active Users - Yesterday
ashokkarale
MD_Farhan1
Ajay_Mishra
postwick
Dheerendra_vishwakarma
Anil_G
chandreshsinh.jadeja
Gautham_Pattabiraman
vrdabberu
aravindbalineni123
More details...

How to distinct the excel

Related Topics