I recently learned that there are Excel World Championships, so naturally I wonder who is the best? In Chess, there is Magnus Carlsen. In Excel, that is not clear to me.

Thanks!

Just curious. I am using a worksheet that someone else has made. It’s for setting up work schedules. One formula to return the lenght of the workday is this: =IF(A1<=B1,B1-A1,B1-A1+DAY(1))
This adds 24 hours if the end time is after midnight. When I open the sheet in other worksheet programs than excel it will instead add 744 hours and DAY(1) gives out 31 instead of 1. I am using norwegian translation of Excel. =DAG(1) returns 1. Will it give the same output in english version?

Edit: Solved! DAY(1) returns 1 in Excel, but of some reason it returns 31 in some other programs.

I currently work in government accounting and one of my jobs is putting together a monthly appropriation report. Since im the only one here who seems versed in excel, ive decided to take the initiative and create a new report with better quality of life features.

So far, I've added a macro button that hides/unhides tabs as needed, a navigation bar that quick links to important tabs, and a cell that tells you the last time the report was edited. Of course, I also threw in a bunch of xlookup formulas where needed.

I wanted to ask if anyone else knows some neat tricks that makes reports easier to manage/navigate. It could also just be something that you did that impressed your boss when you showed it to them. Id appreciate any inspiration.

Thanks!

Hello! I'm trying to write a formula that accomplishes the following:

If the data in Sheet3 Column E finds an exact match in Sheet4 Column E AND the data in Sheet3 Column O finds an exact match in the same row of Sheet4 Column G, then return the data from that row in Sheet4 Column G.

This is what I've got going right now, which isn't working:

=IF(AND(Sheet3!E:E=Sheet4!E:E, Sheet3!O:O=Sheet4!G:G), Sheet4!G:G, "No match")

I also tried an XLOOKUP, which didnt work (and I wrote the above formula over the top of it, so i lost it).

Thank you for the help, it's much appreciated!!!

Hi all, I could use some help with an Excel assignment I was given at work.

I’m trying to automate the process of assigning vendor names to vendor IDs. The challenge is that the vendor IDs come in several different formats depending on which system they were pulled from, so creating a reliable automated mapping has been much harder than expected.

So far I’ve tried two approaches with little to no success: Long LET() formulas and Power Queries. Something to note about the power queries is that I have never used this tool before, but it seems like the varying nature of the data that is pulled does not allow for power queries to work

One important constraint is that the table needs to be dynamic. Whenever a new vendor is added to our system, the data refreshes automatically, so any solution needs to continue working without manual intervention.

Has anyone dealt with a similar problem or have suggestions on the best approach?

Edit: I am using the Microsoft 365 version of excel

Hello all - This one has me stumped.

I have a shared workbook where I need to lock the tabs or people accidently delete everything. When I click between say column B and C I get the down arrow you get when you move the cursor over say the letter B in the column.

If the tab is unlocked, I get the normal <---> to resize. Any ideas how to fix that?

So basically I have excel on onedrive, and when I save it sometimes replaces Enters with spaces on its own.
This results in hidden text and unreadable text. I there any way to fix that issue?

What command or set of combined commands can be used to interpolate between two numbers found in a set of values? I am using VLookup to find the GPM then the reference size of a pipe. As we know vlookup finds a value close to the value you are looking for and its reference in a range even if the value isn’t actually shown.

My question is how do I dynamically find the interpolation of the found vlookup value, for its numbers before and after? I have tried TREND and FORECAST and when I select the whole data set to find the values the yield the incorrect interpolation, and finding the values closer to the vlookup found value yields better results. Thanks for the help.

Does anyone know where I can get an official excel shirt? Looking for a gift for a coworker who is really into excel.

Hi everyone,
I have Document1 with columns B up to DM and rows down to 650 including headers in column 1. I need a formula to scan column AQ on document1 for a YES entry and copy its corresponding data on columns B, C, D, I, J, R, and Z to a blank Document 2.
Please let me know if you require additional information. TIA

For clarification the column headings are:
AQ=Invited (Yes or Blank)
B=Rank
C=Last Name
D=First Name
I=Date of Birth
J=Primary Phone
R=Email Address
Z=Vet Status

I really stuggle with IF statements in excel, and I can't figure this one out.

I am using a spreadsheet to track student loans / payments and will be using the snowball method. The snowball method is paying off highest interest loan first, then snowballing that minimum payment into the next loan. Example: Loan A has a minimum Payment of $51, Loan B has a minimum of $51, Loan C has a minimum of $51. When loan A is paid off, loan B's payment becomes $102, snowballing down the line of loans.

What I would LIKE it to do, though I am not even sure this is possible. If it's not, please let me know if I am wasting my time:

Condition 1: If my remaining balance is less than the minimum payment, then my payment that month should be the remaining balance*interest. This equation works on it's own, but not when I have been messing around trying to add the other conditions.

IF(M12>M$9,M$9,M12*(1+$N$5))

Condition 2: If my remaining balance is less than the minimum payment, the unused portion of the minimum payment should be added to the next loan. I haven't even really started with this piece, because I am already struggling with combining the other 2.

Condition 3: If the balance from the higher interest loan is fully paid off, the minimum payment from that loan gets added to the next loan. I tried adding this condition, but it's thowing off my equation.

IF(L$13=0,M$9$+R$9$,R$9$)

Image included below in comment showing cell values and just condition 1.

I know I’ve asked a similar question before, but I’m not sure how to translate it to the new task I want to use it for. I will post pictures in the comments.

Column L is the market my centers are in, Column M is the site name within the market. I’m not from the area I service, so I don’t know which ones are where off the top of my head. I want Column L to use a formula to select the market that goes with the site location. Example: If site is Arbor Walk, it will input Austin.

I have a table, I can play around with the formula and tweek it once I have it, but I have zero idea where to start.

Hello,

I have a very large table of data and I need to create another table in which the values of specific types would be summed up.

Here is a very simplified example of what I expect to do:

AB columns are the original table, and EF are what I expect to achieve.

I can think of a more complicated way to do this, where I select a whole table and sort by Type, and then sum up the values, but I want to have a function where I won't have to do this all over again, if, for example, the Type value from Apple would change to Banana.

Any advice?

I've no idea how to do this, apologies.

I have a spreadsheet full of cells marked "1" for each column.

I need to find a way to locate and highlight any instances of clusters of 12 (pink in the example below)

I know I can format to highlight duplicates, but is there a way to do this so any clusters of 12 are either highlighted or counted? Rather than just all duplicates?

Hi! I'm working on a file and since I had to split it, I copied a whole sheet creating a new file. The problem is the dates changed from 2026 to 2021/2022 and I cannot get it fixed.

On the left are a few correct dates and on the right are those in a new file.

My question is: can I prevent Excel from changing those dates back by 4 years? If I can't, can I somehow fix this issue without adding a formula?

I checked cells date format and it's the same as in the original file. Changing it doesn't do anything. Simply copying and pasting cells doesn't help, pasting it by Ctrl+Shift+V and then setting cell as "date" also fails.

Additional info: I worked on a file containing the same data just a couple hours ago and it didn't have that problem. I didn't change any settings in Excel, Microsoft 365 or computer.

How to make a Kanban board in Excel

Make columns for each stage and make them wide enough for your tasks. Create each task in a cell, then copy/paste it as an image. You can then drag the task cards around between columns. Pretty cool simple method and visually it works for me!

it'd be easy if i could just select the top most recent row, but i need the most recent data from past & future years as well 🥹

e.g. i want data from 2025-12, 2026-07, and so on in the future too

any help appreciated! thank youu

I'll be starting my first BA role soon, and I'd like to prepare as much as I can before my first day.

I have a basic foundation in Excel and SQL, but I'm a bit rusty since I haven't used them much lately. I've also been seeing that BAs work with data analysis, reporting, documentation, and sometimes data visualization. What skills or tools should I learn?

Also, if my company doesn't use many tools, what are some tools or workflows you personally use to make your work easier or be more productive? For example, AI tools, note-taking apps, diagramming tools, documentation templates, or anything that helps you stay organized and efficient.

I'd appreciate any recommendations, learning roadmap, or tips for someone just starting out. Thanks!

I'm working with a data table of customer information (a row for each customers, and columns for name, address, email, etc.) and trying to find potential duplicates. Thing is, this customer data could have been input a lot of different ways, so I'm not strictly looking for exact cell value matches. Some examples of what I mean:

"Emma Cartwright", "Ms. Emma Cartwright", and "Emma and Sam Cartwright" could all be the same person who information was entered three times, slightly differently.

Some customers have their name in the Name column, but some have a unique numbers for Name and a person's name in the Street Address column. So "Emma Cartwright" and "16934" might be the same person if 16934's address is "Emma Cartwright" (or "Ms. Emma Cartwright", or "Emma and Sam Cartwright")

There are also cases where the value for Name is the name of a business and that name appears as part of another customer's Address, or Email, or something.

What I'm doing right now is manually taking each value in the Name column and doing a ctrl+f to find all other cells where that value appears as part or whole of the cell value. But that is a pretty tedious and slow process. Is there a faster/easier way to highlight potential duplicates based on a kind of loose search for repeats in part or whole of values in different columns? This doesn't strictly need to catch every single possible scenario, but anything to help find potential duplicates so they can be looked at more closely would help a lot. Thanks!

Hi everyone! I'm using Excel for the first time for one of my college courses, and I'm required to run a very simple regression. For some reason, when I do so, my regression is blank on the new worksheet. The black lines are there to format the regression data, but there are no actual data values anywhere. Has anyone else had this issue?

Hello,

I am trying to search cells B2 and E2 for the keyword "Starlink" and return a value in cell D8 if that keyword is found, and another value if it is not.

Cells B2 and E2 may contain a string of words including "Starlink" so I cannot search for an exact value, I need the formula to see if "Starlink" is contained in the cells' value. I do not need both B2 and E2 to contain it, only one or the other.

I've tried some janky =IF(search functions, I've tried some janky =XLOOKUP( functions but have yet to find a way to search for one word in several in two cells.

Your help is appreciated -

EDIT:

I suppose my example was too specific, and I also forgot to mention: cells B2 and E2 are both the starting cell of a merged cell block. So B2 is really B2:D2, and E2 is really E2:G2.

Instead of calling out B2 and E2 in the formula, is there a way to search the row instead?

i am new to excel and i need the data from the 54th row of multiple files. all the other data is useless to me. each file has 2 sheets, and i need data rom the first sheet of all files, some of which have different titles. the columns also have different titles cuz they r dates, but the data type is same. there r roughly 100 such files, (one of each month for 8 years). how do i go about this. i tried using power query but havent been able to figure out. seems like its cuz of inconsistent names. its physically implausible to change sheet n column names. what should i do

If I open a workbook I can hit ctrl [whatever] and run the macro and it works, or I can go to developer->macros and see the macro. But once I run the macro it disappears. Ctrl [whatever] doesn't work to run it and it no longer appears under developer -> macros. I can close the file and start over and its there again and works. The macro just disappears after you use it.

How can I prevent this from occurring so I can use the macro more than once or view/edit it after ive used it?

I know this is very vague but this is all the explanation I got for my next round of interviews.

It’s a case study with supporting data and I am to report my findings using excel. I’m going to assume pivot table and vlookup is a thing but I’m not quite understanding just the excel part. When I did case studies in college, we presented the final material through slides.

Good morning.
I’ve figured out how to create a drop down list however I cannot for the life of me figure out how to auto populate a cell (or group of cells) based on the drop down list selection. I’ve searched google but I’m not understanding.
Thank you for any help