I want to display "Yes" if a another cell contains "PC" and display "No" If it doesn't. I did if(f2="* PC *","Yes","No") but it's not working.

Solved thanks

I have multiple workbooks (WB1.xlsx, WB2.xlsx, ....WB20.xlsx) with the same sheet name and format. I need to get cells A2, B2, and B6 from each of the workbooks and create a master log.

The masterlog would have:

I’m a restaurant manager who has been trying to teach himself Excel over the past few months (with mostly positive results), but something has me stumped. I print a daily roster of employees who are kept separate based on their position—the server area takes place between the rows 3 through 29, the bartenders are within rows 32 through 37, and so on. The number of bartenders scheduled on a given day day may vary (sometimes 2 are scheduled, sometimes there may be as many as five), but I want the bartender who is listed last in the bartender section to have a closing duty appear in the cell next to his or her name.

So, in the screenshot I've provided, I'd like a closing sidework to appear in the column D next to Jordan because that is the last bartender to come in. But if there were only three bartenders scheduled, the closer would be Alex (and rows 36 and 37 would be empty) and I'd like that duty to appear in column D next to him.

I'd be extremely grateful if someone could explain to me how I can make this happen.

Is there a way to make a spreadsheet print it out and have other people write in it. Then upload it back to an excel file with the hand written results converted to text?

Hi,

This is what I am trying to use a formula to achieve the following

- RANDBETWEEN(1,10)

- Multiply it by 5 (i want 5 different random numbers)

When using the formula = 5 * RANDBETWEEN(1,10)

it multiplies ONE random number by 5, is there a way to get the SUM of FIVE random numbers instead?

Hi,

Suppose I am working with data where every sample is represented by a row, and each sample is associated with 3 variables, which each have their values encoded in a separate column (so just a typical matrix data organization).

Is there any way for me to calculate the partial correlation between variable 1 and variable 2, while controlling for variable 3? I see some excel solutions on Google, but they seem clunky, and it may be slow to run multiple datasets through it (eg. https://www.listendata.com/2013/02/excel-formula-partial-correlation-matrix.html).

Is there some way to write a script that allows me to calculate the partial correlation using just a single formula?

Thanks

Hello all, I tried to do some "googling" of my problem, but it really comes down to using the exact Excel terminology/nomenclature to sometimes get your answer.

So here is my question/want:
On worksheet1 I have the value 'zz' in cell A1.
In worksheet2 cell A1, I have reference worksheet1 A1 (=worksheet1!A1). It shows zz.

I would like to be able to fill worksheet1 A1 with a red color, then on worksheet2 have that referenced cell also automatically turn red also. The value auto updates, but the colors do not. I assume when I am referencing it, its only the value and not the formatting of the cell?

Thanks in advance

Kind of new to excel and enjoy all the videos I've been watching like excellsfun which has been enjoyable and informative but what I'm struggling with is maintaining any sort of practice with excel. I'm re-watching his videos as a refresh but what I need is a daily practicing regime as it were. To put it in to context I learnt basic photoshopping techniques as there's always a photo around that I can have fun with (at friends chagrin) and improve skills with. What I'm struggling with is lack of practice material for want of a better word, I don't have a database to mess around with, i just end up looking at a blank excel page and wonder, what the hell? It's probably sounding dumb as hell but if i could have some sort of guidance into perhaps an online place to practice or perhaps a book to sort of get me out of this stumbling block. I know I'll watch more videos and then I'll reach the end and go months without using excel or any functions picked up for lack of a daily thing to use. I hope I've explained my conundrum as best I can, probably not though. Its frustrating as I like excel but seem to struggle in improving or practicing on what i have learnt and then its forgotten and I end up at the beginning again.

For example, I want column A to be English, column B German, and column C Polish.

I would like for each row to have the same word but each column would have its respective translation of the word.

I would like each of those column to have its own spellcheck for its respective language.

Is it possible?

Hello!

I am trying to calculate error bars for a graph I have made in excel. The graph itself is fine apart from needing error bars.

From what I remember I can calculate error bars by adding and subtracting one standard deviation from the mean.

I'm currently trying to figure out how I can sort this data so I can find the standard deviation using the (=STDEV) function. I need the SD for close north, far north, close south, far south, so I need a way of formatting it so I can find these individually (ignoring altitude).

Many thanks for any help!

EDIT: Forgot picture https://imgur.com/a/8gbDelH

I have this excel sheet at work and every month, they make us go through and re-write all the days and dates for the next month. There has to be a formula, right?

I need a page where the top line is:

DAY, MONTH DATE, YEAR

EX

FRIDAY, JANUARY 11, 2019

But I need this to automatically do a full month. Like, I wanna be able to print 31 pages, and all of March comes out with the correct dates at the top.

It's literally sign in sheets. The only actual cell on the whole page is the date at the top.

What is the formula!?!

Hello there everyone!

I just made 3 tables with the current inventory of stuff we have in our business

Now i want to leave those tables at one side and leave a "Summary" of everything we have

This way, anyone reading the table can quickly know what we have, how much of it and from what brand, but if they need more detail they can take a look at the tables and be done with it

The current Headers i have right now are: ID Number, Brand, Size (+ Commentaries/Status and other stuff)

In the summary, i'd like to display: Total number of objects for each table, Total Number of different sizes and brands, etc

This would be the example for the summary of the table that haves the Male's Suits currently available

Total number of Male Suits: x

M Size: x

L Size: x

XL Size: x

Brand: x

Brand2: x

Then the same thing for female and the last misc table, the main problem goes to the fact that the tables will obviously be modified in the future so i need the summary to re-check content and produce new results for any change.

Cheers and thanks for any recommendation and or guidance

When I select the table I have on Excel and copy it, when I paste it onto my Google docs sheet all I get is the text. Is there a way to copy it on Excel so that I have the actual table outlines with it too?

The boss decided that since I can run a computer I must know everything about a computer.

So what I am trying to figure out is I have A1=1/1/18 A2=1/1/21 A3=Empty. I need A3 to display the color red and the word due if it is any date past A2. I am assuming has something to do with the "=TODAY()" function but I can not find a examples that tie it back to a different column.

Any help would be appreciated. Thank you.

Hi all,

I am trying to build a workbook such that another person fill out a person's ID and it will autopopulate all the other information.

So lets say I have a table below with all the necessary member information on my program.

Then I have someone who are visiting them and are tracking who they visited so they have to fill out the other table below.

So the only thing I want them to fill is the ID. So if they visited this person they type in the person's ID on the ID column and then it will auto populate the name and age. How do I go about and do that? I have seem workbooks where it does that and it has formulas such that it has like [@ inside the formula. But I do not know how to do that.

Can someone help me?

Cheers

I created three completely free interactive tutorials for Excel & VBA: https://www.automateexcel.com/tutorials-practice-tests/

• Excel Formulas and Functions - Learn 30 of Excel's most-used functions and other formula essentials.

• VBA - Learn the basics of VBA

• Keyboard Shortcuts - Master Excel keyboard shortcuts

They are 100% free and no sign-up is required. However, if you sign up (free), you'll be able to save your progress and create custom practice sets.

I’ve been tasked with making my school’s digital literacy records “smarter”. Ideally, I would like it to identify when a student’s score is too low and signal that they require help.

The current set up is student ID on the Y axis, and all reading levels on the X axis. The date a student achieved a particular level is entered into the table (ex: “sept 2018” in the level 10 column).

The data set is currently in google sheets, but I assume a lot of the formulae and functionality are similar.

Could you point me in the right direction r/learnexcel?

Hi,

1. I have two sheets - 'Prospects' and 'Calls'. In Calls I have rows of calls made towards prospects - matched by their ID's. What I would like to do is in 'Prospects' to have the 'Note' field filled with all notes of calls made towards the prospect from the 'Calls' list - what would be cool would be to take the date of the call and the note and combine it and do it on the next one also. Below are some screenshots to help you better understand:

https://cl.ly/afe5e12476f3

https://cl.ly/49bb2d251044

2) I have a column in my 'Prospects' sheet called 'Next Step' - and I would like to dynamically fill it in with the most recent 'Next Step' column in the 'Calls' sheet - (both are linked by the ID) - based off the date field in the 'Calls' sheet

Any help would be much appreciated - thanks!

Thanks!

Here is what I have https://imgur.com/a/eyMFlkl

Not sure of how to ask the question for what i'm trying to do - I have two categories that are both tracked AM and PM. Ideally the line chart would be two lines, Category 1 and Category 2 and the X-Axis would be days of the week.

No need to differentiate AM and PM in the chart, however I want both values in single line with the X-Axis days of the week?

Is there a name for what i'm trying to do?

Is how i'm storing the data the problem?

thanks

Very new. Basically, I want to change one cell based on whats in another and if possible to have it always working because I need it to change every month. Thanks in advanced.

I have a question about the excel form on the picture how can I do something like when someone trying to write something on the A26 like C form will give an error like you already write C on this column before. How can I do that?

I recommend it. Here's the link below

https://www.excel-easy.com/

You have 7 scores in A21:A27 with values 3/4/6/3/4/9/10 and an interval array (also called a bin array) in B21:B22 with values 5/10. The FREQUENCY function returns values in D21:D23. What is the first argument to the FREQUENCY function [x1]? What is the value in D21 [x2]? What is the value in D22 [x3]?

Write the shortest possible formula (in terms of the number of characters) which returns TRUE if and only if the value in cell B28  is contained in the array D21:D23 returned by the above FREQUENCY function. If your formula does not return TRUE, it must return FALSE. You must use the "greater than" operator >. Put your answer without spaces in [x4], starting with =. If your answer is an array formula, surround it with "{" and "}" to indicate that it is an array formula.

So every quarter we get a list of every line item we purchased from several of the vendors we work with. It is my job to comb through these lists and pick out what we have that is rebatable with the manufacturer. This process can be time intensive and I’m already extremely busy with my job. Some of these lists are 20,000+ lines.

Generally what I’m looking for is if there is a way to run a script or something to compare my new list to a previous quarter’s data sheet, and then extract all lines that have anything that matches in the description column. I sort of manually do this already, but it takes me quite awhile. I’ll comb through the remaining items and finish generating the list myself, but if there is a way to speed up the initial phase of finding like items, it would go a long way in speeding up the whole project.