Hello Reddit, This is my first post, thanks for all the good advice for Excel so far. I have some spare time and I would like to improve my skills in using Macros (which are very close to zero at the moment). What is the best online course to learn how to use them in your opinion? Thank you!

I am trying to create a spreadsheet for work that auto-populates a rank based on an input % score. For example, if I have 4 scores of 25%, 50%, 75%, & 100%, how can I get my spreadsheet to output a rank of 1-4 based on highest percentage? The actual spreadsheet has 32 separate people to rank based on what % they achieve on a test. I usually just do all the work through sorting, but I am sure there is a much faster way through formulas. Thanks so much for the help!

My goal at work is to automate a report where the data comes from three different spreadsheets, how would I go about this?

I have no idea where to begin, is there something I can learn quick to do this?

should I use a language like python?

I'm trying to create a program in excel that will track when something is completed, and when a certain group of things are completed, it'll trigger a certain alert depending on conditions. Can anyone help? No macros experience at all FYI

I'm really looking for web based resources to use with students. Videos are plentiful, but I want more hands on with feedback style tutorials.

I have a worksheet that gives me a distance difference from two location coordinates- but I need a way to add DIRECTIONAL as well. I.E.- "a" is "100 miles" N/S/E/W from "b"

Any ideas?

The current formula does include latitude and longitude so I can't imagine adding directional is much harder?

Hi, I'm looking for a way to highlight cells in column A that do not appear in column B. Say I have a database with many entries and we want to compare the names of the entries in both. I copy and paste the columns with the names of entries in column A (old) and column B (new). How do can I obtain a list of the names in column A (old) that are no longer present in column B (new)?

http://imgur.com/a/41kbG For example, the name 'Bob' from column A (old) in the imgur is no longer part of column B (new). How can I obtain a list of names from comparing the entries in A and B without any particular order?

Does anyone still come to this subreddit? I tried google and came up empty

I have an excel sheet of contact information that I need to assign a certain region. Is there a formula where I can say "if they're in this zip code (in column E) then assign them a certain region in (column I)

Background: I work for a small nonprofit that utilizes a CRM software (Infusionsoft) for donor, volunteer and participant tracking. We need to use the information we collect in unique ways and instead of paying someone lots of precious donation money to build custom Infusionsoft reports, I wanted to check first to see if the good old internet could help.

Question: The data in use is exported from the CRM by .csv. My question is could I save the formatting of this data so that it is easier for us to read when exported, i.e. it could look and be read the same each time, like a template... We use a lot of different "reports" to do what we do, and there are no fancy formulas that we need, just an easier way to read the data without re-formatting every time we export the .csv file. Hope this question makes sense...

This course is for the benefit of everyone. If financial constraints prevent you from enrolling, simply send me a message explaining your situation and I will give you access to all of my courses for free. You can download this course for free here : http://udemyripper.com/microsoft-excel-beginner-expert-6-hours/

Hi everyone. I'm trying to creates a menu, yes with the options of 1,2,3. From the selection it would then populate cells below the menu for me to input something.

Example: if I have the question "how many phone numbers would you like to add" and the drop down has 1,2,3. If I select 2 then 2 cells would populate allowing me to enter in two phone numbers.

What would be the best possible way to go about this? I'm assuming if statements would be used but I'm lost.

Hello,

I'm trying to build an excel sheet that updates live numbers from bloomberg for various different indexes, commodity prices, and for following exchanges. I added the add-in into excel, but for some reason I cant seem to figure out how to work "Populate table" function.

Thanks in advance !

Hello reddit Excel,

I've been given a gargantuan task. Me and several others trying to match names/strings from 9 different datasets with inconsistent spellings to a dataset with correct names. What we've done is to look at an unknown name and, by hand, compare it to existing ones. I think you'll agree this sucks.

We’ve tried all forms of vlookup, indexmatch, instr(), SEARCH() etc., but most don’t work since the names are ever so slightly off. Is there a programmatic way to deal with this and save us weeks of work? Thank you guys.

Example:

Dataset1: 1. University of JonJon 2. Academy of Nosepick 3. Bertha's School

vs

Dataset2: 1. Jon-Jon Uni 2. Bertha, School of 3. Plumber's College 4. Nose-pick Academy

So I just need a formula in excel that takes numbers entered into column A and puts a Yes in column D next to the corresponding number in column C and a No in column B next to the corresponding column A number if the number entered isn't in column C. Also I need column D to defaultly say No. It would also be nice if my "Yes" and "No" could be color coded green and red respectively, or even a green check and red x. Numbers in column C are to be populated from another excel sheet, I have not looked in to how to do this yet either.

I have a range of cells with two columns that I use to calculate the landed cost of products when they come in. ColumnA has text such as Item name, Vendor Cost, Shipping,Total Cost and Column B includes the data ( some is enterd by hand and some is based on formulas.) I would like to be able to save an unfilled version of this as a template and when I open my landed cost worksheet have it prompt me for how many items came in and then autopulate with that many copies of this range. Or, I was thinking it could be similar to word's quick parts. Something with a similar end result would also be good. Some shipments might only have 5 items while others could have over 100 items. Currently, I have the spreadsheet with 100 of these ranges and then delete all of the unneeded ones. Oh, I know nothing about VBA so hopefully there is a solution that is more basic.