r/excel

I've created a report spreadsheet that uses formulas. I'm also writing a process document detailing how to use the spreadsheet.

If a user needs to extend the number of rows that contain a formula, they can click in the last cell that contains the formula, then drag the cell border down to add the formula to however many rows they need, automatically updating cell references.

Pretty standard stuff, but what I need is the way for keyboard-only users to do this.

I have a question, i couldnt find answer on internet. How and what function to use to count with multiple criterias but criteria ranges are different, rows are different to be precise. For example in 3 rows i have 3 players who played that day (one below other, 1st, 2nd and 3rd row) and in 4th row i have "win" or "loss". So i wanna use function if i can, to count how many times one particular player played and in same week they won ? And to be clear there are 30+ players and they are changing from day to day.

I posted an excel sheet in a discord online and noticed that in the share tab I can see people viewing the post with emails that had their full name on it, likely unintentionally. Can other people see the email list and is there a way to make the emails anonymous?

Hello Excel gurus!

I have wasted quite a bit of time trying to figure this out. I'm hopeful that Reddit can save me. :)

My department inherited a spreadsheet that calculates how many hours of time we spend traveling. The original spreadsheet was married to the format of a PDF flight itinerary that our travel people used. The travel people changed the spreadsheet (somehow - I don't know how/what - it looks the same to me) so now the old spreadsheet returns nearly all value! errors. The goal is to copy/paste the PDF into A2 and the rest of the sheet does the *magic*. Ultimately, said magic dumps into another tab.

Here's the before/after of the original spreadsheet:

Before Clicking Checkbox

After Clicking Checkbox - Middle column

I dumped the old spreadsheet into Google Sheets to unprotect it and aim to reverse engineer the *magic*. Most of the *magic* is back and jives with the new PDF format. (See below, colorful spreadsheet.)

The only thing (I think - TBD this thread, I guess) I can't seem to figure out is why the checkboxes in row 3 don't work (below, what appears in the snips to be my second row with boxes all checked). Checkboxes in rows 2 and 4 work. I've tried dragging the cells from 2 into 3, from 4 into 3, and I've tried going from column G into F (I've tried every iteration of copy/paste that I know and I've tried every iteration of copy/paste that right clicking offers). Design Mode is off for all of the checkboxes. When I right click the checkbox, the Format Control cell link is linked to the cell of the checkbox (as applicable for each column).

New Spreadsheet Example - All checkboxes checked in row with the issues.

New Spreadsheet Example - All boxes unchecked (no changes that I can tell)

The largest sheet I have made in the past was seven columns.

Any help that can be provided, is much appreciated!

teat me as a beginning beginner pre-beginner level user

4 columns - uniqueid, email, name, company

I will export to CSV and can import only the first 3 into the program.

Before exporting, within Excel, how would you attack this :

Where name is missing, populate it with the company if it exists

uniqueid,name,email,company
00011,CindyLou Who,cwho@company.tld,
00012,,grinch@company2.tld,Grinchdom
00013,,sally@company3.tld,
00014,Patrick,pat@spongebob.tld,Spongey
00015,,bob@spongebob.tld,Spongey

desired:

uniqueid,name,email
00011,CindyLou Who,cwho@company.tld
00012,Grinchdom,grinch@company2.tld
00013,,sally@company3.tld
00014,Patrick,pat@spongebob.tld
00015,Spongey,bob@spongebob.tld

I work in a large database of parts numbers (xxxx-xxx01, xxxxx-xxx02, and so on).

Each of these parts have changes made to them, but with different start dates. therefore, I need a formula that can recognise a date and only sum the months included within that range.

for example:

xxxxx-xxx01 (start: Apr) = sum of all months Apr to March

the next line may be;

xxxxx-xxx01 (start: Jul) = sum of all months Jul to March.

I have a diagram of this prepared if you need me to show you via DM (I can't upload due to sub Reddit rules).

how can I do this?

Ive got a checklist to manage expiry dates of medications and amount of stock in an ambulance.

Ive got 12 sheets (one for each month) in the document.

Is there a way for me to edit the data in one sheet and have it populate all the subsequent ones, then be able to repeat it again in subsequent sheets if needed?

Cheers.

i did it again! so now short dates show with a comma between the numbers, instead of a slash like it used to. i can get around this by making a custom date format, but when i display the system provided date formats, it uses a comma instead of a slash. what the heck did i do this time?

https://preview.redd.it/fk1jjuu0cfug1.png?width=217&format=png&auto=webp&s=cd614992772c2046fc800b0b4ebc5ea1526cdc0a

https://preview.redd.it/oef3v104efug1.png?width=269&format=png&auto=webp&s=95a7e2114983be0d98a64c31004b4cdd97e66e9c

and, i used to be able to enter a date like this 4-24, and it would make it 4/24/26.

i would like that to come back also. is there something i can reset?

I recently transitioned to a non-clinical role in a public health care system. part of the on-boarding was a 12 page, 20 step tutorial on how to 'do the macros'. The workflow simplified is:

- Get source data from EHR/BI

- Open the excel online (microsoft 365) "Daily Review" workbook in the desktop ms excel. (hopes and prayers it doesn't crash)

- copy data (columns of patient ID, demographics, medications... you get the idea) from EHR, paste into this Daily Review

- run macro (click a button) which cleans, filters, applies conditional formatting i think

- save

- go back to excel online and resume editing there.

The VBA code was created (not sure if it was written coz it has no documentation) by a colleague who is on extended mat leave. I can see a lot of 'modules'. Can't tell which is active. There are probably lots of historical decisions.

The daily review file with its many many sheets is saved in multiple locations in case newcomers like me or others break it by accident. I am told we can't change anything like move a column closer to the beginning coz well we can't.

I don't know VBA but could probably figure it out if I watch a tutorial on it. I am linux user and know basics of C, python and make good use of my claude code with the pro subscription but never really worked with spreadsheets.

I am wondering if anyone was in a similar situation and how you managed it. Is moving to office scripts (typescript) a viable alternative? Any other life improving tips would be appreciate it. Or maybe I should just give up and focus the energy elsewhere?

I want to create an excel sheet for balance sheets in which I type in one format and it automatically gets converted into another format as per the Act. I had trouble explaining it to chat gpt. Can anyone please recommend the prompt for Ai or recommend any tools that I can use myself for this automation. Also I can't use simple formulas as with every new balance sheet there is a little change in contents.

I am trying to format numbers with hypens in Excel. After a custom format of 00000-0000-00 most worked, but the numbers with leading zeros did not. When I click in the formula bar and enter it changes my number from 00781202001 to 0007-8120-20. How can I apply the same format to the ones with leading zeros and not change the actual number? This is a copy and paste values so it transferred in as General format. If this makes a difference, the Excel options are set to automatically insert a decimal point. Thanks in advance for any advice.

https://preview.redd.it/3b86aete7fug1.png?width=106&format=png&auto=webp&s=1401c0c02f01f99ef8a27becda4410479bd3c79d

Hi everyone,

My manager as me to find a way to automate a daily task for work and need some advice.

I have an Excel file, and I want to:

1. Automatically take a screenshot of a specific range
2. Save it as an image
3. Send it to a WhatsApp contact/group
4. Run this every day at the same time

I’ve looked into Power Automate, VBA, and Python, but not sure what’s the best approach especially for the WhatsApp part.

Ia it possible to do it?

At work we have a file, that used to be set up in a way, where no matter what date format you use (dd.mm.yy ; mm.dd.yy ; d.m.yy ; m.d.yy ; dd/mm/yyyy ; dd/mm/yy ; ...) it would always visually adjust to the current users system settings and always read the input as date.

So if one coworker used and typed dd/mm/yyyy, he would see all dates in the table like that.
While I use dd.mm.yy and I would see all date like that.

I hope the explanation makes sense...

this stopped working last year, and I tried what internet suggested:
Changing the user settings in OS to a format they use.
Changing it to a adjustable format so everyone has their own format
and now it is all set to a firm format (dd.mm.yy) so it displays the same for everyone and it doesn’t matter if they type it with slashes (dd/mm/yy ; dd/mm/yyyy) but if someone types specifically in dd.mm.yyyy format it doesnt recognize it as a date anymore...

I feel insane at this point!

As soon as I start working on a sheet, the option to select a sheet at the bottom disappears, and I don't know how to get it back.

(reposted first post got removed) I'm not certain the IF formula(s) are what I need but I'm not sure what else to use. Trying to create a spreadsheet for work: the premise is that if one or two people are the Contact for a project, they will split 5% of the project's earnings, each getting 2.5%; if only one person, they get 5%. The same for if one or two people who are the Winners for the project. I need some way for the spreadsheet to be able to see that if someone's initials are under either Contact or Winner, to then give them either 5% of the net income if they are the only Contact or only Winner, or 2.5% if they share either spot with someone else. The total amount of the net income given out as a bonus will always come to 10%. The first picture shows my 'backend' sheet and a formula I was trying that would calculate 2.5% of the Net Income if someone's initials showed up on the project, but this doesn't work if their initials only show up once because then they would need to get 5%. I would also hope there would be a less clunky way to do this many calculations. The second picture is a section of the main page of the sheet showing the Contact and Winner columns, the Net Income the bonus comes out of, and then the Total C/W amount under everyone's initials that adds up their total bonuses.

Backend sheet, 'points' refers to first sheet

First sheet of spreadsheet

Please let me know if I have not been thorough enough with explaining what I'm trying to do, I'm so deep in this now that I am really really confused and just need help straightening this all out. Using newest version of Excel on a macbook, have also been working on same spreadsheet in Windows. I'm not a beginner at excel but not all that good either. TYSM in advance.

Hi all, need help figuring out if there’s a solution to this. My coworker has a large data set and needs to verify/validate the data in Column A to Column F. Column A contains only the name of the project and column F contains a one-word label (there’s only two labels) that the project falls under. For example, Bumblebee project is labeled as “Ongoing” vs “Completed”. Issue is there is some mismatch and some projects should go under the other label, vice versa. I understand we need to have a clear distinction of what should be one label vs the other, but is there a way to validate this data without going line by line?

I'm trying to figure out a formula but am not sure if it's even possible...

• A1 = manually entered date (mo/day/year)
• B1 = returns the next July 1 (formula needed)
• Example dates:
  • A1 = 9/1/2025; B1 = 7/1/2026
  • A1 = 4/2/2026; B1 = 7/1/2026

I've used =IF(Q118="","",DATE(YEAR(Q118)+2,MONTH(Q118),DAY(Q118))) in a different area but this formula returns A1+2 years and as A1 has no set input, I can't add months.

Thoughts? Thank you.

Hey all, looking to put together a dynamic time sheet where the week’s billed hours appear in a table on top. I have a column for dates and corresponding column for the hours that day. How would I go about rolling up the entire week?

I created a worksheet that required me to lock certain cells. The worksheet needed editing so I removed the protection so I could add additional columns. One of the two columns needs to be protected, while the other needs to be unlocked for data input. I made the unlocked range in the mange protection window and resumed protection on the worksheet but all new columns remained unlocked. All original cells on the worksheet (before the new colums) still lock and those that were put in an unlocked range remain unlocked.

I am predominately working in the browser mode. I have used the desktop app to make sure all cells are locked in the fromat cells > protection settings.

In the Manage Protection settings under options "Select locked celld" and "Select unlocked cells" are checked, everything else is unchecked.

hi there, i need help. i have multiple sheet for each staff that work part time. how can i get their name from each of this sheet, and make it as a list on new sheet. i have somewhere around 170sheet. their name is store in one cell on each sheet. hope someone could help.