|
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 |
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 |
| All times are GMT +1. The time now is 04:42 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com