I have a list in excel. Items can have several bids on them (the item number is unique, but appears as many times as there are bids on it). I need to extract from the data,
for each unique item number that has a bid 1 and a bid 2, copy the row of data for each bid and extract to another report. Then subtract bid 2 from bid 1, which will give you the $$ left on the table.
I'll end up with only those item #s that have 2 bids on them and the data associated with them and the $$ left on the table.
Help???!!
for each unique item number that has a bid 1 and a bid 2, copy the row of data for each bid and extract to another report. Then subtract bid 2 from bid 1, which will give you the $$ left on the table.
I'll end up with only those item #s that have 2 bids on them and the data associated with them and the $$ left on the table.
Help???!!