I know it’s somewhere on Reddit. Helped me find a lot of great books. Thanks in advance.

Edit: Thank you for the rewards. Please give credit to the originating authors of that spreadsheet. I’ve been using it for the past 2 years to help me find my next books. Maybe an admin can pin this resource for everyone to use?

I created an excel spreadsheet that allows you to compare different student loan scenarios. It allows you to take 2 different loans, then manipulate the rate, extra payments per month, time to pay off, etc... After that it will show you the difference between accumulated interest, days between payoff dates, things along those lines.

I never found a calculator online that did this super well, and I hope it helps others. I am not a financial professional or a programmer so I would appreciate any feedback or double-checking.

https://docs.google.com/spreadsheets/d/1-bCpWsFx109qDdSooCSjbGLevaSnA_sy/edit?usp=sharing&ouid=118232343343620218287&rtpof=true&sd=true

While there are many tools that allow conversion of PDFs to Excel almost all of them stop working when the PDF uploaded is not an electronically generated PDF but one that contains image based content. To address this, we've created a PDF to Excel utility that works on any PDF type. We've done this by using AI based OCR that intelligently extracts the content using AI and ML techniques.

We've so far seen it work on every single PDF we've uploaded and would love the community to give it a spin and give feedback about the output. It can be used without any sign up or subscription. Please try it out here: https://nanonets.com/tools/pdf-to-excel and share your thoughts about all the useful automation you can do with it.

I have a large data pull that requires filtering by a list of five customer names and deleting their data. The way our customers are coded there can be more than one customer name (i.e. Google, goolge.com, google inc). With this in mind I would like to filter and delete these values in the data set. How would I go about this?

Thank you

Hi,

Explanation -

Sheet contains numbers column-wise. A number will be inserted in cell B2.

User will manually select multiple ranges (selection is highlighted in Red for reference)

Macro should highlight cells that has the number 2 including the cell to the left lin Yellow color.

Below is a snapshot of the final result -

https://preview.redd.it/ywp1k4mmtm881.png?width=332&format=png&auto=webp&s=ecc9b67464044ac9d23cf48484fed0934c0b68b0

Any assistance will be appreciated

Hi all. I am new to excel, and I am trying to create a formula to bulk edit cells in a specific column based on the text in another column.

I am trying to input the length and width of the stickers I make. There are five sizes for each sticker, extra small through extra large. I have different rows for each size of each respective sticker. Each individual size has the same respective measurements, i.e. all smalls are 2 in x 1.25 in, all mediums are 3 in x 1.75 in, etc. Is there any way to change all the length entries based off the size columns? Like, for each small, I would like to change the length entry to 1.25 in, but I don’t want to go through and change every single one by hand. Is there a formula/function that can do that for me? If so, what is it because I can’t find an example online? Any help is appreciated! Thanks!

As the title suggest, I have in column A a sequence formula which writes numbers from 1 to n, where the value of n is taken from another sheet and is specified by user. Now in the adjacent column I want excel to find, for example, the various powers of 2 till the number specified by user. Can I do so without applying the formula to 100s of cells in advance? Can it be automated such that if the user enters 15 in the other sheet, I can get here 2, 4, 8, 16, 32, ...., 32,768 in a single column?

Thanks in advance

Recently bought a second hand surface pro 7. The price was only £350 (including the type cover) so the price was too good to pass on.

However I’ve only now realised there’s 4GB of ram.. I’ll be using it for practising financial modelling for work prep (I work in finance) - am I basically screwed with a ram size this small?

I won’t be working with huge datasets or anything, rather it’ll be my own personal device for putting together financial models.

Any help greatly appreciated!

Hello everyone!,

Imagine that you have the following data:

https://preview.redd.it/7y6qoj88bw681.png?width=285&format=png&auto=webp&s=e668f43315012459926f6344b5fe3407c21a7a30

on cell (C2) i wanted to find the first id and his price for example b2-b1, b3-b1, b4-b4,b5-b4 and so on...

thank you for your time.

I wanna recommend a few of the bangers (first Tucker drinking ep, first Arian Foster) Saw it earlier today and can’t seem to find it again.

Big ups, pimp.

Hello everyone!, I'm currently working on big database and i'm a little comfused...does any of you know how to create unique values based on given data? for example....

https://preview.redd.it/ti15t1k4f9781.png?width=135&format=png&auto=webp&s=d341ec1d4960edbc406dd35be9092a78d90041b8

Let's say the column A is the brand, Column B the type of product or PartNumber, and column C is the size, how can i create numeric data like the formula " =COUNTIF($A$2:$A2,A2)"?, the small size is smaller than Large size...so i cannot sort by alphabetical order, does any of you have any ideas how to get the following results?

https://preview.redd.it/qwruf0ilf9781.png?width=198&format=png&auto=webp&s=6653875b72a80392efb309ea103e98397e6da6f0

thank you very much for your time...

I am trying to set up a digital tracking board for outdates that will be displayed on a monitor. What I want is for excel to change the background of a cell or row to red when the expiration is 7 days away. can excel do this? I was thinking no because I don't think excel refreshes until you close and reopen the file and this will be a file that is always open. Is there another program I should use? TIA

update: I appreciate everyone's input however I could not make any of the solutions work so I used the prebuilt functions in excel. Thank you for your help

I’d like to send an email based on a cell in a row returning “Alert” but I don’t see any solid tutorials for this. They all seem to involve other goals that complicate the process. I cannot use 3rd party actions. This is how it goes so far:

Get email>save attachment on SharePoint>get a row(stuck here)>send email to XYZ based on row

I cannot get my table to show up in SharePoint so I need to troubleshot that. Does anyone have a good resource that explains the Excel flow portion of this?

Thanks!

I want to be able to type the name of an analyte in one cell and have it auto fill another cell with the price. For example, if I type “phenol” in one cell, I want a cell in the same row to automatically fill in with the price of $25. How do I go about this? TIA!

Hey - so I'm working on a project where I take a large summary file with different tabs of sales data and need to make individual sheets for specific sales reps.

So far I've written some code that lets me split the source data off into separate tabs based on a rep's name and saves each as their own individual file.

How can I go about combining these composite files into one file for each rep, where each is on its own tab and the whole thing renamed and spit out into a new folder?

The files all start with the person's name (e.g. "John Smith October 2021 Summary.xlxs", "John Smith October 2021 RAW DATA.xlxs", "John Smith October 2021 Bonus Payout.xlxs", etc.

I was modifying some code I found on stack exchange, which requires a custom class method and enabling microsoft scripting runtime, but it's pretty touchy and I'm having issues with the delimiter and random errors I can't figure out.

I feel like this isn't the most simple or elegant way to combine files that will all start with the same criteria, and I'm wasting time trying to finagle this script.

Any advice would be greatly appreciated!

I have an exam at 6pm ( GMT-6) within 3 hours . Exam is fully on excel file . It’s a 2nd year economic course. I will email the question excel file. You have to finish minimum 15 minutes before the exam end time. I will pay $100 on PayPal ( CAD) . Can someone help me ?

Hello, I’m stuck with a problem which isn’t that complicated - i guess. I want to compare numbers on a date basis and color them differently. So until now i‘m this far: Amount of cash/365*-(Day(Date1;Date2))

Now i want to add a If-Function which tells me 3 different things: if the cell is +- 10% no color, if the cell is 10-25% orange and if the cell is above 25% it should be red.

How is this makeable? Should i do this in another way?

I hope the question is not that stupid.

My roommate and I are addicted 2k. We've played 218 games in the last 2 and a half months, and we cannot stop. We play so much 2k21 that we started keeping a running total in our heads of "best of 7" series wins (Blacktop 4v4). When one of us would win a best of 7 (firsts to 4 wins), we would count that as "1". The next best of 7 series win would count as another one, and we would add up these best of 7 series wins until one of us would win 4 best of 7s, which would amount to 1 "best of 7,best of 7" (first to 4 best of 7 series wins). We already have our first best of 7, best of 7, best of 7 in the books, which was comprised of 158 games of 2k.

Scorekeeping became increasingly difficult as there aren't enough neurons in the brain to handle this bizarre system. So, we started an Excel spreadsheet to track this senseless tournament, and with it, interesting data that we can pointlessly reflect on. For example, we track our Game 1, 2, 3, 4, 5, 6, and 7 win/loss percentages. For example, I've won 21 out of 38 of all game 3's we've played (55%) whereas he's won the other 17 (45%). There's something so fascinating about obsolete statistics that bare little to no weight or significance in the grand scheme of things. But at least I know that, out of the 38 best of 7 series that we've played, I've been down 3-2 fifteen times (39%), and out of those, I've forced a game 7 eight times (53%), and out of those, I have won three (37.5%).

If anyone has any ideas on additional data that could be collected from this, or if someone knows of a self-help hotline to save us from this insanity, please advise.

Teams

Current LA Lebron, Classic '12-'13 Pacers Paul George, All-Time Hornets' Chris Paul, All-Time Rockets' Hakeem

vs.

Current Phily Embiid, Classic '18-'19 Kawhi, All-Time Kings' Oscar Robertson, All-Time Bulls' Jordan

https://preview.redd.it/s78u053hma081.png?width=1968&format=png&auto=webp&s=91fe5a57b777e9361b20db72a2018c77c8c316a7

https://preview.redd.it/ewj1j63hma081.png?width=2460&format=png&auto=webp&s=9a3597aedddc482f9afc059f52d1af76391e8562

Hi,

I have a large database in excel, which contains metadata for contracts. The first row of this excel is the name of the metadata/field. For example, column A = contract number, Column B = supplier, Column C = agreement date, etc. All the rows under row 1 are data entries.

I need to split this excel file up in multiple smaller subsets, based on the contract type. Contract type is defined in column D. On top of that, each contract type subset has their own specific requirements of which fields it should pull in. For example, for a confidentiality agreement, the subset needs to have contract ID, supplier name etc, but it shouldn't need the field payment terms. A different contract type, for example a statement of work, might need to pull in the payment terms, but it might have other fields that it doesn't need. I have a breakdown of the required fields for each contract type.

I've done this in the past by creating 1 new excel file for each contract type and then using an Index,match,match formula, to pull in the right data. It takes me a long time and it's prone to errors as I need to manually copy/edit 30-100 formula's per sheet.

I was wondering if there's a more efficient/faster way of doing this (powerquery perhaps? I don't know anything about that tho). I feel like this is something that could be automated, but I don't have the right knowledge currently to do this. Ideally I'd like something that once it's set up, I can just select what contract type I want and that then spits out the subset with the right fields.

Thanks!

Tool download link

안녕하세요 r/Korean,

I am a native Korean speaker who works in IT developing tools in Python and Excel, who also happens to love learning languages.

I am a huge user of Anki, and I have used it religiously to learn languages. And as told in Gabriel Wyner's excellent book, Fluent Forever, I believe it's most effective to not use translations, but rather images and sounds to memorize words. This means that when creating your Anki flashcards, you should include:

1. Pictures, and not translations of the words
2. Recordings of the words

As a bonus, when searching for the images in your deck, you should search for the word in the target language, in a website where the word is used within its native cultural context. For example, searching "apartment" on Google images vs. searching "아파트" on Naver images will net you vastly different results, as shown here. You can note any differences you see and get an idea of the cultural connotations behind the word (which is interesting in and of itself), and create another association to the word, maximizing retention of the vocabulary for yourself.

But you also need the word's exact definition so you can understand the possible definitions of the word, ideally in a monolingual dictionary. But if you are not at the level where monolingual dictionaries create more questions rather than give you answers, you also need to search an English definition and/or an English translation.

What this all means that for each Korean word, you have to search the following for each word to start even thinking about adding the word in your Anki deck:

1. A definition in a monolingual dictionary
2. An English definition
3. An English translation
4. Images of the word in Naver images
5. The sound recording of the word

Doing this manually for each word you want to learn can be a LOT of work for a frequency list of 500+ words, and it's easy to get discouraged and resort to simple translations. Which is where this multisearch tool comes in to save the day. Screenshot

With this tool, you can enter the Korean word you want to search, and then press the 'Run multisearch!' button or press Ctrl+Shift+S, and then the tool will pop up a browser with the search results of all of the above pre-populated. Now it's just a matter of goin

Hey, I'm new to Powerapps so I'm kind of struggling with the basics.

I created an app based on an excel. It's kind of an inventory. The idea is to have two separate browsegalleries, one shows items that are in storage, the other shows items that are not. So there's simply a column in excel that says "in" or "out", and Patch command would change the status with a press of a button. But right now I can't even filter the galleries.

Name of the table in excel: Table1

Name of the column: Storage

Cell: in or out

I feel like this should be basics of the basics, but nothing seems to work and none of the solutions I've googled have worked.

I guess I should just change the Visible from true to something like Table1.Storage = "in" or Table1.Storage.text = "in" or use the Filter function?

edit: used this in Gallery Items:

SortByColumns(Filter([@Table1];Storage="in";TextSearchBox1.Text in Viite || TextSearchBox1.Text in Koko);"Viite"; Descending)

which means I did both filtering and searching with the Filter command.

Hey all,

I'm trying to use excel to track the price of my YuGiOh card collection, so I need to query a value from a website, for price depending on the card number I input into a cell.

As an example, take this card. It's ungraded price is $13.45. The card code "SDP-001", is unique to every card of that name and rarity.

If I wanted to be able to enter into excel the card code for a specific card, how would I use excel to query the website, find the card, it's name, and price and put them into cells based on the entered unique card code?

Thanks!

Send me your links!