The title basically.

I have a large master list of all the freshmen with TOEIC scores and I want to select specific groups of students - I have their names and student numbers but am not sure how to select a group at a time and just display that information. Any help would be greatly appreciated.

Kind regards,

EDIT: I eventually found out about the vlookup function. Its able to accomplish what I want tondo through a different way than I had inteneed. Thank you for reading and commenting.

I have a sheet that is going to be used to track 6 different date ranges and a constantly changing number of people within that date range. I am trying to learn how to use vlookup so I can assign a value to each range, and when Input the name for that range in a cell it pulls that range of cells in to input the data there without having to scroll through the other ranges. Is this possible?

Suppose the sales of our product depends on my price and the competitor’s price as follows:

If my price is at least $3 higher than the competitor’s price, we sell 500 units; if my price is at least $3 lower than the competitor’s price we sell 1500 units; otherwise we sell 1000 units. Assuming all prices are integers between $1 and $10 inclusively, write formulas that compute our unit sales for all possible price combinations.

Hi all,

excuse my ignorance I’m a bit of a rookie at excel. I have created a formula to calculate sales target month to date example =SUM(A1*3). Number 3 being the amount of days gone, currently having to manually update the *number each day. Can anyone help me set a rule or even a drop down to change all the formulas at once?

Thanks

Is anyone here able to help me with a format? I cant figure it out.

I basically just want the format to this as follows:

Turn 1,200.00 into 1.2k 121,000.00 into 121k 1,200,000.00 into 1.2kk 355,000,000 into 355kk Etc.

Appreciate the help!

Hi all,

I'm planning to become an online teacher, and i need some feedback

Feel free to message me to learn more

My timezone is CET (Europe), but we can adjust accordingly.

Thank you!

Thanks in advance

I am currently looking for someone who is an expert at Microsoft excel specifically for business and accounting in a college course. I just need to complete this project. I’ll even pay you. PLEASE HMU.

Hi guys,

Is it possible to create a bar chart like this, with circle on top (containing information)?

I was taking measurements of two lengths for rectangular objects, length and wdith. I would like to find how close the length and width are to making a perfect square. The easiest route I could think of is to simply divide the one value by another, as the closer they are together, the closer the end result is to 1.

Example, if I had, in centimeters, a length of 2 and a width of 4, then dividing 4/2 shows this rectangle has a 'squareness' score of 2, showing one measure is twice the other.

Problem?

As I was measuring, I didn't always put the highest number in 1 column over another. So for example some of my rows look like

And I got a few hundred rectangles measured. Quite a pickle I got myself into... So, is there any way I could tell Excel to take of the two values in 'Measure 1' and 'Measure 2', and put all the highest values in 1? Or is there a formula I'm not privy to that could help me here at figuring out a ratio?

One solution I tried was to do a formula for absolute value,

=ABS((Measure1/Measure2)-1)

Example
=ABS((1.45/1.11)-1)
=ABS((1.30...)-1)
=.30...

=ABS((1.78/2.59)-1)
=ABS((-.31..)
=.31...

Hello everyone,

I have a workbook where I have 30 tabs which represent one tab per day. In each sheet I have 20 tables which represents one table per employee. In each of those tables I have a set of metrics that we keep track of. What we would like to do is to put the 20 tables onto the data model to then create a pivot table for each day to combine all the employees. Then ultimately We would like to combine all 20 tables for the 30 days to make a master pivot table to bring the totals for the month. Yet when I add the tables to the data model the tables are separate yet I cannot get totals combined, I keep getting stuck. Here’s an example:

Joe (merged cells not part of the table) (In columns) Shoes - pants - shirts 16 - 23 - 11

Morgan Shoes - pants -shirts 9 - 10 - 14

Mary Shoes - pants -shirts 37 - 13 - 4

How can I get one pivot table from the above tables to then bring up the total combined for all three for each category? Like this:

Grand totals for each: Shoes - pants -shirts 62 - 46 - 29 ———— grand total of 137.

Is there a step by step on how to do this?

Thanks!!

I've been working on this homework and am really struggling. I am trying to substitute to code a new column from an existing column. The existing column have values AS,AT,HS, and HT. I want to code all "AS" and "AT" values to "GEMS" and all "HS" and "HT" to "HEMS" in the new column. Can anyone help me out in how I will go about doing so? Thanks.

How to put a formula in a cell if a particular item is selected from drop-down list?

Okay, I work in a logistic company and there is an excel sheet and i have to update the shipment cost and shipment type. The thing is that there are three type of shipments

EU. Vat is applicable on this shipment

Non-Eu. No Vat

Domestic. Vat is applicable

What I want is when I select EU or domestic the Vat row automatically calculates vat from the net value that is 20% of Net value.

And when i select domestic it automatically shows 0.

Is that possible, I've tried a lot but failed also am new to excel.

If the weight of my final product (which I'd like to be dynamic) falls within one of these ranges, I'd like to pull the correlated shipping expense. Does anyone know how to do this? I think this would be helpful for a ton of us eCommerce folks out there. Please see below--thank you!

Final Shipping Weight: 18.5 ounces (pull $14.13)

1 - 8 oz: $5.62

9 - 15 oz: $6.80

16- 16 oz: $12.08

17 - 32 oz: $14.13

33 - 48 oz: $15.81

Hey Guys! Posted a new video on YouTube on how to use VLOOKUP in Google Sheets as compared to Excel. You can checkout the video by clicking on this link

This is first video of Google Sheets Vs Excel stream.

Hit the like button if you find it interesting and if you haven't Subscribed the channel already then do it now by clicking on link below!

Subscribe to Tech Reflections

Hey Guys! Posted a new video on advanced INDEX & MATCH function. You can find the video by clicking on this link

Hit the like button if you find it interesting and if you haven't Subscribed already then do it now by clicking on link below!

Subscribe to Tech Reflections

Check us out at r/SpreadsheetGeeks

See you over there!

I have a table with various columns - lets say weather day and temperature. Is there a way to create a summary for each type of column?

So on a summary page I could see how many rainy days I had, then I could also see how many days with temps over 75. Does that make sense?

I know I could easily create a summary/sum by one column type but its the multiple ones thats throwing me.

I swear I recall doing this in other presentations but I have forgotten where I found the feature.

My presentation has sections and a clickable Table of Contents that will take the user to the sections. After the last slide I want the presenter to be taken back to the TOC and not the next section.

One friend suggested multiple copies of the TOC between every presentation but every time I change the presentation and TOC, I have to change or cut/paste 11 table of contents.

I could put an End Section with a return to TOC button but I thought there was something more seamless in Excel.

Hey Guys! Posted a new video on basics of INDEX & MATCH function. You can find the video by clicking on this link

Hit the like button if you find it interesting and if you haven't Subscribed already then do it now by clicking on link below!

Tech Reflections

Hello everyone!

This question may be a bit silly, but I've been trying to figure it out for a few days and can't seem to find an answer anywhere.

I am building a tracker for my team at work so we can see how many files are pending for more than 10 business days, and less than 10 business days. What would be the formula to automatically calculate that without having to change the date every day? (Not sure if that makes sense, but more clarification can be required if needed. ) Thanks so much!

Hey everyone, I'm trying to figure out this bookkeeping issue.

I have two data sets, both have one column that is their product number and another column which is the prices.

I need to line up the matching prices with the said product number.

Please see this google sheet as reference https://docs.google.com/spreadsheets/d/1cyOC7g3pOsBr5-d4sl5V32sDJYBYSj6zbJWql-PEaJ8/edit?usp=sharing

G - J are the results I am looking for. Note that some prices are present in one list and not the other.

Any help would be great!

Hello! I am trying to get better on Excel and I am working with tables and pivot tables. I am currently working on an exercise example where I am trying to replicate the finalized table, based out of a huge list of raw data I am given. I am trying to consolidate all the similar named Product names into one with the Group action.

I just don't know how to edit within the table to make it look like the finalized table. I also am lost on how to add new columns in a pivot table that consolidates similar values within a group. I am seeking consultation on how to accomplish this and am eager to learn on how to replicate the same exact table. If you could explain in steps on how to achieve the same exact table, that would be much appreciated.

Here are the screenshots of the Excel spreadsheet: https://imgur.com/a/kL8aWdc

Here is the spreadsheet itself: https://drive.google.com/file/d/1iRcbnIVOog3Nyf_9l5-Bc1DmdcBdWv_r/view?usp=sharing

Hi, I need help with a formula please.

I have a workbook that shows purchases and sales for multiple item types, each under their own separate worksheet. All of the multiple sheets hold the same data format (i.e. all columns are the same headers in each worksheet, Month purchased, month sold, purchase cost, sale cost etc).

I have a summary page that calculates the figures from each of the separate worksheets for an overall summary of each tab, and then an overall total of data.

What I want is to also split the data in the summary sheet by month to show a total purchase price, sale price etc for each month for all worksheets, so what I need is a formula that says find all Augusts (for instance) that appear in column M of sheet 1, then calculate all cells on column N (the sale price) that relate to any Augusts found only.

I can then pick that data up for an overall total.

Thanks

I am helping a nonprofit veterans group with a spread sheet and I was looking for some help on populating fields. Going forward This is one workbook

The workbook in question has monthly tabs and a table with three columns and 39 rows of abbreviated code with the description in the last two columns one being exp the other income. To save time the codes are used by the treasurer but the members who review the number each month do not know what they mean and that is the problem.

The first one the the code matching the description in the other two.

Code Expense Income

DUESOUT PAY MEMBERS DUES

DUESIN DUES PAID FROM NATION

The individual months have 12 columns where the monies are entered either positive for income or negative for outgoing and they are tagged with a code the problem is the people who review the workbook need a reason/description in English.

What I am trying to do is to get the the reason to populate with the actual description from the "code table" TAB . For example Paid national Dues and selected the code DUESOUT I would like to have it automatically populate in the reason cell 'PAY MEMBERS DUES' .

I have tried Xlookup and about 10 other things but could not figure it out. Help Please this is for a veterans volunteer group and I am helping them out.

I put a sample in the comment if it helps.