I am trying to build a spreadsheet that has multiple condition. When I plug in my conditions into conditional formatting, it won't work.
1st condition: I want 3 rows to be filled in blue, with border and vertical lines highlighted, one line no fill/border, then the next 3 rows to be no fill...
hello Im trying to build a data base of parts warranty info. what im looking to do is when I select a part number via drop down menu in the 'part number' column, the corresponding description and cost columns in the same sheet are automatically filled in. my image below... the PN# column is a...
I have provided the screenshot of my excel worksheet. I want to rename the cells in column B chronologically same as Column A but without losing the blank cells. i.e the first "transfer" name cell of column B will be "transfer 1", the second "transfer" name cell of column B will be "transfer 2"...
Hi
Using PowerQuery I want to transform the first table into the second so that every 'Number' in a 'Region' shows every 'Location' in that 'Region', with multiple rows per 'Number'. This is just dummy data.
I have tried doing this with pivot/unpivot but struggling to get my head around it...
Hi all,
So I have a table similar to the below which acts as a matrix, so Req ID 1 is in F1 but could be in any number of Fx, up to about F80.
The status of a Req ID can be updated
The Team X is the team who is interested/working on the particular Req.
Req ID
Status
F1
F2
F3
F4
F5
1
Agreed...
Hello!
So my first problem is as follows;
When I make ticket purchases these are given a purchase number from my supplier & a quantity, for example;
Purchase number;
34598
QTY;
4
I then use a simple Vlookup formula to filter through which event this ticket is attached to.
Once those...
Hello -
I’ve been tinkering around with a sheet at work and I’ve been using various sources for getting data into a specific sheet so a group of 50 people can use.
The best way I can query my data is through Microsoft exchange and applying filters to a specific email with excel attachments...
Dear All
I have a file with 65 different course I'd with status and level as column header and employees details as rows. What I want is to change this horizontal structure to a vertical one. There are a total of 300+ employees. I need the employee details as it is in the rows but repeated for...
Hello,
I have a spreadsheet on Sharepoint that I'm trying to make work.
The purposes:
To allow people from our building can add their name and birthdays.
To have conditional formatting that automatically highlights all rows containing dates from the current month.
To automatically populate...
Hi all,
Whenever I open a csv I get this warning message:
Furthermore, my data shift's over to the right, there is an example below but the issue can be random - it may add lots of different empty rows and shift a few rows over to the right, or sometimes the data overlays the rows on top of...
Short version: I am trying to change the code below, so worksheet 41460 can be any Excel file in a certain folder:
Further explanation:
I have more than 100 Excel files in a single folder, all with the same format. Column A contains a unique number. In one document, there might be 10 of these...
Hi
I can't XL2BB as my work won't allow it:
I need a VBA code on workbook open to sort these three columns (not the total) by days lost > highest to smallest. A small caveat here is that the VBA will need to first unprotect the workbook (with password) before sorting the data and then...
Hello,
I have multiple workbooks and they have approximately 25 sheets in each of them. I need to extract same data from each of them. The data is always in the same cell and sheet. I need to extract data to one new workbook. What is the easiest way to do this?
EDIT:
Also I need to extract...
Hi guys,
I am working on a project for my work which is a form that users can use to help them make decisions etc.
I have this code that provides the ability to make multiple selections from a data validation list, so instead of the default excel position of being able to select one option...
Hi all!
I am using a data scraper to pull info from the web and an struggling to transform it in a way that's easily read.
Right now the csv file comes out like this:
Title - data
Title - data
Title - data
And then it repeats in blocks like that. What I want is to move the titles into the...
Hi Mr Excel,
How do find Number Pattern in data which is :
1. Starting a Negative value ( - )
2. Follow by at least a Zero ( 0 / 00 / 000 / 000..... )
3. Follow by a Positive value ( + )
4. End with a Negative value ( - )
Number Pattern : - 0 + -
When Number Pattern found, assign "1" at...
Context: Pathshala Learning Center (PLC) is a community learning center, has been serving children & youth across 13 villages in the Gular Dogi region (District - Tehri Garhwal, Uttarakhand) since 2016. It has been striving to facilitate an environment of opportunities and holistic learning...
I have come to this weird issue where excel isn't using the target cells for my formula until i double click into each cell that that kind of refreshes it into working.
in the example below you can see rows 9,10 and 11 have nothing in column K, however if i were to double click into one of...
Hello-I have a series of power queries that culminate in a large dataset of more than 1 million records. I would like to publish access to the power query as a connection, rather than as a workbook table given it’s large size and growing.
In a nutshell, I’d like to allow access to the power...
Hello
Wondering if an Excel expert can help.
I'm wondering if this might be due to an update but i'm not entirely sure. I have a workbook at work which is used to track absence. There is a master data sheet which is refreshed with a system report every day, so on the absence sheet, all the...
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.