John_Smith123456
New Member
- Joined
- Nov 12, 2022
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
Please help looking up values/ cells
Hi!
I need some help please! I have a set of data with customers that has name in the 1st column, and the 2 different sales figures in a corroponding column. When i sort it, it list them on the rows- what I want to know is how to calculate the difference between to two figures, or plaace the two sales figures in different columns on the same row as the customer name.
So it looks like this now:
Customer Sales Period
AAA Customer 50
BBB Customer 70
AAA Customer 60
BBB Customer 30
Customer Sales Period
AAA Customer 50
AAA Customer 60
BBB Customer 70
BBB Customer 30
And I'd like it to look like this:
Customer Sales Period 1 Sales Period 2
AAA Customer 50 60
BBB Customer 30 70
Thanks so much!!
Last edited by a moderator: