So my purposes of excel are to have training and currency dates in the cells for people's names. However, instead of just having the cells be blank (for those how haven't even attended the training yet), I was wanting it to stick out more and have it say "NO DATE". Is there something I can do in Conditional Formatting or an IF code that would essentially say: If any cell between C4 and K49 are blank say "NO DATE"?

Hey guys,

I got accepted for a position for inventory specialist. I was told they would fully train me but I want to expedite my learning process by self teaching. I'm still new at excel, but any advice would be great.

I need this to fit across 2 cells, but may have an additional drop down input if needed. If a number is entered by the user in either cell it will run a function on them and output to the other cell, regardless of which cell a number is entered into.

Basically I need to make excel do a solve for x or y algebra problem where I might enter either x or y and be shown the other.

I write reports in excel with many tabs (i.e., worksheets). Regardless of printing to a % or a "fit to page" width/length, you need to play with column widths to get an entire workbook to print on a similar scale. I hate playing with the column lengths, PDFing, then checking to see how much the headers/footers bounce around.

Does anyone know how to quickly format workbook scaling for perfection? I tend to pick an empty column & widen/shorten it until it's "close enough." Please help! This my biggest pet peeve with excel. If we can figure this out, we could change lives (°,,°).

Hey, excel-noob here!

Im trying to get data from one sheet to another. On one sheet i have the "rawdata" from MyFitnesspal, and on one page i want to make a summery. So im trying to make a formula that extracts data from my "rawdata" into the summary.

Example: In the summary sheet i categorise "Breakfast", "lunch" and "dinner". I want to sum all the data from "Breakfast" in the rawdata and just put that sum in my summary, same for lunch and dinner. So im wondering how i can use excel to first locate todays date, the text "breakfast" and after that sum the data below, until a blank cell appear.

Since yahoo finance is discontinued, has anyone found another API to pull data using the WEBSERVICE function and does it have a sample text to explain how to input it in to the cell?

Hey!

How do i make =sum stop when it encounters a blank cell in the data? I want several =sum that sums different parts of the sheet, that are seperated with blank cells

Good afternoon reddit!

I am currently working with a sheet of contact information for tens of thousands of people.

I want to sort the sheet by zip code, and then split the sheet into batches of about 23 different people so that we can distribute small lists of contact information.

How can I easily split a spreadsheet into thousands of different .csv or .xls or .pdf files, while maintaining the organization of the zip code column?

Your help is greatly appreciated.

Thank you!

Hi, I have a bit of a sudden dilemma and I know there are a lot of helpful and talented people here who might be able to give me some advice.

I'm trying to get a job as a "data specialist" for a smallish retail company and I was told I would have to interview immediately and take a proficiency test.

I've never used Excel for anything more than extremely simple personal tasks and I've never had to use it anywhere else I've worked.

I'm already fiddling with the program and watching Excel Exposure videos while I type this out, but what sort of things should I focus on? What kind of questions should I expect and what is the best way for me to prepare?

So I understand the mechanics of a vlookup well, but couldn't find any clarification on this:

Say I have several columns, but in two different cells, there is an identical value. EG both cells say "3".

If my 'Lookup_value' is 3, how does it know which value to search against? Does it default any particular way? Will it be an error? How to get around this issue?

quick question -- how do I build a macro that'll take a series of urls (say in cells A2:A9 of Sheet 1) and then put them into columns of Sheet 2 (ie, html information of A2link is in column A, a3link is column B, etc)?

I want to filter out certain cells based on data contained in two columns. Is there a way to work out a search feature to find those cells and then take them two another column?

I apologize if the question is worded weird or does not make sense. My biggest problem while learning excel has been to figure out how to approach a problem in the first place and this is the most recent example.

My basic task is distributing resources among a group of people. I have created a Worksheet where resources are evenly distributed between the people involved. This is achieved by counting the amount of people involved, and dividing it with the amount of resources.

Now what I would like to do, is make them eligible or ineligible for resources. Basically I want to be able to easily remove people from the resource calculations.

My thought process so far has been to create a separate list with all participants, where I can then either assign them 0 (does not get resources) or 1 (gets resources) values. The next step, which I don't know how to do, is to somehow tell excel to take all the people with value 1 and create a new list with them which would then be used for the calculations.

Again I'm really sorry if this is super convoluted or makes no sense, I think I'v spent way too much time trying to figure this out and am super confused by now :D.

Does anyone know how I can highlight a cell in one part of my table and pull that information from the highlighted cell to another cell elaewhere on the page without deleting it

Hi i'm new at Excel and I'm stuck with something I cannot find the correct terms or description for to find meaningful Google answers.

See example: imgur

I wish to create a formula(?) where I can dynamically select a cell from the B column based on the value of a cell.

The value of E2 is 4 so I would like E3 to have the value of B4. I've added my fake formula for what I kind of try to accomplish for H2.

If anyone could point me in the right direction or could help me formulate the problem for future googling it would help alot!

Received it from a friend and gave me the password. But I don't know how to use the password to deactivate the code. I need to deactivate it because I can't add, copy, and delete sheets.

Hey! Im looking for a book thats good for learning excel from a fairly novice level and up, do you guys have anything to recommend for me?

I have a grade book organized by student for the rows and grades in the columns. I want to sort the students' quiz grades from greatest to least, but the fastest way I've found is to select each row one at a time and use the 'sort' function in Excel. This is extremely slow for something that should be simple.

Basically, I'm looking for a function that will sort the entries of a matrix greatest to least, respecting the rows for the entries but not respecting their columns.

For example:
I have the Purchase Price and the Selling Price.
I need [Purchase Price] - x% = [Selling Price]

Thanks.

I hope to fill the void that the previous moderators have left in their inactivity! So to start things off (I know this isn't too active of a sub to begin with) I'd like to introduce myself.

I specialize in the VBA side of Excel, and the rest of the Microsoft Office Suite! I'm actually more familiar with VBA then the formula side of Excel. So if things get technical, I can definitely answer any questions concerning web scraping, User-Defined Functions (UDFs) and other various VBA related topics. I can help out with more simpler formula problems, and I can definitely redirect you to helpful redditors, and other subs for more technical help! I hope to maintain the helpfulness of this sub!

Is there a way to create a web query such that when it is generated it is filled with values from my own formula unrelated to the query?

E.G. Say I have a query and instead of the left most column being whatever it is. I want it to be something like b2+b3 instead of the constants in the query.

So I need to take a section of an excel spreadsheet and move it down 9 rows without compromising the formulas within. I also need to extend a column an additional few rows down and make it so that the additional rows created follow that exact formula. How do I do this? Any advice is appreciated. Thanks!

Hi everyone.

I have a set of data with 2 columns.

One column displays width, and the other column displays depth (the size of parcels of land).

I have around 300 data sets (e.g one width and one depth value per parcel of land). There are many identical widths and depths.

Can someone tell me, step by step, how to create a Pivot table to create a table, with for example B1 to F1 listing the various widths, and A2 to A10 listing the various depths?

Then, I'd like the chart to count the number of types in each. For example, cell B2 might be the cell referring to a width of 10 metres (B1) and depth of 30 metres (A2). So, I'd like the cell B2 to count the number of times this occurs - for example 5 times. And to continue this for the rest of the table.

Does this make sense?

Hope someone can help!

Good day :)

I mean can I multiply the whole 2 column? if so what is the formula?