performing subtraction after finding values for item from two "unsorted tables" on a sheet
Excel-2010 comparing unsorted tables of stocks and performing subtraction operations for like st.PNG Excel-2010 sheet Comparing unsorted vectors for like entries (stock names) in two tables and performing a subtraction using the values three columns to the right in both tables when a match is made between tables.
I want to search for the contents of the cell name 4 columns directly to the right in the vector 4 cells to its right. Both vectors boundaries are defined by the first blank field above and below.
Then I want to subtract "%to T" the value three cells to the right of result cell by the value of the cell value three cells to the right of original (search for) cell
Last edited by Comparator; 01-29-2014 at 04:56 PM.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
By amartino44 in forum Excel General
Last Post: 07-12-2017, 05:32 PM
By Linklog in forum Excel Programming / VBA / Macros
Last Post: 09-30-2013, 04:10 PM
By jhren in forum Excel General
Last Post: 06-06-2013, 06:28 PM
By DanBraden in forum Excel General
Last Post: 02-16-2011, 02:55 PM
By joseedua in forum Excel General
Last Post: 02-11-2010, 01:09 PM
Tags for this Thread
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1