It should work ok, but you may be having problems adapting the
formulas to suit your actual layout over there
Here's a revised set-up which assumes your data and formulae in
"dataprior" are within rows 410 to 1000 (say)
So in sheet: dataprior,
your formulas are within H410:H1000, ie you have in H410:
=IF($A4100,IF(ISERROR(MATCH($B410,dataid,0)),"No Longer Here",""),"")
with H410 copied down to H1000
In a new sheet,
Put in A1:
=IF(dataprior!H410="","",IF(dataprior!H410="No Longer Here",ROW(),""))
Put in B1:
=IF(ROW(A1)COUNT(A:A),"",INDEX(dataprior!$A$410:$ A
$1000,SMALL(A:A,ROW())))
Select A1:B1, copy down to B691. Col B should return the required
results.
Adapt the above to suit your actual ranges.
Let me know here how it went for you
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
On Mar 8, 2:58 am, Steve wrote:
Perfect. Thanks so much. That's exactly what I was looking for. One small
problem though.
The A column references of dataprior! that I wanted bunched up at the top in
the B column of the new sheet are correctly showing the the data
corresponding to row 679 and row 744, but not row 413 and row 645. All 4 of
those rows should qualify for the bunching ( having that no longer here text)
. I checked the dragged formulas all the way down, and they appear to be ok.
Any thoughts ?
Thanks,