How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask The-PC-Guy Your Own Question

The-PC-Guy
The-PC-Guy, Computer Manager
Category: Microsoft Office
Satisfied Customers: 1305
Experience:  20 years experience providing remote computer support
62934938
Type Your Microsoft Office Question Here...
The-PC-Guy is online now
A new question is answered every 9 seconds

add a decimal point to each number

Resolved Question:

*********URGENT**********I want like to add a decimal point to each number (or letter-number) in a way that it is the decimal is in the second place, e.g. 100 to 10.0 and 010 to 01.0 Attached is the column in question. http://wikisend.com/download/410642/srgcd.xlsx

Submitted: 2 years ago.
Category: Microsoft Office
Expert:  The-PC-Guy replied 2 years ago.
My Name isXXXXX will be helping you today. If I provide good service, you may ask for The-PC-Guy in your question title for your future needs.

is the decimal always going to be in the same spot?
Customer: replied 2 years ago.


yes, always after the first two numerical digits

Expert:  The-PC-Guy replied 2 years ago.
so if the number is XXXXX the result should be 45.78 not 457.8?

and if its A10 it should be A10.0?, and A02020 should be A02.020?
Customer: replied 2 years ago.

problem has been resolved for now. thank you. will contact you if i need anything else....

Expert:  The-PC-Guy replied 2 years ago.
thanks for giving me the opportunity to assist you
Customer: replied 2 years ago.


actually, i do need a f/u here.....


how do i remove duplicates in a column while also removing the corresponding value in the next column (since they are for the same code)?

Expert:  The-PC-Guy replied 2 years ago.
the easiest way is to use sorting a filtering functions of excel.

to do this

1. frst click any cell in worksheet, then press "ctrl" and "a" at same time on keyboard to select all cells

2. then click the "data" tab

3. click "remove duplicates" in the banner that appears after clicking the tab

4. in the remove duplicates window, select only those column or columns that contain duplicates. (if you select too many columns it wont work and you will have to try it again with less columns)

5. click ok, you will see a message telling you how many duplicates have been removed. If you selected 1 column, in step 4 and have tried each one separately and you get a message saying no duplicates, then that means that all duplicates have been removed.


in the future to avoid any confusion or delayed reposes, you may want to work with a single expert for your Excel issues. I would be happy to help in that regard.

feel free to ask for me again in the future if I can be of any more assistance, http://www.justanswer.com/computer/expert-1expert-2rulethemall/
The-PC-Guy, Computer Manager
Category: Microsoft Office
Satisfied Customers: 1305
Experience: 20 years experience providing remote computer support
The-PC-Guy and 9 other Microsoft Office Specialists are ready to help you
Customer: replied 2 years ago.


You did understand what I meant. This might be my mistake. I know how to remove duplicates. However, i am trying to remove duplicates in one column and the corresponding value in another column. That being said, the other column does not have any duplicates.

Expert:  The-PC-Guy replied 2 years ago.
yes if you do what I said, but just select the column that contains the duplicates, lets say its column A in the remove duplicates window, it will remove duplicate column row plus all corresponding columns for that row.

By default all columns are selected in the remove duplicate window.

Does this clarify it?
The-PC-Guy, Computer Manager
Category: Microsoft Office
Satisfied Customers: 1305
Experience: 20 years experience providing remote computer support
The-PC-Guy and 9 other Microsoft Office Specialists are ready to help you
Customer: replied 2 years ago.

PLEASE ASAP!!!!!!!!!!!!
absolutely. however, how do i remove the first duplicate not the second?

Expert:  The-PC-Guy replied 2 years ago.
wow, that will be way more involved. That would require a macro, and that is way beyond what I do. I just try to give you the easiest solution.
Customer: replied 2 years ago.


So you don't know how to do?

Expert:  The-PC-Guy replied 2 years ago.
not that specifically, I only know about the built in excel functions
Customer: replied 2 years ago.

 


It might be easier than we think. the problem is that in column A there are duplicates, but column B there are no duplicates and i need the description in column B that corresponds to the duplicate in column A.

Expert:  The-PC-Guy replied 2 years ago.
i see you already opened up another question to work with another expert, so I won't work on this problem any more. Let me know about others though

JustAnswer in the News:

 
 
 
Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
JustAnswer.com...has seen a spike since October in legal questions from readers about layoffs, unemployment and severance.
Web sites like justanswer.com/legal
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.
 
 
 

What Customers are Saying:

 
 
 
  • My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed. One Happy Customer New York
< Last | Next >
  • My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed. One Happy Customer New York
  • Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C. Freshfield, Liverpool, UK
  • This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!! Alex Los Angeles, CA
  • Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult. GP Hesperia, CA
  • I couldn't be more satisfied! This is the site I will always come to when I need a second opinion. Justin Kernersville, NC
  • Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around. Esther Woodstock, NY
  • Thank you so much for taking your time and knowledge to support my concerns. Not only did you answer my questions, you even took it a step further with replying with more pertinent information I needed to know. Robin Elkton, Maryland
 
 
 

Meet The Experts:

 
 
 
  • jstinehelfer

    Information Systems Manager

    Satisfied Customers:

    36
    A+ Comptia Certified computer repair
< Last | Next >
  • http://ww2.justanswer.com/uploads/JS/jstinehelfer/2012-6-6_215146_Pictureofme1.64x64.png jstinehelfer's Avatar

    jstinehelfer

    Information Systems Manager

    Satisfied Customers:

    36
    A+ Comptia Certified computer repair
  • http://ww2.justanswer.com/uploads/JA/JasonJames122/2011-12-16_135647_jasonjamesheadshotweb.64x64.jpg JasonJames122's Avatar

    JasonJames122

    Computer Enthusiast

    Satisfied Customers:

    0
    I manage all information systems (network of Windows PC's and servers with Microsoft Office products) for a small business
  • http://ww2.justanswer.com/uploads/JE/jessmagz/2012-6-6_18129_jm.64x64.jpg Jess M.'s Avatar

    Jess M.

    Computer Support Specialist

    Satisfied Customers:

    301
    Computer Software Specialist for more than 10 years
  • http://ww2.justanswer.com/uploads/CH/chutz747/2011-11-6_14231_me.64x64.jpg The-PC-Guy's Avatar

    The-PC-Guy

    Computer Manager

    Satisfied Customers:

    274
    20 years experience providing remote computer support
  • http://ww2.justanswer.com/uploads/SP/spherrod/2012-6-6_174244_1000852.64x64.JPG Steve Herrod's Avatar

    Steve Herrod

    Computer Support Specialist

    Satisfied Customers:

    125
    Trained in Microsoft Office from 2000 through to latest version 2010.
  • http://ww2.justanswer.com/uploads/SE/Seashore2011/2011-12-6_33418_111205223015.64x64.jpg Chris L.'s Avatar

    Chris L.

    Support Specialist

    Satisfied Customers:

    124
    Certified Expert with over 10 years experience.
  • http://ww2.justanswer.com/uploads/KR/krkljatorm/2012-6-24_153417_ITMiro.64x64.jpg IT Miro's Avatar

    IT Miro

    Computer Scientist

    Satisfied Customers:

    97
    Bachelor's Degree in Information Technology, Microsoft Certified Professional