Track price changes with tagr12/6/2023 ![]() ![]() Even then, it gets fairly complicated when you work with a good amount of data. I've been playing with MATCH(), XLOOKUP(), SUMIF() and I must say that I'm running out of my creative juices. Productįrom this table we see that "A-2" is increasing by $10 in October, "B-1" is either discontinued or I simply didn't file the rate with the federal commission (oops), and that a new product "C-1" is introduced in October for this client as per my quotation. Below is a simplified example of a spreadsheet where unique identifiers are product and its category. By the time I work one contract I realize that there are probably a hundred new messages and another 149 contracts to work on. Unfortunately, this process is not automated and I am responsible for making these updates as well as keeping track of these changes as I said earlier. The problem is that I have numerous contracts with rate spreadsheets being as long as 10000 rows with 30 columns each where prices are constantly updated. Hello, I work for a sales department and every month I need to add, renew, remove the prices for different products and update our customers on any changes. They are identifiable with a special user flair.Ī community since MaAsking a question? Describe if you are using Excel (include version and operating system!), Google Sheets, or another spreadsheet application. Occasionally Microsoft developers will post or comment. Recent ClippyPoint Milestones !Ĭongratulations and thank you to these contributors Date Include a screenshot, use the tableit website, or use the ExcelToReddit converter (courtesy of u/tirlibibi17) to present your data. NOTE: For VBA, you can select code in your VBA window, press Tab, then copy and paste that into your post or comment. To keep Reddit from mangling your formulas and other code, display it using inline-code or put it in a code-block This will award the user a ClippyPoint and change the post's flair to solved. OPs can (and should) reply to any solutions with: Solution Verified Only text posts are accepted you can have images in Text posts.Use the appropriate flair for non-questions.Post titles must be specific to your problem. ![]() Happy to share a little video of it or something if it helps. The patterns of sales are pretty regular, so knowing when to check off-season sales helps too. I don't know of any good universal cart apps, but this is basically how I use it. It's reallllly powerful to separate the "hunting for interesting things I like" from the "making a shopping decision." I keep a visual wishlist of items and inside each one I can track price, URLs, various options (e.g., I want a black wide-leg jumpsuit, here's what I like, here are some options to comparison shop, here are 3 outfits I can make, etc.) My Notion is where I actually plan-refer to my shopping criteria, check my budget, see how it fits into my wardrobe in general. It doesn't track items and monitor price fluctuations automatically, but it does give me a place to keep track of what I want, without going from website to website, so it's all in one place. ![]() I posted this over on another thread, but I use Notion for this. Hair, Makeup, Skincare, Fitness, and Fragrance Interested in the Ethics and Sustainability of Fashion?.FFA Inspo Album Collection courtesy of /u/heyzk.How to Give and Receive Constructive Criticism.What to Wear to a Wedding That's Not Your Own.Business Dress: What to Wear to Work and Interviews.Dressing Like A Teacher: Some Considerations.Dressing for Two: A Guide to Maternity Wear.An Introduction to Personal Color Analysis (aka "What Season Am I?").Uploading photos to Imgur? To make your image viewable to anyone with the link, but prevent it from being added to the main Imgur feed, select "hidden" for the privacy setting, not "private" or "public". See details and apply here guides and how-tos ![]()
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |