![]() Step 1d: When it asks me, I’ll confirm that I want to remove the duplicates.Step 1c: I’ll go to the Data Ribbon and select Remove duplicates.Step 1a: I’ll copy the values from column A in all 3 sheets into a new workbook. ![]() Step 1: I want a consolidated list of products. I want a quick look at how much revenue I made, by product, over all 3 days. ![]() In this example, I have sales reports from 3 separate days. We were chatting about it and I realized the vlookup would solve her problem. Last week a co-worker needed to compare values on a report from two different dates. And I keeping finding more and more ways and reasons to use it. I recently discovered the value of vlookup in excel.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |