I have data spread across excel sheet with 1000 rows & 30 colomuns. I want to delete duplicate values row & colomun simultaneously Thanks Dipankar Malik

Hi everyone. I has a column of data full of: .123 .123 .65 .89 -- all in text format. Is it possible to have some equation to change those data to:

Hi all, vlookup, looks up a value and then place it somewhere else. I would like to know if there's a way to do the opposite. That is, if I find a value,...

My formula calculation appears in the cell rather than the result/value- why is this happening, and how can I stop this? Thanks

Hi all, I need a formula to do the following (I'm sure there is a very simple solution but it is just eluding me right now)... Let's say for example: I have a...

It was in Microsoft Excel on my file "MasterHuntData.xls"

I have made a chart in Excel. My boss told me to blackline, or track the changes, when she gave me a revised copy. I am able to track the changes but not print...

I want to copy my page setups from one worksheet to another within a workbook. When I copy and paste, all the worksheet stuff is there but not the page setups...

Can I expand the character limit in an Excel row? The column size is 101.4 and the row size is 138 and part of my text is still missing. Is there a remedy to...

I'd like to control the tab order of an Order Entry sheet I'm creating. Can I do this or would I have to recreate it as a form? Thanks

I need help. Is there aynone out there who can do some data tricks for me in Excel. I have a list of emails and associated account numbers. The problem is that...

"Angela33" wrote: How do you make a column automatically place items in alphabetical order? Also, how do you make a column automatically put dates in...

If any one can help with this query would be much apprieciated i'm very in need of it thanks; Simple example of what i need; on my work sheet i have a row...

I am altering REPLACE functions for different parts of my data. This works OK, but it would be more efficient if I could apply one function to all of my...

I'm experiencing a slight rounding error in comparing the Excel product of simple multiplication equations versus the product achieved using a calculator! ...

Hello, I've created excel worksheet that auto-populates certain cells with today's date to facilate filling out a purchase order worksheet. But problem is...

Hi Everyone! I'm using VLOOKUP to match last names. The problem i'm having is multiple people with the same name. VLOOKUP returns the fist match, what are...

I am using the following function in Master.xls =SUMIF(Source.xls!Colours,A1,Source.xls!Values) As long as both workbooks are open, it calculates...

I have two separate workbooks. In one workbook there is a code with no description. In the other, the code includes the description in the next column. My user...

Would someone have an example of how I would use vlookup to produce the outcome from the if statements that are listed below. I want to be able to check one...