| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help: Data Loss, have prev. copy of sheet
Is there a way to get a column of numbers from one sheet to another, where
rows have changed order. I have compared sheets before to the same column, but need the data. examples have a =IF(OR(COUNTIF($AA$1:$AA$3000,AA99)=1,AA99={"","." ),"",COUNTIF($AA$1:$AA$3000,AA99)) =IF(OR(AA99={"","."}),"",IF(ISNA(VLOOKUP(AA99,[xsymbols.xls]symbols!$AA$1:$AA$3000,1,0)),"dif","")) Note: col AA is a unique symbol, looking for numbers in column DD, that line up with the same symbol, starting at line 99. Main sheet keeping: symbols.xls Backup: xsymbols.xls (if have the exclamation point "!" correct, etc... thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Help: Data Loss, have prev. copy of sheet
ps: xsymbols is in same directory, and the sheet name is also: symbols
"nastech" wrote: Is there a way to get a column of numbers from one sheet to another, where rows have changed order. I have compared sheets before to the same column, but need the data. examples have a =IF(OR(COUNTIF($AA$1:$AA$3000,AA99)=1,AA99={"","." ),"",COUNTIF($AA$1:$AA$3000,AA99)) =IF(OR(AA99={"","."}),"",IF(ISNA(VLOOKUP(AA99,[xsymbols.xls]symbols!$AA$1:$AA$3000,1,0)),"dif","")) Note: col AA is a unique symbol, looking for numbers in column DD, that line up with the same symbol, starting at line 99. Main sheet keeping: symbols.xls Backup: xsymbols.xls (if have the exclamation point "!" correct, etc... thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can i copy data from a tabbed working sheet to a summary sheet | Excel Discussion (Misc queries) | |||
| how to copy a cell with formula from sheet 1 (data is all vertical) into sheet 2 | Excel Worksheet Functions | |||
| DDE Logging Data Loss in Excel | Excel Discussion (Misc queries) | |||
| Weight loss line chart to monitor weight loss progress | Charts and Charting in Excel | |||
| Copy sheet 1 data to sheet 2 cells. | Excel Worksheet Functions | |||
Linear Mode
