Question about Microsoft Computers & Internet

2 Answers

I Have list of numbers in coloumn in a sheet & i want its uniqe record in another sheet how it to do?

Posted by on

  • sachinbankar Mar 12, 2009

    Thanks for your reply.but I had knew it.I just want to know is it have any formula.if yes please reply



2 Answers

  • Level 2:

    An expert who has achieved level 2 by getting 100 points


    An expert that got 5 achievements.


    An expert whose answer got voted for 20 times.


    An expert who has written 20 answers of more than 400 characters.

  • Expert
  • 50 Answers

Hello Schinbankar,

I am going to assume you are using MS Excel and you would like the unique values from one worksheet to be copied into a new worksheet.

1. Open your Excel file
2. Click "Data" in the menu
3. Select "Filter"
4. Select "Advanced Filter"
5. Select "Copy to another location"
6. Click the button at the end of the "list range" field
7. Select the cells from which you would like to extract the unique values
8. Leave "Criteria Range" blank
9. Click the button at the end of the "copy to" field
10. Select the cell where you would like your unique records to be copied to (example: cell A1 of sheet 2)
11. Check the box that says "Unique records only"
12. Click OK

Good Luck.
Thanks for using FixYa.

P.S.: If this information was helpful, please rate this solution.

Posted on Mar 11, 2009

  • Level 2:

    An expert who has achieved level 2 by getting 100 points


    An expert that got 5 achievements.


    An expert who has written 3 tips or uploaded 2 video tips.


    An expert whose answer got voted for 20 times.

  • Expert
  • 80 Answers

You can use some add in for Excell, can be found much of them on internet. Or follow this instruction: for any brainstorming :)

Posted on Mar 11, 2009

  • Adi Sunardy
    Adi Sunardy Mar 12, 2009

    You can find some formula here (using array)

    P.S.: If this information was helpful, please rate this solution.



1 Suggested Answer

  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

A 6ya expert can help you resolve that issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
The service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
Good luck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%


Complete. Click "Add" to insert your video. Add



Related Questions:

1 Answer

Can I change registration of of this kindle

go to settings then look for rest unit to factory default, it will of course wipe out all old info so you need to RE register the unit, but it will be like new, then you will be able to use You're uniqe Id follow all onscreen directions and record all Passwords somewhere safe. for any Problems You may have in the future. Good Luck

Jun 06, 2015 | Amazon Kindle 1

2 Answers


One way would be to create a colunn C and use the formula: =COUNTIF(B$2:B$200,A2) in cell C2. Then copy the formula down to C200. (assuming you have 200 entries in B...). This will put a "1" next to every number in Column A that has a match in column B. Then you could put a conditional formula in column A that will highlight the cell if the value in column C is equal to 1. Alternatively you could also simply filter for 1's in column C and then manually highlight the cells that show up in A!

Sep 16, 2014 | Microsoft Excel for PC

1 Answer

I changed my battery and the radio locked on me. how do i get to unlock my radio

Check in the owners manual the "unlock codes", sometimes 4 or 6 digits; if you doint have the manual and details about this, must to visit the dealer. Keep in mind that this code is uniqe for each vehicle and just with the VIN number the dealer could send you.

Hope this helps.

Feb 10, 2011 | Acura RL Cars & Trucks

1 Answer

Asking for code to sign in . on xbox360elite where do i fine the code

is the code for your account you made, have you forggotin it. if so just make a new account if it is asking you about parental you will have to call microsoft as if cause every code is uniqe to the serial number

Jan 01, 2010 | Microsoft Xbox 360 Elite Console

1 Answer

What type of cd-rs will a Toshiba sd-v296ku play? Do they have to be recorded in a specific format?

For whatever reason I can't find that exact model number listed anywhere (as far as a spec sheet or manual) but the only type of cds it could possibly play would be either:

Music CDs
VCDs (video cds)
or SVCDS (super video cd)

Only select dvd players will play the latter two, so make sure it is listed as being able to do that (most players will have logos / icons on the front of the player depicting what it will play).

Jun 30, 2009 | Televison & Video

1 Answer

How to seperate a number from a text string in microsoft excel?

highlite the cells you want. right click the mouse. go to format. select text in the first coloumn.
highlite the cells you want for the second column, right click the mouse and go to format and select number and no decimal.

Jan 28, 2009 | Computers & Internet

1 Answer

Need remote control for LG dvd/vcr recorder..misplaced code sheet

Code numbers of controllable TVs
If more than one code number is listed, try entering
them one at a time until you find the one that works
with your TV.
Manufacturer Code Number
LG / GoldStar 1 (Default), 2
Zenith 1, 3, 4
Samsung 6, 7
Sony 8, 9
Hitachi 4

Dec 28, 2008 | LG XBR342 DVD Recorder / VCR Combo

3 Answers

S510 Keyboard Problem, Keys Dont Work, Everything Else Works,Ect-Mute

I had the same the problem. The cause was a corrupted encryption code. That is why only worked the keys that don't require encryption.
1) Install the Logitech software and restart.
2) The software will tell you to press CTRL-ALT-F12. This procedure resets the keyboard encryption and tells you to enter a new code.
3) If you already had the software installed simply press CTRL-ALT-F12 and follow the above procedure.

Mar 15, 2008 | Logitech Cordless Desktop S 510

1 Answer

Problem in copiying

sorry but your description doesnt help and it is hard to understand what you want to do

Nov 17, 2007 | Microsoft Office Standard for PC

Not finding what you are looking for?
Computers & Internet Logo

Related Topics:

131 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2983 Answers

Piyal Perera
Piyal Perera

Level 3 Expert

528 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18424 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides