Hi all!
I am currently comparing values in two sheets to each other to see if they are similar or dissimilar.
I have this setup at the moment:
My formula is: =IF(COUNTIFS('[CONFIDENTIAL - NUMBER.xlsx]Sheet1'!$T$2:$T$1712;E2;'[CONFIDENTIAL - NUMBER.xlsx]Sheet1'!$R$2:$R$1712;A2)=1;"yes";"no")...
Hello
I have the follow VBA code which stacks all of column A on top of column B and so on. What I need it to do now is stack all of row 1 on top of row 2 etc.
So rather than having:
A1
A2
A3
B1
B2
B3... etc.
It would instead be:
A1
B1
A2
B2
A3
B3... etc.
Any help would be appreciated, thank...
Hello,
So, with help of kind people here I was able to make most of my project work, but have hit the hopefully last bump. Basically, I have a worksheet that based on condition decides whether the issue should go after Quality, Logistics or Finances, and then generates an email to be just sent...
Hi, i`m trying to recover an old MSSQL Database that has a column with Rich Text Format Code, I exported the table with this column to Excel and, as it is an RTF chain, the text is illegible. However, every time that I double click on a cell with this RTF chain, it displays the text correctly...
0000378G
FCP1 or FCP4
€ 39.44
0
€ -
0
€ -
0000447G
0
€ -
0
€ -
0
€ -
0000450G
0
€ -
0
€ -
0
€ -
0000458G
2.01.03
€ 70.47
2.01.07.01.02
€ 375.75
2.01.07.01.02
€ 228.13
So this is example of my data.
Now i want the addition of the amount for each value (2.01.07.01.02) for each ID.
I...
I am trying to use the getpivotdata formula to use the data from a larger pivot table. If I use the formula that excel gives me when I put =and click the value i need it looks like this "=GETPIVOTDATA("[Measures].[Count of Training Start]",$A$3,"[Table4].[Manager]","[Table4].[Manager].&[C...
Hello, i have a question for a practice interview test which is
On the ‘Workings’ sheet use formula and/or pivots to analyse this dataset to identify the percentage of students still retained and graduated at the end of the third year (by course) and the proportion of graduates that received a...
Hi all,
I currently have this graph:
I don't really care about the light and dark orange columns, but I need them to stay nonetheless.
However, the grey chart rises from a value of about 9300 to 10500 doing this period, which is not that noticeable in this chart to be honest. I would like...
Hello,
First of all, I am still new to VBA and more complex excel coding, so I'm learning by doing, searching forums and tutorials, stitching together bits and pieces of code I need. However, I ran into a dead end and would need help. Basically, what I'm trying to do: I have a project to sort...
Hello,
Really silly question but I have no idea how to do this:
I need to add these two:
Me.Protect Password:="zzz"
Me.Unprotect Password:="zzz"
Into the below, so I can get the below to work on a protected workbook. The ZZZ I will amend to the protection password later but it basically...
Hello,
The code below is not working properly:
I can't understand how this is happening, as I have another workbook laid out the same with exactly the same code in it and it works perfectly. I'm not an advanced user at all, someone on here kindly put it together for me, so I have no idea how...
Hello,
So, I have a question if you have ever encountered this, if it's normal or how to solve this problem. I am new to macros, and for my project in work I have a table with information. However, this table is important for three different departments, and every department needs different...
Hey all! I'm trying to set up an excel speadsheet to track my finances. The numbers included on the mini-sheet are just examples. What I would like to have happen is that in column N I can select what type of purchase is being made (Housing, Food, etc.) and then based on designation given in...
Hello, I'm fairly new to excel and was hoping I could get some help. I'm trying to add an IF statement to the following so that if a cell has 0 then it will change to a blank/empty cell/nothing shows. The 0's populate in columns A and B of another sheet that is not Sheet1 (source data), but...
Hi,
I am trying to make a dispatch note that when you type in the UJN from our project tracker it will pull through the Customer, Plot or Site Information depending on the cell.
I have used this formula on a current spreadsheet to show some delivery info at a glance...
Hello All,
I need a formula that looks back 11 weeks from a given date and returns the Sunday at the beginning of that week.
- Example, 27/10/2022. 11 weeks prior is 11/08/2022 and the Sunday beginning that week is 07/08/2022. The formula would return 07/08/2022.
I also need one that looks...
Hello all,
I've been trying to create a database for my teams new classes, and I'm running into a syntax issue.
I'm new to excel formulas, and am fresh from beginner Python 3, so it's getting a bit jumbled.
Basically, I have a sheet with raw data on tests passed, failed, and missing, and a place...
Version: Excel Online
I want an average of the time (in days) between two milestones for many different people (one person per row), but I want the formula to ignore that row if there isn't a date in BOTH date cells, since it throws off the average in a major way.
Example "TABLE_1"
EE Name...
Hi all,
I currently have this graph here:
I would like to color the area inbetween the yellow and the red line with an orange color. I would like to know:
1) is this possible, and if so, how?
2) if it is possible, is it also possible to make it do this coloring without pasting the orange...
Hi Everyone!
What I am trying to do is link start and end dates from one work book into another, but not the exact cell position where the date currently is.
I can do the first part easily enough by putting "=" in the cell of my current work book, and then selecting the date cell from my...
auto
automation
cells
dates
help
inserting new rows
linking cells
linking dates
linking work books
new row
please
reference
reference books
reference cell
referencing
referencing a cell
referencing a date
referencing another work book
referencing cell from different work book
referencing date from different work book
thank you
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.