Frustrated and tired,he reluctantly decides he’ll just create the list by hand.ĭoes this sound familiar? We’ve all been here at one point or another. One small change upsets the formula and returns errors. He tries modifying the formula, but it’s too advanced for him. It works! “Perfect,” Nathan excitedly thinks to himself, “now I’ll just copy that to the right…” and when he does, the formula breaks. After that he copies the formula down to create the list. Then he copy/pastes the formula in a cell and adjusts the ranges for his worksheet. He comes across a formula that looks pretty complicated, but others had claimed it worked for them, so Nathan decides to give it a whirl. However, after several failed attempts he decides to search the web to see how people create a unique list in Excel based on a specific condition. “Maybe I can use an IF() formula,” he thinks to himself and decides to give it a go. He needs to create a unique list of owners per car. Nathan is working on a spreadsheet that containsa list of car models and owners. Create a Unique List in Excel based on Criteria
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |