Sort numbers
Closed
babu
-
Sep 12, 2009 at 08:45 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Sep 12, 2009 at 09:16 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Sep 12, 2009 at 09:16 PM
Related:
- Sort numbers
- Chrome sort bookmarks alphabetically - Guide
- Spotify sort by genre - Guide
- Water sort puzzle free download - Download - Puzzle
- Google drive sort by name - Guide
- Reverse sort linux - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Sep 12, 2009 at 09:16 PM
Sep 12, 2009 at 09:16 PM
suppose the data is like this in A1 to B7
57 35
6 82
90 88
21 6
7 30
48 90
61 57
in C1 copy paste this formula
=IF(COUNTIF($B$1:$B$7,A1)>=1,A1,"")
hit enter key
copy C1 down.
see the numbers in column c
57 35
6 82
90 88
21 6
7 30
48 90
61 57
in C1 copy paste this formula
=IF(COUNTIF($B$1:$B$7,A1)>=1,A1,"")
hit enter key
copy C1 down.
see the numbers in column c
