I have a very basic question which I am not able to figure out the answer.
I have, on a regular basis, a VLook set up to look at a list of locations to return those particular locations user name. Sometimes I do not get to them daily, so on those days I am looking up multiple days worth of those Vlookups - I am wanting to come up with an additional step speed the process up returning the multiple day information. Example below of multiple day's info...
date 8/25 date 8/26
AL-PT01 167 AL-PT01 167
AR-0162 8756 AR-0162 8756
AR-0165 0385 AR-0165 0385
AR-PT01 5659 AR-PT01 5659
AZ-0213 0218 CA-0039 0433
CA-0042 0481 CA-0042 0481
what I currently have to do is then manually create this:
Loc # Loc Code Dates
AL-PT01 167 25, 26
AR-0162 9756 25.26
AR-0165 0385 25,26
AR-PT01 5659 25,26
AZ-0213 0218 25
CA-0039 0433 26
CA-0042 0481 25,26
Isn't there some way to do this with a formula?
Thank you for your help
I have, on a regular basis, a VLook set up to look at a list of locations to return those particular locations user name. Sometimes I do not get to them daily, so on those days I am looking up multiple days worth of those Vlookups - I am wanting to come up with an additional step speed the process up returning the multiple day information. Example below of multiple day's info...
date 8/25 date 8/26
AL-PT01 167 AL-PT01 167
AR-0162 8756 AR-0162 8756
AR-0165 0385 AR-0165 0385
AR-PT01 5659 AR-PT01 5659
AZ-0213 0218 CA-0039 0433
CA-0042 0481 CA-0042 0481
what I currently have to do is then manually create this:
Loc # Loc Code Dates
AL-PT01 167 25, 26
AR-0162 9756 25.26
AR-0165 0385 25,26
AR-PT01 5659 25,26
AZ-0213 0218 25
CA-0039 0433 26
CA-0042 0481 25,26
Isn't there some way to do this with a formula?
Thank you for your help