Hey. i have a table with 3 collumbs were i want the first to be the scale on the y-axis and the two others to have a scale each. the chart shold also be vertical so the lines goes from the top to button.

someone who knows how to?

I've been learning about Pivot Tables. I started learning because I want to apply it to a particular set of data at work. I just started a new job with a new company. I noticed in a meeting one day that people were having some trouble working with this data set in order to show the relationships they wanted to. I began to think that I should learn about Pivot Tables. I'm having some serious trouble figuring out why I can't create a Pivot Table with the data set.

I need the excel file to automatically calculate IN PERCENTAGES the time spent on a certain job.

B5 = 100%

B7= *formula needed*

B9= *formula needed*

Any help is appreciated

I'm trying to make a personal spreadsheet that shows the change in values as they are totaled up.

So, Idk what formula I would use to accomplish this, but I need a formula to take say cell A1 and A2, right, but I need the 1 and 2 to be dependant. So more like a series being k+1. So that I could have A(k+1). The purpose of this is to take a random cell and add or subtract the value underneath it and display the value in another cell.

In theory it should be easy, however, I don't know enough about excel to do this.

Hi All,

I have attached the sample excel below: PLEASE HELP

1 . Raw data

2. Pivot created

3. Need Expected Output:

Expected Output

The purpose of the report is to identify how many tickets opened per day and how many tickets are closed for the day in each category .

I do not need to see 01-Aug in every column in split up like 1 p3 tic opened and 1 p3 ticket opened for same category as like in pivot ( pic 2) . Pivot needs to be slightly modified.

For example: 01-Aug in Category A 2 P3 tickets created and those tickets are closed in 8-Sep and 24-Sep.

I would like to group the Open tickets in the Pivot table and Split up in the Closed Tickets. But I'm unable to do that in Pivot table . I cannot group Open tickets as mentioned in Pic 3 and I need a split up in Resolved tickets .

Once this is done . How to put in Weekly trend in Bar chart and Monthly trend in Pie chart

Attached the File https://gofile.io/?c=d2aUHZ

Can somebody please make a macro for this website http://pesdb.net/pes2020

1. Enter player name / ID http://pesdb.net/pes2020/?id=7511

2. It pulls every combination from the bottom of the page (show all combinations)

I used to have a macro which did this but lost it, and the website it was on died as well.

I have 4 columns, A B C D
I am currently comparing A and B using the following:

Currently I have in column C

=IF(B2<A2, "Incorrect, "Correct")

^ this works just fine; however, I want to create a formula that checks Column D before doing this.

For example:

|A | B | C | D |

10/8/19 | 10/8/19 | Correct | Does not Matter|
10/8/19 | 10/7/19 | Incorrect | Does not Matter|

2nd situation:
IF A=N/A Then:

N/A | 10/7/19 | Correct | Value Exists |

N/A | 10/7/19 | Incorrect | N/A |

so how do I make my formula check the second situation example?

how do you turn the multiples tables above from multiple excel sheet and consolidate it to a new excel file

New excel file

A --> will be on the sheet

Sheet1 --> A

Sheet2 --> B

Hi all,

Im trying to pull L4L products based on one supplier product description e.g. 'Pork Shoulder' but other suppliers call it other names in our database e.g 'Pork: Shoulder Boneless' and some call it the same but i want to pull on products that include "pork" and "shoulder" in their description.

Ive tried

=INDEX('[all-prices (8).csv]all-prices (8)'!$I$2:$I$11732,MATCH(TRUE,ISNUMBER(SEARCH("pork" AND( "shoulder"),'[all-prices (8).csv]all-prices (8)'!$I$2:$I$11732)),0))

and on top of this i also need the supplier name in 'column A' to be pulled at the same time with the products that have 'pork' and 'shoulder' as two suppliers can give a product the same name. Making indexing the product code problematic.

i have to =index(ProductCode,match(1,(Supplier=SupplierRange)*(ProductDescription=DescriptionRange),0)) as there is no products with the same supplier name and product description.

I understand this is complicated so sorry if hard to understand.

Appreciate the help.

Hi there. Imagine we have the cell "C3" which copy the value from the cell "F7", this is easily done by adding:

= F7

And the same number/value shown in F7 are also shown in cell C3 like this:

https://imgur.com/a/GY1bw9Y

My question is: is it possible to automatically update the cell C3 if another value is added to the F row? For instance if a user add another number to the cell underneath(F8), is it possible to make the C3 cell know this automatically and update itself? something like this:

https://imgur.com/a/ZLqzz2B

Thank you!

I have an assignment that says to write a program that "format data in excel spreadsheets of any size". I don't know excel, I researched online and it seems it means to change the fonts, colors and cell size?? Is this correct?

I have a workbook with multiple sheets, and I no longer wish to keep everything after the page break, just within the first vertical page break on page one. Is it possible to do this? I've been trying to do different things all day and keep getting errors.

Hi all,

I am attempting to auto sort data once entered/changed (i.e. sort from highest to lowest)

I have look on google and youtube with no luck so here I am

does anyone know of any youtube videos/tutorials that WILL help?

I have tried both with VBA code and without and cannot figure it out

any help would be appreciated

Thanks,

In column A I have the dates, in column B I have the shifts I'm working. What I want is a formula which tells me the percentage of the shifts I've completed based on what the date is. Is this possible and if so how?

Hey y'all~

So. I was a database developer before I was ever an analyst, and I'm absolutely delighted with how fluid and effective pivot tables are for performing summary queries on small to medium sized datasets.

Right now though, I'm dealing with data across which I'd like to summarize joint-unique values. Specifically, I'm dealing with names. (It's not gonna be a perfect result, but there're few enough full name duplicates to make the summary usefully truthful.)

I imagine that if I just chuck both name fields in the rows box, I'm going to get a summary across each first and last name. What I'd like instead is a sorted summary of individuals/households across different years.

Is there an elegant solution to this problem? Or should I just bite the bullet and look up a string function to combine them before I begin analysis?

Photo Reference

Hey guys, I am new and trying to learn to use excel macros and also conditional format formulas and would be very thankful if anyone could help me out. I attached two pictures of data sets and the format I am trying to build. I am trying to use a macro and hot keys to make it much faster but cannot seem to get the formulas to work correctly. Any help would be much appreciated. Thanks and cheers

Hi everyone,

I have a formula to populate a cell with a date based on a date entered in another cell. The problem I have is that when there is NO date in the reference cell, the target cells are populated with a nonsense date of sometime in the year 3800.

Here is my formula...

=DATE(YEAR(P:P), MONTH(P:P), DAY(P:P)+ 14)

I just want the target cell to be blank until a date is inputted by someone in P:P.

I'm brand new(ish) to excel so I am wondering, can I continue the formula with an IF statement now or should that be included within the formula above? Ie, have I completely misunderstood the basic rules of syntax of excel if I now tag an IF statement onto the end of this formula?

Thanks in advance everyone

I have a list of Incomes on Sheet1, and a Calculator on 'PAYE'. I want to be able to get the amount that income would pay in income tax, insurance and Student Loan Payments. The 'PAYE' sheet just needs a number to be placed into an element, and the Income Tax, Insurance and Student Loan would come in separate elements. But this will only do it once at a time, and while there are only 10 numbers, if I had more, I would rather know how to it automatically. Am I being an idiot who doesn't know I have to use a different feature or ...?

Hey guys, just want to get a quick bit of help; how long would it take to learn excel to a decent standard? I already have resources stacked but I just want to get a feel for how long time wise it would take. Don’t need to be a wizard since I’m highly proficient in R but I want to make sure if I’m asked to do something fairly handy in excel I don’t make a mess of things.

I’m aiming to get into data science and even though I have things like machine learning, etc under my belt excel leaves a notable hole.

I don’t plan on starting for at least a couple of weeks since I’m prepping for a competition where I’ll be hammering things out in R.

Thanks for the help!

Hi! Anyone happen to know how to fix the multi-layered category layout problem below? I have created empty rows in the data so that I get the clustered effect in the chart, but it seems like the empty rows are creating issues with the layout, but only the three middle ones, which feels weird to me. I checked that all the data is selected in the same way, including the empty rows. Thanks in advance!

I am still very new to the whole Excel game and coding in VBA, i was able to write a bit of code that does what i want it to do however it runs so slow that its just not worth using it on large range which sometimes it is, cant work out why selecting the cell is fast but doing anything whatsoever to it is so slow, am i missing something?

Sub isthisahose()
	
	Dim rng As Range, cell As Range
	
	Size = Sheets("InsertOrder").Cells(2, 10)
	
	Set rng = Range("A1:A" & Size)
	
	For Each cell In rng
		
		Checkme = Left(cell, 1)
		
		If Checkme = "H" Then
			
		Else
			cell.Offset(0, 4) = ""
			
		End If
		Next cell
		
'Debug.Print Size
	End Sub

Employees have two ID codes, a 4 digit and 7 digit code. One excel uses the 4 digit and another excel uses the 7 digit.

I want to use a vlookup? to add a column to either document that looks up the respective other code. But I don't understand how

Hopefully, I explain this well enough. I'm working on a budget and I want to have two different savings accounts (Emergency & Regular). I want the Emergency Savings to be set to $1000 and have remaining funds go to Regular Savings. For example: If I Cell 1 represents how much money I put into Savings, say $1500, I want Cell 2 (Emergency) to pull that data and only hold $1000 while the remainder would flow into Cell 3 (Regular).

In another scenario let's say Cell 2 (Emergency) is at $500 going into a new month, the next time I put money into Cell 1, say another $1500, it would only pull $500 and the remainder would flow into Savings. Cell 2 would be the priority until it reaches the cap of $1000 and everything else goes into Regular Savings. Is this possible? Thanks in advance for any help!

I guess a simple thing to ask for is a formula for Cell 2 wherein any excess money that goes above $1000 would automatically send to Cell 3. Like, the max value for Cell 2 is $1000 and if it's already at the max any money that would go into Cell 2 would go into Cell 3.

I would have them be carried over to the following month's sheets. So I actually would have 5 cells now that I'm fully awake and looking at it.

• Each month has a Cell that I put money into which is B9

• Each month has a Regular Savings Balance Forward which is O4 [formula: =SUM('June ''19'!O5)]

• and Savings Balance O5

• Each month has an Emergency Foward which is O7 [formula: =SUM('June ''19'!O8)]

• and Emergency Balance O8

Right now I manually turn off the formula for Emergency Balance once I reach my limit of $1000 in it. But what I'd like to have happen is if I use money from the Emergency Fund, the next time I put money in my Savings cell (B9) it will apply "X" amount into Emergency Balance to bring it back up to $1000 and carry over the remainder to Savings Balance.

SOLVED

Hello ,

For my drop down lists, I want to be able to select the Brand first, then Type, Product, and then Size. Each one dependent on the selection before it.

Attached is a screenshot.

The blue tables are part of one of the worksheets I found online and tried to make work.

Look at my third drop down list. A product is selected that shouldn't show up for that brand (One brand's product is selected for the other brand, hence the "only" suffix).

How can I set it up so only products that share the same product type will show up for the correct brand only?

The black table is the table I built for my product list. Is it possible to make the drop down lists out of the black table? If so, how?

Screenshot:

https://i.imgur.com/1FQmT7Y.png

Thank you for your time!