J
JMax
Good Morning,
I have a file with over 6,900 rows that originated out of Fox Pro. Th
issue is that the unique identifier (Store #) is in a row above th
data and the part numbers are in row(s) below the Store #. The amoun
of parts differs for each store.
Example
Row 2- Store 17
Row 3 and 4 contain the parts Store 17 used.
Row 5- Store 6001
Row 6,7, & 8 contain the parts Store 6001 used.
Basically I want to add the store number to a column that correspond
with the part numbers used. In inserted 2 columns (A&B) in A1 there i
the text “Store #”
In B3 I have a simple if statement =IF(C2=$A$1,D2,"")
In C2 is “Store #” and in D2 is the actual Store #. Now this formul
returned what I needed for the first part number for each store. Bu
how can I modify it to return a store number for each part?
I know this is confusing.
Thanks,
JMa
I have a file with over 6,900 rows that originated out of Fox Pro. Th
issue is that the unique identifier (Store #) is in a row above th
data and the part numbers are in row(s) below the Store #. The amoun
of parts differs for each store.
Example
Row 2- Store 17
Row 3 and 4 contain the parts Store 17 used.
Row 5- Store 6001
Row 6,7, & 8 contain the parts Store 6001 used.
Basically I want to add the store number to a column that correspond
with the part numbers used. In inserted 2 columns (A&B) in A1 there i
the text “Store #”
In B3 I have a simple if statement =IF(C2=$A$1,D2,"")
In C2 is “Store #” and in D2 is the actual Store #. Now this formul
returned what I needed for the first part number for each store. Bu
how can I modify it to return a store number for each part?
I know this is confusing.
Thanks,
JMa