Please help!!
I'm having trouble developing concatenate formula that creates a unique identifier for each employee so I all have to do is paste the report in excel and my sales report vlookups will generate the data. My problem is I can't create a formula that accounts for the change in restaurant. I highlighted the cells with the restaurant change. Hopefully you guys can help.please help.xlsx
Do you want the change the formula in column B somehow? I don't understand what you mean by "change in restaurant."
It would be helpful if you gave an example in your file of what you want the result to look like.
Jeff
| | |·| |·| |·| |·| | |:| | |·| |·|
Read the rules
Use code tags to [code]enclose your code![/code]
please help.xlsx
I attached a how the sales report will look. If you look at the data there are some employees whose have sales for multiple restaurant locations, each restaurant location has a ID number, I was hoping on incorporating this into my current concatenate so I can only get sales for a employee by restaurant location. I was hoping on automating this process.
Please hlep me out
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks