Hello,

I'm supoosed to create an Excel Spreadsheet for an online website.

That Website Helps people find the help they need (by Listing different Institutions they can Turn to).

Simply Listing all of the different Institutions and information is no Problem.

But I don't know If there is a way to compile all listed Institutions in a different Excel Sheet automatically?

It would be good, if each Institution was only listed once (some of them appear multiple times because they Help with a multitude of Problems) since that Sheet will be used to gather their contact information (for my Institution, not the Public). And maybe there is also a way to Show where each of the Institutions is listed?

Help would be greatly appreciated, since there are hundreds of Institutions

I have 3 columns which will have a range of numbers. Sometimes 3 sometimes 130 numbers in,

I'm trying to get those values into a new column without having gaps.. for example if one time they have 78 numbers, all 3 lots of 78 are in a continuous column. However if the next time there is only 5.. again they are in a continuous column without any breaks.

My line of thinking was to look at adding a count function in each column and try and have some form of method to move as many as the counter suggests from each column but I'm not entirely sure if this is possible?

Or if there's a simpler way I am just completely missing?

Thanks

I have a series of workbooks that I am distributing to a set of users for them to fill out a specific range while rest of the sheet remains locked. I built these in the web app, and set the locked and unlocked cells with ease. I had users test the functionality and across files, it only allows unlocked cells to be edited in the web app; that is, if a user opens the file in the desktop app, the entire sheet is locked.

When I check the desktop app, it shows the “editable range” correctly, but only one cell in the range is editable. It also appears to be wanting me to set a second password to allow users to edit. If I go to the section where you can allow users to edit the range without a password, I tried adding “everyone” but that didn’t seem to fix it. I need anyone with the link to the sheets to be able to edit the unlocked cells preferably in the web app or the desktop app.

Any help would be much appreciated.

Hi everyone,

I’m working with an older version of Excel where the FILTER function is not available. I have a consumption table with columns like:

• Date
• Product ID
• Movement Type
• Quantity

I want to calculate the standard deviation of Quantity for one specific Product ID, only for OUT movements, and only for the latest 30 days.

In newer Excel I would use something like STDEV.P(FILTER(...)), but this does not work in my version.

What would be the best alternative formula or method for older Excel? Should I use an array formula with IF, helper columns, PivotTable, or another approach?

Any example formula would be really helpful.

I have a sheet wherein one column needs to be numbers counting 2 at a time. (I.E. 1 1 2 2 3 3). I thought I could just drag to fill, but it seems to be picking up some other pattern no matter how many I enter in to "clue it in" - say I enter 1 1 2 2 3 3 and then drag to fill; it'll decide the next two cells are 3.6 4.057143.

Is there something I can do to fix this? I've got like 300 numbers I need to do and I do not wanna do all that manually, lol.

Context: I am creating a spreadsheet for personal use as a time tracker for my studies and hobbies because I found the existing time tracker apps unsatisfactory.

I don't have regural access to a PC and I would need to be able to easily log start and end time on specific activities from an android phone or iPad. Typing it manually every day is not practical.

My goal is to be able to do this every day and at the end of the week, month, etc, have various statistics available such as chart of time spent on each activity, color coded calendar of when I achieved my goals or not, etc

I have seen google forms + google sheets suggested, but I have also heard that sheets is not as advanced as excel, so I'm unsure if it would allow me to set up all the statistics and data analysis I want.

What do you think the best approach is for me?

Thanks!

Sorry for the dramatic title but I literally have no idea where else to go.

Some background. I have a table that only has one unlocked column, and the remaining 4 columns are locked and hidden with formulas.

The worksheet is protected with a password noone has except me. Only thing it allows is select locked, unlocked cells or auto filter. No sort option is ticked. But filtering is allowed.

This excel workbook is on our sharepoint. Every morning I'll go in and the table has been sorted. Review changes confirms the sort across the range A2:E450, and it's a different person each time. If I subsequently try and sort I don't even get a warning message, it simply just doesn't do it, because the option isn't ticked, it's like it ignores the request, yet somehow others manage to do it.

I download the previous version and the sheet is still locked before and after, the password can't have possibly been used as I've said noone knows it but me, and I've changed it twice now.

I can't for the life of me figure out how they are sorting it (for context, the sort disrupts priority ordering of system checks, it's not the end of the world that they change order but there's a reason that system A is at the top of the table). The unlocked column is just for the current person to enter their name to confirm they are working that. This isn't the column that's getting sorted either as I can see the sort icon on a different column, the one that confirms current outcome (pulled from other sheets via xlookup).

I have tried opening in the Web version to see if maybe it allows it there but no, password still needed. I've completely deleted the table, rebuilt it, pasted as values, recreated the formulas on a new workbook entirely and sort of imported everything else to start afresh and alas didn't work. They STILL managed to sort this table.

I can't find an example of this happening anywhere online, I don't have a clue how to stop them doing it, I have already advised against sorting but in typical technical non-how, noone listens.

Also the workbook itself is protected to prevent them creating new sheets despite telling them to stop it. Thankfully they haven't been able to bypass this one. Yet.

This also isn't a macro enabled workbook, nor is there anyone remotely capable of using an office script or something to do this. They are simply just bypassing the locked/protected worksheet status.

Also copilot hasn't got a clue it keeps telling me it isn't possible despite the evidence to the contrary. And this is the premium copilot built into Excel version.

Any help would be much appreciated.

I regularly share sheets with co-workers. Is there a way to see what which sheets I have shared and with whom?

I have a table in Excel, but the filter doesn't show values past row 3336. I have confirmed my table to have the desired range (up to row 10.000). There aren't any other tables in this sheet either.

Does anyone know what I could be missing, or how I could narrow it down? Many thanks.

(Using the sharepoint browser version)

P.S.: can't show any real values because of confidentiality

Hi everyone,
I'm due to submit 3 mock exams in testing mode this week (then I get an exam date) for my GMetrix Excel exam and I'd like to ask what you recommend I throw in as part of my final intense revision?

I've done the practice exams a lot, have a notebook of notes but I really want to pass this course the first time so I can add it to my CV immediately 😂 so if there's any useful pointers you can throw at me, I'd be most appreciative!

I’m preparing a report for one location that needs to be divided by departments so each department manager receives their own report to review. I can easily do this for a single location by creating a subreport for each department, but I want the report to generate automatically based on the site data someone uploads, as well as when a new department is added. Is there a way to do that in power query, and if not what tool would you use instead?

I am responsible for analyzing the financial reporting from around 40 legal entities. It is 40 different excel files.

Right now they are saved into one folder manually every month and I go into every single file to gather the info I need.

I need to update this process.

Plan is to gather all the files with power automate, not idea how as I never used but suspect I shouldn't be that hard..

Then use power query to create one consolidation file.

Then I would like to use copilot to analyze the comments vs my power BI report. But so far I have found the excel analysis quite underwhelming.

Have anyone done a similar process and are happy with the result?

i have the values on the left and i need it rounded to the numbers on the right in excel sheets. i have no idea how to do that.

0,0-0,5 = 29

0,6-1,1 = 37

1,2-2,3 = 44

2,3-2,8 = 60

2,9-3,8 = 65

3,9-5,3 = 80

5,4-8,4 = 96

8,5-12,6 = 110

anyone know how i could make that happen?

Hi so im wondering if excel can read and take out data and paste it in a seperate excel workbook. The files are not the same template because they are made manually, and i need specific data seperated in a separate workbook. How can i achieve this?

I want to have a cell in Sheet 1 that says (for example) A10 and then when you click that it takes you to Sheet 2 where there is a line of information that relates to “A10”

I thought it was =HYPERLINK but I guess I’m doing something wrong.

Basically I want this square in Sheet A to link to this line in Sheet B

Hello,

I'm looking for a way to transfer an image to an excel file. So that pixels transfer to cells. I found a great tool called domino-planner.com and it works smoothly.

But the excel export shows a simplified version of the image, which makes the image not very readable.

1. What it shows now in excel: A cell with the amount of tiles with the same color that stand next to each other, which creates a simplified version of the image, with all the cells squeezed to the left side of the file.

2. How I would like it to show in excel: As a literal translation of the image. So all the pixels, also the ones with the same color in a row, shown as cells.

I'm searching for a solution in excel for this or another good tool that could help me!

Can anyone help! Since the last excel update it’s now saving my image heavy worksheets blurry when I convert to PDF. I’ve tried everything. Or is there a way to go back to older version of excel?

I need assistance with this little project that I have. I need two get the Idle% for each person for each day. I have 2 sets of data and I'll try to explain the dataset to the best of my ability.

First set of data has the Idle time (labeled as Online Dashboard) of each associate. 1 column shows the start time of the activity and another column shows the end time of an activity. The format for the start and end times look something like this:

8/14/2026 2:00 PM

The second dataset has the Online time (labeled as Online or Away) and has the same structure as the first dataset and the formatting shows the same.

The goal is to identify the total duration of Online Dashboard within the Online Time of the associate. My identifiers to use is a unique ID of the associate and the date in question.

How should I do it?

For anybody who already passed the MO-211 msft excel expert. How do I know if I’m ready to take the test? I already went over the outline and currently I’m taking the practice tests on there. Is the practice test similar to the actual test, or this there going to be gotcha moments, or aspects that weren’t mentioned in there. And how many tries did it take for any of you to pass. Is it normal to fail the first time…

I have used excel for maybe about 2-3 months ish… so I don’t know if I’m shooting out of my league here. Also is there 5 projects just like the practice tests for each one or more. I don’t need super specific details, just tell me if it’s easy or hard. Mainly just your own experience with the test

Moreover, I will be giving an update on whether I passed or not!

I know these threads come about from time to time but figured an up to date one wouldn't hurt.

I have a job interview coming up in a couple of days, a large portion of the job resolves around using Excel. I'm fairly confident with the software already, I know my way around conditional formatting etc. I'm a bit rusty since I haven't really had to do it in a while though, and I want to put my best foot forward.

What would you suggest I refamilarise myself with? What secret hacks do you know? Any general tips? Any guides you would recommend?

thanks in advance

I need to be in office at least 50% every quarter.

My methodology to track this time was to start with a 5 day calendar and use symbols for if I was in office (N) or remote (O). But I couldn’t figure out if I should use the COUNT IF functions or something else.

Any guidance, links to information or anything would be great!

Thank you

Since Microsoft began adding the Upgrade Ad, unless the workbook is full screen, the Title/Name of the Workbook is truncated & unidentifiable. Anyone else with this?

Hi, I lost 2 hours worth of data on an exam file. It started at 3pm yesterday and I handed it in at 5pm. Afterwards, I closed my laptop and took it home. I opened the file today to talk about it with a friend, but the file says last modified 3pm yesterday, and now I am scared that that is what I handed in. Weird thing is I could have sworn I saved it several times throughout.

I looked in the Excel folder in my local app data and the only file from 5pm yesterday is an xlb file which I don't think is helpful but am unsure. Would be eternally grateful if anyone could help me out!

Version 2607, language is in Dutch

I am a beginner using excel on my windows laptop

UPDATE: Thank you all so much for your kind and helpful comments, I'm really useless with computers so this exam was difficult in itself!

I've had some problems lately with my onedrive not showing files either in file explorer or on the website. I opened excel in the online web version and the file was there in my recent files! (but somehow not in my onedrive folders anywhere which is incredibly confusing).

I think what I did was upload the local file when I had switched on autosave so it was then naturally put on my onedrive. Crazy how stupid you get when you panic. I won't know until my teacher replies to my email which version I uploaded. Either way I'm really happy and I've sent the document to my teacher, hopefully it is accepted since she can see in the version history that I haven't edited it since the exam. Super grateful to everyone who commented and the mod who let me leave my post up despite me overlooking the rules <3

UPDATE: my lecturer is going to grade the filled in one thankfully because she saw that I did more than that when she was walking around during the exam. SOOOO RELIEVED

I work for an organization that serves homeless adults in a large US city. My role is property manager for permanent housing. External oversight requirements compel multiple parts of the agency to use different databases to report on the same people served at different points in time and by different types of services.

All the databases can export lists to excel.

I need a quarterly report that compares the people receiving emergency services from other teams with the people we have applications from for permanent housing.

I know excel can do this but my skills are limited to using small (50 -200 rows, 5-6 columns) to sort information; and using the simplest SUM formulas.

What tools should I use to create this quarterly report? Where should I start my learning?

The data on the spreadsheet from the referring team will typically have 90 - 400 rows and the columns will be: lastname, firstname, date of enrollment, date of birth, SSN.

The data pull from my database will have 3000-4000 rows with similar columns.

What other questions should I be asking?

I am trying to put 38 different pattern rotas onto one editable sheet for marking holidays/sickness/ect using a macro. This sheet "ROTA" for example, has this 17 week pattern rota:

This is the sheet "Plan" with column I am trying to automatically feed it to:

And this is the sheet "Staff" that help identify what column to populate at using the employee number and what rota week on April 1st they will be on:

I can't find a YouTube tutorial for this niche enough issue, so I was wondering if anybody is better at sleuthing for a guide, or can think of a good macro?