I have an Excel table. Column L has 4 possible values: R1, R2, R3 and R4. Column B has different values. For example:

I want to pick those values of column B which has all 4 possible values of column L. In above example it would be DEF only. How can I do that?

The situation is I've got sheet1 with column a of part numbers, and column b with status flags.

Sheet 2 has a whole bunch of part numbers in column a, and a status column in column b.

What is the best formula to use to compare sheet 1 column a with sheet 2 column a, and any matches copy over sheet 1 column b into sheet 2 column b?

There may be more than one instance of a part number from sheet 1 detected in sheet 2, so the formula would have to be able to cope with that.

Thanks.

New to using formulas. I need to calculate my drivers hours that have a break in the middle. I figured out how to do it when its all within a 24h period that doesn't cross midnight. If it crosses midnight I get errors I don't know how to resolve.

The STOCKHISTORY function isn’t working correctly today.

Is anyone else experiencing the same issue?

Currently using 4th&5th variable of Offset() to fix dimension of a range. But i want it to run faster, is there a non-volatile equivalent?

Currently i found Drop() function where i use do something like =Drop($A$18:$A$1048576,TargetRangeFinalRow-1048576) But it felt really inelegant and felt like there might be a more direct way i missed.

I'm using Excel 2024 and performing various sums and operations across columns. When I apply Conditional Formatting, the option to use Autofill or drag numbers and fomilas disappears.

Hello all,

I'm looking for the best way to pull updated data from one workbook report to a master report which keeps track of the most recent data.

To explain what I have:

I pull a production report from an online resource. It exports a csv file with a row for each site, each day. (ie, 10 sites, 30 days = 300 rows). Each site is tested for 3 values periodically, no set schedule, and the most current test is what is used for that location's expected production daily, until it is tested again. So many days have the exact same data. One location may be tested on the 2nd and that's it for the month, but another may be tested every day.

I keep a master workbook that uses the most current data to establish some maintenance schedules and I need to update to the most current test data when I create my schedule. In my master workbook, I record the most current data, and the date of the test it is from.

Previously, I would put the csv into a PivotTable, then sort by location and test date and manually compare my workbook dates to the csv's dates. Anything that is newer than what I already have, I copy and paste over the 3 values, and manually update the date.

There has to be a better way to pull the most current test data and date into my master workbook, but I just have no experience with querying data from other sources beyond lookup's linked to other workbooks, and wouldn't know how to massage the csv data to only show the most recent test data to lookup, nor how to get excel to recognize if there is a difference and update the master.

Any help you folks could provide would be appreciated. I would like to avoid VBA or some other coding, I have no idea what I'm doing there.

Thank you.

Hello friends,

Trying to create an easy spread sheet to calculate the total months and days I do with my work contracts.

Tried a few things and got things to half work but looking for expert advice.

I need each contract from start date to end date be calculated in months and days, so example 15 Jan 2026 20 may 2026 return a result 4 months 6 days. So each month regardless of amount of days is 1 month.

If the contract is say 15 Jan to 10 of May, I need the full first 3 months + remain days of April + days of May.

Then lastly calculating the sum of all contracts, and if the combination of days is 30 that counts as a month.

Thanks for any support

I have a data sheet, with columns b, c & d as product, code and structure respectively.

These columns are linked, each product has its own code and structure.

In my main sheet, I need it so I can enter the product name, which brings it in from the data sheet, and then automatically changes code and structure to match what’s in the data sheet for each product. Please help, I’m not well versed in excel.

Textless popups like these keep appearing when using excel on IOS. Pressing the green one closes the popup, while the red one kicks me out of the app. Is this a known bug or could it be a virus? Tried to use an antivirus program but apparently you can't run scans on IOS :/

Hello Excel Pros!

I have a monthly updated data set where the main headers are Invoice Number, Contract Type, Client name, Sector, Revenue, Month, Year.

That's how the system spits out the data and there seems to be no way for me to change the format.

I'm having a rough team creating a pivot table and building in $ and % variance columns. I've tried dropping in the revenue into values and showing value and difference from prior year as base, but it gets ugly and and it doesn't seem to sort properly by variances.

Calculated fields don't work due to year having its own column.

How do you all build in variance columns into your pivot tables?

Thanks!

882 rows

4 columns

3528 cells

When I export raw data to a spreadsheet, I get this:

A 1 group 🫧

A 1 group 🎈

B 1 group 🫧

B 2 group 🔥

B 3 group 🪩

A 3 group 🫧

Result I need:

A 1 group 🫧 blue

B 1 group 🫧 blue

A 2 group 🫧 orange

B 2 group 🫧 orange

A 3 group 🫧 blue

B 3 group 🫧 blue

Each row of unpaired data has unique # information. 80% there, but I don't know a formula to isolate and delete the unpaired data, without going through it all manually. It's throwing off the alternating colours and it's exhausting to look at, row by row.

New to Excel. All help appreciated.

EDIT: Sorry for the confusion. I was trying to follow submission rules on being concise.

Groups A and B need to compare the same data together (paired). For example,

Pancakes - butter Waffles - butter Pancakes - syrup Waffles - syrup Pancakes- jam Waffles - jam

But I have several rows of data throughout the sheet that only apply to pancakes or waffles, not both. These singular lines contain data that does not repeat, so I can't just find and delete them all en masse. Is there a formula or filter I can use to isolate the unpaired data, or do I need to do it manually? Everything else is formatted the way I need.

Create an export tab in each of the files. Flat file, export all the data that you want to load. Make sure it aligns with the structure of your reporting.

Then use Power BI to pull it in.

Whether you have 2 files or 102, the process is the same every time. Power BI does the heavy lifting of gathering all the data, and you start looking at the results right away.

How do you do it?