formula for success
Because I am probably one of the only people who will visit this blogspace, I decided that I'm going to post things that interest ME.
On that note, I am including this Excel formula which takes one column of data from one spreadsheet and populates the data in another spreadsheet.
It is an amazing little trick that has saved me hours of mindless data entry and for those of you who can actually decipher the secret lingo in the parentheses, I commend you.
I work in an office and work with prices if this does not give it away.
=IF(ISNA(MATCH(cell,'Pricelist part # and drag,0))=TRUE,"",VLOOKUP(cell,'Pricelist Part number and cost and drag,2))
posted by Downhill Monkey @ Thursday, October 21, 2004
2 comments
2 Comments:
Hi Pochagrrl,
u aren't alone in this blog. Keep this blogging running, regardless the amount of visitors.
The most valuable thing of blogger isn't the "fame" you gained, but the unique "history" you recorded.
Happy Blogging!
Beyond Barrier, another fresh blogger
Oh man i can relate. I took an excel class at one job that was offering them to anyone who wanted and I learned stuff like this and it was freaky. I helped someone reformat data like this too and it was awesome. Of course she still didn't sleep with me but at least I made her day lol. She thanked me for weeks after. Sigh. Women.
Post a Comment
<< Home