Compare and Result

T

Thor's Castle

Hi
Sorry if this seems misleading but i will try to make it straight forward. I
run a data warehourse serch using Discover 4i every day. The search is
identical but looks for additional data added to and area on a daily basis.
Eg A1 show 3 on Mon A15 (this is the same data to comapre but the export
from discovery copied below yesterday results) shows 7 on Tue this is done
over an array of cells.
I export the results from Discover 4i into Excel ithen run it the day after
and export into the same worksheet. I want Excel to look at todays data and
comapre it with yesterdays data and and say in F1 it shows a result of +4
the difference between A1 yesterday and today A15.
 
Top