Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
DELETE DUPLICATE DATA IN A SHEET AUTOMATICALLY
Hi there
If somebody can help me with this. I have a sheet which contians volumes pertaining to companies on a monthly basis. My system gives me data per month. The columns in worksheet are Co Name, Volumes for Jan,Feb,March and so on. After completing data for the month of Jan, I copy volumes for Feb into the same sheet. The sheet already contains data for eg for ABC for Jan and for Feb that i hv copied just now in two diff columns and rows. I want to run a formula that will place my Feb figure for ABC in a column next to Jan w/out manually copying and pasting Feb figure into the column next to Jan. you hav to consider that I also have new co's every month whose data has to exist as it is. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
DELETE DUPLICATE DATA IN A SHEET AUTOMATICALLY
If your data sheet is called Data, and your summary sheet is called Summary. In the Data sheet you can check for new companies by a VLookup of the Summary sheet with (in row 2, headers in row 1) =IF(ISERROR(VLOOKUP(A2,Summary!A:A,1,FALSE)),"","n ew") and copy all new company names to the summary sheet. To add new data, in row 2 of the new monthy column (ie, column D for March) put =IF(ISERROR(VLOOKUP(A2,Data!A:D,4,FALSE)),"",VLOOK UP(A2,Data!A:D,4,FALSE)) and formula-drag that down to cover all companies. To 'fix' (make unchangeable) this data, select the column (D for March) and Copy, then Paste Special = Values back over itsself. You can then re-use your Data sheet. Hope this helps Sony Manoj Wrote: Hi there If somebody can help me with this. I have a sheet which contians volumes pertaining to companies on a monthly basis. My system gives me data per month. The columns in worksheet are Co Name, Volumes for Jan,Feb,March and so on. After completing data for the month of Jan, I copy volumes for Feb into the same sheet. The sheet already contains data for eg for ABC for Jan and for Feb that i hv copied just now in two diff columns and rows. I want to run a formula that will place my Feb figure for ABC in a column next to Jan w/out manually copying and pasting Feb figure into the column next to Jan. you hav to consider that I also have new co's every month whose data has to exist as it is. -- Bryan Hessey ------------------------------------------------------------------------ Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059 View this thread: http://www.excelforum.com/showthread...hreadid=486628 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using a relative SHEET reference for source data in a chart | Charts and Charting in Excel | |||
Automatically pasting worksheet data to new worksheet with formulas | Excel Worksheet Functions | |||
Printing data validation scenarios | Excel Worksheet Functions | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Function to automatically insert a new sheet as a result of data entry? | Excel Worksheet Functions |