Can anyone figure out how to make this two part formula? (preferably not VB) I believe all that needs to be used is INDEX, IF and/ or COUNTIF. Just can't figure it out.
A = Customer Number, B = Price 1, C = Price 2, D = Price 3, E1 = Price 4
PART 1
If A1 is equal to any cell within A2:A10, copy the adjacent cell (column B) into C1
(e.g.: if A3 is equal to A1, copy B3 into C1).
PART 2
If C1 is occupied, copy B3 into D1, if C2 is occupied, copy B3 into E1, etc.
OR
If you can fill C1, D1, E1 consecutively based on descending rows.
eg.: B3 copied to C1, B7 copied to D1, B10 copied to E1.
~Aeoneye
Bookmarks