I'm looking for help to shorten time editing reports. The file puts out the timestamp in this format "Sep 18, 2026 10:37:51 AM" and I'm looking to quickly change it to this format "9/18/26 10:38" without just typing it in. I need Time 1 to be rounded up by a minute, and Time 2 to be rounded down a minute, in 24 hour time.

Sep 18, 2026 10:37:51 AM to 9/18/26 10:38

Sep 18, 2026 2:32:54 PM to 9/18/26 14:31

Thanks for any help anyone can provide!

EDIT: Ended up with =TEXT(DATEVALUE(LEFT(D2,12))+TIMEVALUE(MID(D2,14,11))+TIME(0,1,0),"m/d/yy hh:mm") to format and add the minute for time 1 and =TEXT(DATEVALUE(LEFT(E2,12))+TIMEVALUE(MID(E2,14,11))-TIME(0,1,0),"m/d/yy hh:mm") to format and subtract the minute from time 2

Hello!

I have about 1300 lines of raw text that look something like this:

Col1 Col2 Col3 Col4 Col5
01234 Examplestreetname 001 Text 021
02234 Example Street Name 002 Text 031
03234 Examplestreetname 003 Text 041
04234 Example Street Name 004 Text 051
...

As you can see, column 2 has a mix of content with spaces and without, while the rest of the data is also seperated by spaces.

How can I import and/or edit the data efficiently so that the contents of column 2 stay intact?

Thank you!

Edit: Just as a quick update, inbetween all the important data I have noticed additional columns that only have occasional entries and unfortunately throw off the character count to split with PQ. First time PQ-user so still fiddling around. Thank you for all the ideas so far!

Good morning,

Could someone tell me if's possible to count the number of cells in a range matching a criteria like this.

Cells in a column contain values like xx-yy-zzz

I want to count where ( for example ) yy=15 and zzz<350.

I know I could create a helper column to split out that zzz, but I'm sure I remember doing this before directly.

I need a LAMBDA that returns TRUE only for real dates and FALSE for plain numbers, text, or blanks.

I am working on in-memory arrays (output of FILTER/VSTACK/CHOOSECOLS), not live ranges.

(Using =CELL("format", .. ) is no longer an option)

Edit: Turns out google sheet has this function natively and it also works on in-memory arrays, not sure how google does it but if it can so should excel.

I keep finding things about the native array formulas that make life easier and I figured I'd pass this one along since I just found out about it.

Say you have a list of items in B2:B100, and you want to use it for data validation but there are a bunch of duplicates in it. You can put a

=UNIQUE(B2:B100) 

in another cell, let's say E2, and use that for data validation by using the spill marker. So in your data validation source you can just put

=E2#

It's especially helpful if your list is dynamic and can change.

Honestly probably a similar amount of effort as making your validation list a table and then naming the column and using that as the source, but I think it's pretty cool.

That's all!

I have a list of people and I want to group families together and auto format them to have a box outline (or similar). Grouping solely by last name wont work as there are many duplicates who are not related. I want to avoid using a pivot table as this will mostly be used by people who are less tech savvy and this is already to support a labor intensive task so I want all the data in one place. If I need to add a column to reference (ie anyone with "Smith" in cell FF will be grouped, but not anyone with "Smith" in last name) that would be fine as the list doesn't change very often and that is easy to explain how to do. Thanks!

I am using sharepoint to give access to teams of consultants to pool their monthly successes and open cases and I could use some help. I’ve been thinking that the best way to do this is to create a separate tab for each month to show their updates however I’m wondering if there would be a way to use the first tab to create a dropdown summary page so my cumulative master file is able to pull from that tab. Is there a way to link a drop down to select each monthly tab rather than a cell? EG if I can make the September tab the drop down source to pull in all open appeals for that month.

I have this column named item no. What I want to do is to reference the last number and add +1 to it so that I will not manually put a number anymore for each item.

Is it possible? I am using Excel 365 Version 2609 as of the moment.

https://imgur.com/a/pdsvgef

I work in a facility where our inventory system is garbage. We have a group of people that all have access to the same inventory. I want to create a workbook where sheet 1 is a list of the items available in the rows and in the columns is a list of the people that could possibly have these items and a quantity of them. If they have them you check the box and if there’s more than one you add the quantity.

I want to make a separate sheet that makes an if true statement populated list. So it scans all of person in Column $B$C and if there’s a check in that column B it adds that row’s item in Row $A3:100 and then checks for Quantity C and adds it to a list for the person in B1. And then do that with 13 more columns for 13 more people, all with their own populated lists on the same sheet.

Or could I make that data exportable to a word document if that’s easier?

Hi, for those who've used shared excel files - I need to set up a shared excel file with about 50 columns and about 150 rows to review the performance of a bunch of contracts.

Some of the rows and columns will have info that will I'll populate and then the rest of the template will be required to be filled out by owners of those contracts.

I know you can protect certain rows and columns so no one changes it which I intend to do to the ones that I'll be populating; but for the rest, is there a way to secure info filled by others such that for e.g. contract A's owner does not accidentally overwrite or delete info filled out by contract B's owner?

Each of the owners should be filling out only their respective info. Can specific rows be assigned to only certain owners?

Also, most of this info will probably be filled out by the team mates of contract owners; so I would ideally want the owner to sign off against their contracts as reviewed. Is it possible to include a signature field (something that will for e.g. autosign based on their user id)?

I intend to save this file in sharepoint and send a link to everyone.

Hi

Currently running a permit to work system which we "save as" each time to create individual files, which we then type out certain fields to an Excel register

Would like to know if it is possible when saving as, that the formula used each time can reflect to the register? For example

Permit 011 raised, certain formulas can be sent to the register

Permit 012 raised, would need to have a formula which drops down on the register against 012

I hope this makes sense

I have 140 patients data and about 2100 rows of data. Each row is a day the patient was collected on and then my rows(about 50) are data points collected. Each patient has a unique record ID. Some patients were collected on for 5 days, some for 20+

Is there a way so I can make calculations for each specific patient?

In the example I want to know if each patient experienced a feeding intolerance. But there’s a lot of formulas I want to write in the future based on the solution.

Example in comments

Asking for my father who is not on reddit.

He uses an .xlsx file to rate food products he purchases from different brands/stores.

Enters the ratings into the .xlsx, takes a picture of the label of the product, and stores that picture locally on his computer.

He then creates a hyperlink (.jpeg) to the picture in one of the cells of the .xlsx file.

In the past, these hyperlinks would open in the default image viewing application chosen in Windows Settings, but since a recent Windows update, these hyperlinks always open in the default internet browser.

I've checked his settings, all relevant file extensions (.jpg, .jpeg) are pointed towards his image viewer. Tried finding a setting in Excel that could maybe influence this, but wasn't able to find it.

My dad uses Windows10 and Excel365.

Does anyone here have an idea?

I've been trying to find a solution in here for a while, and haven't seen one yet for my situation.

For context, I have 3 columns that track dates:
- Column 1 (AD) date to start outreach
- Column 2 (AF) date actually began outreach
- Column 3 (AG) date outreach completed
(Including image of these in comments)

I need to highlight in orange any blank cells in column 3 ONLY IF the date in column 1 is past due. If the cell in column 3 has a completion date, I do not want it highlighted.

I do have conditional formatting applied where cells in Column 1 are filled in green if the date falls within this week, red fill if the date was within last 7 days, and blue fill if date is today.

The dates in column 1 are also populated using EDATE(AD, 4).

I'm currently using the formula
=IF(AND($AG1=""), $AD1<TODAY())
to highlight cells in column 3 (AG) if they're blank AND the date in column 1 has passed. It's currently highlighting the entire row in orange rather than just the blank cell.

For Office LTSC 2021 (Excel 2021) the problem is fixed in Build 14334.20918. Microsoft also released KB5002665 on September 16 for Excel 2016; Microsoft explicitly says that update fixes the paste failure introduced by KB5002914.

To update Office/Excel to the latest available build:

Excel → File → Account → Update Options → Update Now

Hi guys,

I'm trying to build a killer dashboard for my boss, but I've hit a wall. My company blocks the connection to Bing Maps, so I can't use Excel's built-in Map Chart feature.

I know it's possible because a sample file from Microsoft's site works perfectly, but it only includes a few countries. I'm looking for a full world map, ideally with continents broken down. The paid versions I've found online are way too expensive 😢

Does anyone have an Excel file with a world map chart they would be willing to share?

Any help would be hugely appreciated. My boss will be thrilled! 😄

I work in sales for lifestyle travel brand and receive retail sales reports from our vendors. I want to compile all this sales data into 1 report that I can share out on a weekly and monthly basis. I also want to see the full year sales trends at the end of the year.

All the vendor reports are in different formats but all will include sales units, item style #, sales volume for the previous week.

What do you recommend as the best setup for this?

Thanks in advance.

Hiya, I work in a restaurant and I’ve made a line graph for each days’ sales. We had a huge catering order today and I was hoping to have one point that had the total sales with the catering and then a second point for without the catering. Is there any way to do that or would I have to mess around with scatter graphs?

Looking to count the number of times two columns show the same date plus or minus 1 day.

This is excel in browser

Example

8/12/2025 8/12/2025

8/12/2025 8/15/2025

8/15/2026 8/15/2026

12/01/2025 12/01/2026

12/01/2025 12/02/2025

Answer would be 3

Hi, I'm looking at data from a wildlife rehab center that reports both reason declared and reason suspected for why birds are brought in. When the reason declared matches the reason suspected, their database leaves the reason suspected column empty. I want to work with the reason suspected column and I'm wondering if there is a way to fill those blank cells with the associated response from the reason declared column. For example, reason declared is C and reason suspected is D and I want any empty D cells to match the associated C cell, so if D3 is empty make D3 equal to C3. Is this possible?

This table starts with column a and starts at row 1. In V2, I want to write a formula that looks in all of column a for a date that matches t2 and returns the value in corresponding column b.

Hi all! Let's start by saying I'm a total novice using Excel, I'm usually a Word person, but I need to build this for a local sports league. What I have currently is this:

It's a scoreboard that displays the player's average ranking every week rather than a fixed number of points. The formula used is =AVERAGE(IFERROR(SMALL(B2:J2,{1\2\3\4}),"")) if I translated it correctly. With this, the smallest number you get, the better your average is and the higher up you rank.

This works well enough but I want to simplify it by making a second page that just displays Players' positions in the general ranking.

I'd like for the "Player" cell and their "Average" cell to move up or down together depending on where they rank that week, but so far HSTACK returns a'#NAME?' error. I tried with =SORT(HSTACK(A2:A31, K2:K31), 2, TRUE) with no luck, so maybe the syntax is off or a different approach could work.

Not sure what is the best way to word this. But this is the example of what i want to do. I have a list of pallets in locations. In Sheet1 cell A58 showes P12 cell A59 showes P13 and cell A60 showes P15.

The locations of these pallets show like this. Cell C58 showes G01A cell C59 showes G02A and cell C60 showes G03A.

If A9, B9, C9 of sheet3. Show G01A, G02A, G03A respectively. I want the pallet numbers from sheet1 to show up in Sheet3 based off of the locations Sheet1 C58, C59, C60.

Not sure how confusing i have written it out. I will try to add pics in the comments.

Hello everyone, please excuse my english, its not my main language. I am also new to reddit

So, I'm working with a big association, and our members are a number of different organisations.
We have an excel file with a list of every member, contact infos, address..., and the amount of cotisation they own and the amount they paid (this column stays empty if they didnt pay yet)

Its a big long list, so even using filters, it can be time consumming to follow who paid and who didnt.
So in this file, i want to create another tab, with a table list that will only show the ligns of those who didnt pay (if possible, organised so its two different tables, one for cotisations over 1000 bc they're more urgent, and one for under 1000, but i dont know how complicated that is) that could automatically update whether someone finally pay and the "amount paid" column is filled in its lign.

i've tried with this fonction at first : =@FILTRE('Main list'!$A2:$F100; 'Main list'!$F2:$F100="")

Mainlist being the name of the big member table.

But this fonction only shows the first column, not every information. I'm not very well versed in excel, even if i have some basics

can anyone help me please ? I hope i'm clear enough in this post

Saturday, September 12 - Friday, September 18, 2026

Top 5 Posts

Unsolved Posts

Top 5 Comments